Why use a using statement with a SqlTransaction?

by

A using statement should be used every time you create an instance of a class that implements IDisposable within the scope of a block. It ensures that the Dispose() method will be called on that instance, whether or not an exception is thrown.

In particular, your code only catches managed exceptions, then destroys the stack frame by throwing a new exception instead of rethrowing the existing one.

The correct way to do it is:

using (SqlConnection cn = new SqlConnection(ConfigurationManager.AppSettings["T3"])) {
    cn.Open();
    using (SqlTransaction tr = cn.BeginTransaction()) {
        //some code
        tr.Commit();
    }
}

Note that if your class has instance members of types that implement IDisposable, then your class must implement IDisposable itself, and dispose of those members during its own Dispose() call.

More Related Contents:

  1. What are the uses of “using” in C#?
  2. What is the C# Using block and why should I use it? [duplicate]
  3. The type or namespace name could not be found [duplicate]
  4. ‘using’ statement vs ‘try finally’
  5. try/catch + using, right syntax
  6. returning in the middle of a using block
  7. What happens if i return before the end of using statement? Will the dispose be called?
  8. SqlCommand with using statement
  9. Does Dispose still get called when exception is thrown inside of a using statement?
  10. Will a using statement rollback a database transaction if an error occurs?
  11. The C# using statement, SQL, and SqlConnection
  12. Do using statements and await keywords play nicely in c#
  13. What and when is “using” block used for in C#? How to use “using” block in C#?
  14. When is “using” block used for in C#? How to use “using” block in C#?
  15. When should I use the using Statement? [duplicate]
  16. How to handle WCF exceptions (consolidated list with code)
  17. using statement with multiple variables [duplicate]
  18. Convert string[] to Array
  19. I see an error CS8070 . How i can fix the error?
  20. Winforms Double Buffering
  21. ASP.NET Core Web API exception handling
  22. Make first letter of a string upper case (with maximum performance)
  23. Efficient way to remove ALL whitespace from String?
  24. What does “where T : class, new()” mean?
  25. Custom method names in ASP.NET Web API
  26. C# mvc 3 using selectlist with selected value in view
  27. How to achieve remove_if functionality in .NET ConcurrentDictionary
  28. Sending and receiving UDP packets between two programs on the same computer
  29. What is the “base class” for numeric value types?
  30. Why doesn’t C# use arithmetic overflow checking by default? [duplicate]

Leave a Comment