我们有一个问题要使用TransactionScope. TransactionScope让我们非常好的灵活性在我们的数据访问层使用事务.这样我们可以使用隐式或者显式的交易.有一些性能再次提升ADO.NET的交易,但在这个时候这并不是真的问题.但是我们有锁定的问题.在下面的示例代码中,虽然隔离级别设置为ReadCommitted,但是不可能在表testTable上从其他客户端进行Select sql语句,直到主事务(在Main方法中)将被提交,因为整个表上都有锁定.我们还尝试在所有方法中使用一个连接,但是同样的行为.我们的DBMS是sql Server 2008.有没有什么我们不明白？

问候
安东·卡尔奇克

请参阅此示例代码：

class Program
{
    public class DAL
    {
        private const string _connectionString = @"Data Source=localhost\fsdf;Initial Catalog=fasdfsa;Integrated Security=SSPI;";

        private const string inserttStr = @"INSERT INTO dbo.testTable (test) VALUES(@test);";

        /// <summary>
        /// Execute command on DBMS.
        /// </summary>
        /// <param name="command">Command to execute.</param>
        private void ExecuteNonQuery(IDbCommand command)
        {
            if (command == null)
                throw new ArgumentNullException("Parameter 'command' can't be null!");

            using (IDbConnection connection = new sqlConnection(_connectionString))
            {
                command.Connection = connection;
                connection.Open();
                command.ExecuteNonQuery();
            }
        }

        public void FirstMethod()
        {
            IDbCommand command = new sqlCommand(inserttStr);
            command.Parameters.Add(new sqlParameter("@test","Hello1"));

            using (TransactionScope sc = new TransactionScope(TransactionScopeOption.required))
            {
                ExecuteNonQuery(command);
                sc.Complete();
            }
        }

        public void SecondMethod()
        {
            IDbCommand command = new sqlCommand(inserttStr);
            command.Parameters.Add(new sqlParameter("@test","Hello2"));

            using (TransactionScope sc = new TransactionScope(TransactionScopeOption.required))
            {
                ExecuteNonQuery(command);
                sc.Complete();
            }
        }
    }

    static void Main(string[] args)
    {

        DAL dal = new DAL();
        TransactionOptions tso = new TransactionOptions();
        tso.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;

        using (TransactionScope sc = new TransactionScope(TransactionScopeOption.required,tso))
        {
            dal.FirstMethod();
            dal.SecondMethod();
            sc.Complete();
        }
    }
}