public void EnsureTransactionIsCreatedDependingOnParentTransactionScope() { IDriver driver = new SqlServer(); driver.Initialize("Data Source=EUSS;Initial Catalog=uss2;Integrated Security=true"); IDbConnection connection = driver.CreateConnection(); connection.Open(); IDbTransaction transaction = connection.BeginTransaction(); Assert.AreEqual(System.Data.IsolationLevel.ReadCommitted, transaction.IsolationLevel); transaction.Rollback(); using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, new TransactionOptions() { IsolationLevel = System.Transactions.IsolationLevel.ReadUncommitted })) { transaction = driver.BeginTransaction(connection); Assert.AreEqual(System.Data.IsolationLevel.ReadUncommitted, transaction.IsolationLevel); transaction.Rollback(); } using (TransactionScope scope1 = new TransactionScope(TransactionScopeOption.RequiresNew, new TransactionOptions() { IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted })) { using (TransactionScope scope2 = new TransactionScope(TransactionScopeOption.RequiresNew, new TransactionOptions() { IsolationLevel = System.Transactions.IsolationLevel.ReadUncommitted })) { transaction = driver.BeginTransaction(connection); Assert.AreEqual(System.Data.IsolationLevel.ReadUncommitted, transaction.IsolationLevel); transaction.Rollback(); } } connection.Close(); }
public SqlMapperProvider() { Driver = new Drivers.SqlServer(); Dialect = new Dialects.SqlServer(); //this.TypeResolver = new TypeResolver.TypeResolverImpl(); this.Serializer = new Serializer.BinarySerializer(); }