The C# using statement, SQL, and SqlConnection

by

It’s possible to do so in C# (I also see that code is exactly shown in MSDN http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.executenonquery.aspx). However, if you need to be defensive and for example log potential exceptions which would help troubleshooting in a production environment, you can take this approach:

private static void CreateCommand(string queryString,
string connectionString)
{
    using (SqlConnection connection = new SqlConnection(
           connectionString))
    {
        try
        {
            SqlCommand command = new SqlCommand(queryString, connection);
            command.Connection.Open();
            command.ExecuteNonQuery();
        }
        catch (InvalidOperationException)
        {
            //log and/or rethrow or ignore
        }
        catch (SqlException)
        {
            //log and/or rethrow or ignore
        }
        catch (ArgumentException)
        {
            //log and/or rethrow or ignore
        }
    }
}

More Related Contents:

  1. How do I update a value in C# and SQL Server? [closed]
  2. Store value in Yes/No field in Access using C#
  3. How to save leap date ’02/29/2006′ to sql server database? [duplicate]
  4. how to get date difference between two dates using DateDiff Excluding the weekends [duplicate]
  5. What is the C# Using block and why should I use it? [duplicate]
  6. C# Data Connections Best Practice?
  7. Is there a good LINQ way to do a cartesian product?
  8. Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints
  9. Read SQL Table into C# DataTable
  10. LINQ to SQL – Left Outer Join with multiple join conditions
  11. ‘using’ statement vs ‘try finally’
  12. How to save image in database using C# [closed]
  13. Code to validate SQL Scripts
  14. How to access ssis package variables inside script component
  15. Does Dispose still get called when exception is thrown inside of a using statement?
  16. Why use a using statement with a SqlTransaction?
  17. C# constructing parameter query SQL – LIKE %
  18. Generate class from database table
  19. Passing a SQL parameter to an IN() clause using typed datasets in .NET
  20. What is passing parameters to SQL and why do I need it?
  21. When is “using” block used for in C#? How to use “using” block in C#?
  22. How do I translate a List into a SqlParameter for a Sql In statement? [duplicate]
  23. Calling a SQL User-defined function in a LINQ query
  24. Enabling Foreign key constraints in SQLite
  25. no overload for method “ToString” takes 1 arguments
  26. How to handle WCF exceptions (consolidated list with code)
  27. Mapping columns in a DataTable to a SQL table with SqlBulkCopy
  28. Querying data using Entity Framework from dynamically created table
  29. Microsoft.Jet.OLEDB.4.0 Converting Characters
  30. SQL connection string for microsoft access 2010 .accdb

Leave a Comment