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);
}