Exceptions specific for SQL Server database operations

Question

When catching an exception on a database reading/writing operation, what specific exceptions should I try to catch in a Try-Catch construction?

try
{
   MyDatabaseHandlingMethod();             
}
catch (exception ex)//what to use instead of just "exception"?
{
    //exception handling
}

What are those exceptions to use instead of just "exception" in case of trying to perform a database related operation? (like IOException in case of file handling operations)

Are you looking for SqlException Error codes? see stackoverflow.com/questions/380547/… — user604613
– user604613, Commented Jul 6, 2011 at 11:47

marc_s · Accepted Answer · 2011-07-06 11:45:22Z

2

SQL Server exceptions will be of type SqlException - they contain an Errors collection that holds a list of SqlError objects that contain the detailed information about the exception.

For reference see MSDN:

answered Jul 6, 2011 at 11:45

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

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

Comments

Martijn Pieters · Accepted Answer · 2015-09-04 07:38:00Z

1

You probably need to handle SqlException that has Number property.

edited Sep 4, 2015 at 7:38

Martijn Pieters

1.1m326 gold badges4.2k silver badges3.4k bronze badges

answered Jul 6, 2011 at 11:46

EgorBo

6,1723 gold badges37 silver badges40 bronze badges

Collectives™ on Stack Overflow

Exceptions specific for SQL Server database operations

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related