是否需要指定任何事务语法？
(当我调试时,我可以看到我检索到了正确的记录.)

using (conn = new sqlConnection(MyConnectionString))
                using (sqlCommand cmd = new sqlCommand("dbo.MyProcedure",conn))
                {
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.Parameters.AddWithValue("@Count",count);
                    conn.Open();
                    using (sqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection))
                    {
                        while (reader.Read())
                        {
                            // wrapper object,not related to database
                            SampleModel c = new SampleModel();  
                            c.ID= (string)reader["ID"];
                            c.Name = (string)reader["Name"];
                            c.Type = (int)reader["Type"];

                            // modeList will return to outside,not related to database
                            modelList.Add(c);

                            sampleTable1  table1 = context.sampleTable1s.SingleOrDefault(t=> t.id = c.ID);   

                            // try to update the "isRead",but it doesn`t work....!!!
                            // about the datatype,in the data base,it is "smallInt"
                            // in linq to sql,it is "short?"
                            // PS Default value all should be 0
                            table1.isRead = 1;
                            context.SubmitChanges();  <--- here,it doesn`t do the job // context is new from Linq to sql
                        }
                    }
                    conn.Close();
                }

这是我的程序：

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE MyProcedure    
    @Count int = 100
AS
BEGIN

  SELECT TOP (@Count )
         t1.id AS ID,t1.name AS Name,t2.type AS TYPE    
    FROM sampleTable1 as t1 with (nolock),sampleTable2 as t2 with (nolock)          
   WHERE (t1.t2Id = t2.Id)     
ORDER BY t1.name asc

END
GO

如果我将所有代码放在TransactionScope块中

using (TransactionScope scope = new TransactionScope())
{
    // all the C# code above
    scope.Complete();
}

我将得到一个例外“服务器上的MSDTC’localhost-sqlserver2005’不可用.”

如果我只放了一些代码,没有例外,但数据确实没有更新

using (TransactionScope scope = new TransactionScope())
{
    sampleTable1  table1 = context.sampleTable1s.SingleOrDefault(t=> t.id = c.ID);   

    table1.isRead = 1;
    context.SubmitChanges(); 

    scope.Complete();
}

谢谢.