public void TestOracle() { AdoNetHelper helper = null; DbConnection conn = null; DbConnection conn2 = null; using (helper = AdoNetHelper.ThreadInstance("data source=10.14.0.*:1521/orcl;user id=*;password=*;", DbProviderType.Oracle_ManagedODP)) { //创建获取由OdbcHelper管理的连接。 conn = helper.OpenNewConnection(); Assert.AreEqual(conn.State, ConnectionState.Open); //创建一个新连接 conn2 = helper.OpenNewConnection(); Assert.AreEqual(conn2.State, ConnectionState.Open); Assert.AreNotEqual(conn, conn2); //测试ThreadInstance using (AdoNetHelper helper2 = AdoNetHelper.ThreadInstance("data source=10.14.0.*:1521/orcl;user id=*;password=*;", DbProviderType.Oracle_ManagedODP)) { Assert.AreEqual(helper, helper2); } //测试trans conn = helper.OpenNewConnection(); DbTransaction trans = helper.BeginNewTrans(conn); string sql = "update **"; helper.ExecuteNonQuery(trans, CommandType.Text, sql); trans.Commit(); } //测试连接能否正常关闭。 Assert.AreEqual(conn.State, ConnectionState.Closed); Assert.AreEqual(conn2.State, ConnectionState.Closed); }