Oracle链接数据库 .net

1.首先去下载Oracle驱动oracle_net.msi

2.安装完之后在项目里面引用system.data.oracleclient

3.链接数据库的GetConnection类如下：

public class GetConnection
{
private static OracleConnection _connection;
/// <summary>
/// 获取数据库连接桥
/// </summary>
private static OracleConnection Connection
{
get
{
//Data Source=orcl_169;User ID=openeap;Password=***********;Unicode=True
string connectionString = ConfigurationManager.AppSettings["ConnectionString"];
// string connectionString = "Data Source=.;Initial Catalog=shopping;Persist Security Info=True;User ID=dkj;Password=dkj123456";
//string connectionString = "Data Source=.;Initial Catalog=shopping;Integrated Security=True";;dkj/dkj123456
if (_connection == null)
{
_connection = new OracleConnection(connectionString);
_connection.Open();
}
if (_connection.State == ConnectionState.Closed)
{
_connection.Open();
}
if (_connection.State == ConnectionState.Broken)
{
_connection.Close();
_connection.Open();
}
return GetConnection._connection;
}

}
/// <summary>
/// 获取表数据
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public static OracleDataReader GetDataRead(string sql)
{
OracleCommand command = new OracleCommand(sql, Connection);
OracleDataReader read = command.ExecuteReader();
return read;
}
public static int NoSelect(string sql)
{
OracleCommand command = new OracleCommand(sql, Connection);
int row = command.ExecuteNonQuery();
return row;
}
public static DataTable GetDataTable(string sql)
{
OracleCommand command = new OracleCommand(sql, Connection);
DataTable dt = new DataTable();
OracleDataAdapter sda = new OracleDataAdapter(command);
sda.Fill(dt);
return dt;
}
/// <summary>
/// 执行sql语句，返回一行一列。。
/// </summary>
/// <param name="sql">SQL语句</param>
/// <returns></returns>
public static string GetScalar(string sql)
{
OracleCommand command = new OracleCommand(sql, Connection);
return command.ExecuteScalar().ToString();
}

}