在TransactionScope中优先使用Oracle的.NET驱动

private const string ConnectionString = "Data Source = localhost:1521/XE; 
User ID = scott; Password = tiger"; 
private const string SqlConnectionString = "Data Source = (local); 
Initial Catalog = Northwind; Integrated Security = SSPI"; 
[TestMethod] 
public void TestOracleDriver()
{
using (TransactionScope scope = new TransactionScope())
{
Oracle.DataAccess.Client.OracleConnection connection = 
new Oracle.DataAccess.Client.OracleConnection(ConnectionString);
connection.Open();
Oracle.DataAccess.Client.OracleCommand command = connection.CreateCommand();
command.CommandText = "UPDATE DEPT SET DNAME = DNAME";
command.CommandType = CommandType.Text;
command.ExecuteNonQuery();
// 为了模拟一个分布式数据的操作，下面还增加了一段SqlConnection的DML操作。
SqlConnection sqlC = new SqlConnection(SqlConnectionString);
sqlC.Open();
SqlCommand sComm = sqlC.CreateCommand();
sComm.CommandText = "UPDATE Products SET ProductName = ProductName";
sComm.CommandType = CommandType.Text;
sComm.ExecuteNonQuery();
scope.Complete();
}
}
[TestMethod] 
public void TestMicrosoftDriver()
{
using (TransactionScope scope = new TransactionScope())
{
System.Data.OracleClient.OracleConnection connection = 
new System.Data.OracleClient.OracleConnection(ConnectionString);
connection.Open();
System.Data.OracleClient.OracleCommand command = connection.CreateCommand();
command.CommandText = "UPDATE DEPT SET DNAME = DNAME";
command.CommandType = CommandType.Text;
command.ExecuteNonQuery();
// 为了模拟一个分布式数据的操作，下面还增加了一段SqlConnection的DML操作。
SqlConnection sqlC = new SqlConnection(SqlConnectionString);
sqlC.Open();
SqlCommand sComm = sqlC.CreateCommand();
sComm.CommandText = "UPDATE Products SET ProductName = ProductName";
sComm.CommandType = CommandType.Text;
sComm.ExecuteNonQuery(); 
scope.Complete();
}
}