LINQ トランザクション処理

Previous | Next

Latest post 10-25-2008 15:43 by Yu Asano. 1 replies.

10-25-2008 15:42

Yu Asano
Joined on 10-22-2008
Japan
Posts 208
Points 0

LINQ トランザクション処理

using System;
using System.Linq;
using System.Transactions;
using System.IO;

namespace ConsoleApplication5
{
    class Program
    {
        static void Main(string[ args)
        {
            using (TransactionScope transactionScope = new TransactionScope())
            {
                Test1 db = new Test1(Settings1.Default.ConnectionString);

                StreamWriter sw = new StreamWriter(@"d:\log.txt");
                sw.AutoFlush = true;
                TextWriter tw = TextWriter.Synchronized(sw);

db.Log = tw;

                try
                {
                    var t1 = db.Table_1.First(t => t.ID == 1);
                    var t2 = db.Table_1.First(t => t.ID == 2);

t1.Number = 1111;
t2.Number = 2222;

db.SubmitChanges();

                    transactionScope.Complete();
                }
                catch (Exception e)
                {
                    Console.WriteLine(e.Message);
                }
            }
        }
    }
}

Filed under: TransactionScope, LINQ

Post Points: 0

10-25-2008 15:43 In reply to

Yu Asano
Joined on 10-22-2008
Japan
Posts 208
Points 0

Re: LINQ トランザクション処理

Contact

SELECT TOP (1) [t0].[ID], [t0].[Number]
FROM [dbo].[Table_1] AS [t0]
WHERE [t0].[ID] = @p0
-- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [1]
-- Context: SqlProvider(Sql2005) Model: AttributedMetaModel Build: 3.5.21022.8

SELECT TOP (1) [t0].[ID], [t0].[Number]
FROM [dbo].[Table_1] AS [t0]
WHERE [t0].[ID] = @p0
-- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [2]
-- Context: SqlProvider(Sql2005) Model: AttributedMetaModel Build: 3.5.21022.8

UPDATE [dbo].[Table_1]
SET [Number] = @p2
WHERE ([ID] = @p0) AND ([Number] = @p1)
-- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [1]
-- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [111]
-- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [1111]
-- Context: SqlProvider(Sql2005) Model: AttributedMetaModel Build: 3.5.21022.8

UPDATE [dbo].[Table_1]
SET [Number] = @p2
WHERE ([ID] = @p0) AND ([Number] = @p1)
-- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [2]
-- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [222]
-- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [2222]
-- Context: SqlProvider(Sql2005) Model: AttributedMetaModel Build: 3.5.21022.8

Post Points: 0

Page 1 of 1 (2 items) | RSS