Reprint to: http://www.cnblogs.com/gguozhenqian/p/4262813.html
There is a feature in the project that needs to get data from an Oracle database, which was thought to be very simple, and changed the original SqlClient into a OracleClient call.
The result is far less simple than you think. There are a lot of needs to install Oracle client, just the project is very urgent, the company also has no Oracle environment, can make me nasty. After searching this area online,
Too many articles, but also to continue to test, choice, are almost bored. Finally found me a friend, he directly helped me to write a demo, I changed the connection string,
I was very grateful to him for the successful connection. This DLL is actually provided by Oracle for C #, and it can be downloaded to the official (but it's cumbersome to find).
Here I will share this program and DLL to everyone.
Operation Steps:
- DLL after download and reference: Oracle.ManagedDataAccess.zip after download, put Oracle.ManagedDataAccess.dll into your project and then reference
- Direct Invocation (connstring changes to its own connection string)?
1234567891011121314151617 |
using Oracle.ManagedDataAccess.Client;
public static string ConnectOracle()
{
try
{
string connString =
"Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=130.147.246.144)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ECMS)));Persist Security Info=True;User ID=system;Password=Service01;"
;
OracleConnection con =
new OracleConnection(connString);
con.Open();
return string
.Empty;
}
catch (Exception ex)
{
return ex.ToString();
}
}
|
It is so simple!!!
additional Help Documentation:
Http://www.cnblogs.com/yjmyzz/archive/2013/11/01/3400999.html http://www.cnblogs.com/ly303550688/archive/2013/ 01/31/2887104.html
C # Connect to Oracle Database (direct reference DLL usage)