SQLServer Compact Edition

SQLServerCeで行ロックがかかっているかの実験。

view plainprint?

1. using (var connection1 = new SqlCeConnection(Settings.Default.Setting))  
2. using (var connection2 = new SqlCeConnection(Settings.Default.Setting))  
3. {  
4.     connection1.Open();  
5.     connection2.Open();  
6.     var command1 = connection1.CreateCommand();  
7.     var command2 = connection2.CreateCommand();  
8.     using (var tran1 = connection1.BeginTransaction())  
9.     using (var tran2 = connection2.BeginTransaction())  
10.     {  
11.         command1.Transaction = tran1;  
12.         command2.Transaction = tran2;  
13.   
14.         command1.CommandText = "select * from table1 with (updlock) where id = 1";  
15.         command2.CommandText = "select * from table1 with (updlock) where id = 1";  
16.   
17.         using (var reader1 = command1.ExecuteReader())  
18.         using (var reader2 = command2.ExecuteReader())  
19.         {  
20.             while (reader1.Read() && reader2.Read())  
21.             {  
22.                 Console.WriteLine(reader1.GetInt32(0));  
23.                 Console.WriteLine(reader2.GetInt32(0));  
24.             }  
25.         }  
26.     }  
27. }  

using (var connection1 = new SqlCeConnection(Settings.Default.Setting))
using (var connection2 = new SqlCeConnection(Settings.Default.Setting))
{
    connection1.Open();
    connection2.Open();
    var command1 = connection1.CreateCommand();
    var command2 = connection2.CreateCommand();
    using (var tran1 = connection1.BeginTransaction())
    using (var tran2 = connection2.BeginTransaction())
    {
        command1.Transaction = tran1;
        command2.Transaction = tran2;

        command1.CommandText = "select * from table1 with (updlock) where id = 1";
        command2.CommandText = "select * from table1 with (updlock) where id = 1";

        using (var reader1 = command1.ExecuteReader())
        using (var reader2 = command2.ExecuteReader())
        {
            while (reader1.Read() && reader2.Read())
            {
                Console.WriteLine(reader1.GetInt32(0));
                Console.WriteLine(reader2.GetInt32(0));
            }
        }
    }
}

確かに。