問題描述

當我嘗試調用包含 SELECT 語句的存儲過程時出現以下錯誤:

I am getting the following error when I try to call a stored procedure that contains a SELECT Statement:

該操作對交易狀態無效

這是我的通話結構:

public void MyAddUpdateMethod()
{

    using (TransactionScope Scope = new TransactionScope(TransactionScopeOption.RequiresNew))
    {
        using(SQLServer Sql = new SQLServer(this.m_connstring))
        {
            //do my first add update statement

            //do my call to the select statement sp
            bool DoesRecordExist = this.SelectStatementCall(id)
        }
    }
}

public bool SelectStatementCall(System.Guid id)
{
    using(SQLServer Sql = new SQLServer(this.m_connstring)) //breaks on this line
    {
        //create parameters
        //
    }
}

我在事務中創建到同一個數據庫的另一個連接有問題嗎?

Is the problem with me creating another connection to the same database within the transaction?

推薦答案

經過一些研究，我似乎無法使用 TransactionScope 塊打開到同一個數據庫的兩個連接.我需要修改我的代碼看起來像這樣:

After doing some research, it seems I cannot have two connections opened to the same database with the TransactionScope block. I needed to modify my code to look like this:

public void MyAddUpdateMethod()
{
    using (TransactionScope Scope = new TransactionScope(TransactionScopeOption.RequiresNew))
    {
        using(SQLServer Sql = new SQLServer(this.m_connstring))
        {
            //do my first add update statement            
        }

        //removed the method call from the first sql server using statement
        bool DoesRecordExist = this.SelectStatementCall(id)
    }
}

public bool SelectStatementCall(System.Guid id)
{
    using(SQLServer Sql = new SQLServer(this.m_connstring))
    {
        //create parameters
    }
}

這篇關于“該操作對于交易狀態無效"錯誤和事務范圍的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！