使用的DLL：Oracle.ManagedDataAccess
Bug：OracleInternal.Common.ProviderConfig的类型初始值设定项引发异常
App.config的更改才是关键
关键应该是这个：
oracle.manageddataaccess默认情况下只支持direct connection，
如果要支持tns name，即ez connection，需要在app.config或者web.config里添加如下设置
安装后的App.config：
更改后的App.config：
去掉的节点 如下：
代码：
OracleHelper
public class OracleHelper1 { public static OracleCommand cmd = null; public static OracleConnection conn = null; public static string connstr = "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.2.98)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=JJJT)));User Id=CMSP;Password=Oracle1"; public static OracleConnection init() { try { conn = new OracleConnection(connstr); if (conn.State != ConnectionState.Open) { conn.Open(); } } catch (Exception e) { throw new Exception(e.Message.ToString()); } return conn; } public static DataSet GetDataSet(string sqlstr) { DataSet set = new DataSet(); try { init(); OracleDataAdapter adp = new OracleDataAdapter(sqlstr, conn); adp.Fill(set); conn.Close(); } catch (Exception e) { throw new Exception(e.Message.ToString()); } return set; } public static int ExecuteNonQuery(string cmdText) { int count; try { init(); cmd = new OracleCommand(cmdText, conn); count = cmd.ExecuteNonQuery(); conn.Close(); } catch (Exception ex) { throw new Exception(ex.Message.ToString()); } return count; } }
CS代码
DataTable dt1 = OracleHelper1.GetDataSet("select * from TB_PROJECTS").Tables[0];