Filtering SqlServer Command Timeout Exception for ExecReader

Question

How do get the specific exception that has caused a sql server command to happen using the SqlException object that I have caught. I want to know when a Command timeout has occured, i.e.

try
{
    // database ExecReader call
}
catch (SqlException sqlEx)
{
    // what can I test here to find if this is a command timeout exception
}

System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding

Can I test sqlEx.Number or sqlEx.ErrorCode for the command timeout. Is there a list of codes (for sqlEx.Number) and there corresponding meanings, I have googled but can't seem to find one and do the codes change depending on the version of sql server that I am using?

Thanks for any help, Nick

Community · Accepted Answer · 2017-05-23 10:30:24Z

1

Have you tried having a look here: How to catch SQLServer timeout exceptions ?

edited May 23, 2017 at 10:30

CommunityBot

11 silver badge

answered Sep 20, 2010 at 15:29

openshac

5,1936 gold badges48 silver badges83 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Filtering SqlServer Command Timeout Exception for ExecReader

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related