Obtain the Query/CommandText that caused a SQLException

c# sqlexception
Doctor Jones picture Doctor Jones · Jun 3, 2010 · Viewed 7.6k times · Source

I've got a logger that records exception information for our in house applications.

When we log SQL exceptions it'd be super useful if we could see the actual query that caused the exception.

Is there a way we can achieve this?

Answer

Steven picture Steven · Jun 3, 2010

The SqlException does not hold a reference to the SqlCommand that caused the exception. In your logger there is no way to do this. What you could do is catch the SqlException in the method that executes the SqlCommand and wrap it in a more descriptive exception. Example:

using (var command = new SqlCommand(connection, "dbo.MyProc"))
{
    try
    {
        command.Execute();
    }
    catch (DbException ex)
    {
        throw new InvalidOperationException(ex.Message + " - " + command.Text, ex);
    }
}

This way you can log this more expressive exception.

Related questions

How to catch a specific SqlException error?

Q: Is there a better way to handle SqlExceptions? The below examples rely on interpreting the text in the message. Eg1: I have an existing try catch to handle if a table does not exist. Ignore the fact that I …

Read More
how do I fix SqlException Time-out occurred while waiting for buffer latch type 2 for page (1:37660679), database ID 10

I was running an application for a few hours and then suddenly: SqlException was unhandled by user code: Time-out occurred while waiting for buffer latch type 2 for page (1:37660679), database ID 10. Viewing details of the exception shows it is a "Number" "845". …

Read More
C# try catch confusion

I'm very new to C#. When I try catch something like this: try { connection.Open(); command.ExecuteNonQuery(); } catch(SqlException ex) { MessageBox.Show("there was an issue!"); } How do I know if the problem happened with the Open or ExecuteNonQuery? What …

Read More