“The operation is not valid for the state of the transaction” error and transaction scope

by

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
    }
}

More Related Contents:

  1. TransactionScope automatically escalating to MSDTC on some machines?
  2. How to use TransactionScope in C#?
  3. How does TransactionScope roll back transactions?
  4. C# – System.Transactions.TransactionScope
  5. ExecuteReader requires an open and available Connection. The connection’s current state is Connecting
  6. Transactions in .net
  7. C# Equivalent of SQL Server DataTypes
  8. How to directly execute SQL query in C#?
  9. SqlConnection SqlCommand SqlDataReader IDisposable
  10. How to catch SQLServer timeout exceptions
  11. Code to validate SQL Scripts
  12. Queuing in OneWay WCF Messages using Windows Service and SQL Server
  13. MultipleActiveResultSets=True or multiple connections?
  14. C# controlling a transaction across multiple databases
  15. SqlConnection.Close() inside using statement
  16. Received an invalid column length from the bcp client for colid 6
  17. Entity Framework 6 transaction rollback
  18. Failed to update .mdf database because the database is read-only (Windows application)
  19. Horrible performance using SqlCommand Async methods with large data
  20. Is it better to execute many sql commands with one connection, or reconnect every time?
  21. Is there a .NET equivalent to SQL Server’s newsequentialid()
  22. Know when to retry or fail when calling SQL Server from C#?
  23. How to Specify Primary Key Name in EF-Code-First
  24. Upload CSV file to SQL server
  25. What is the equivalent of bigint in C#?
  26. Use SQL Server time datatype in C#.NET application?
  27. Should the order of LINQ query clauses affect Entity Framework performance?
  28. How do I connect to a SQL database from C#?
  29. Generating sql code programmatically
  30. Is SqlConnection.Close() need inside a Using statement?

Leave a Comment