Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

.NET SqlClient Error Number Enum Type

I have an exception handler for the type SqlException and I'm looking at the SqlException.Number property of the exception to determine if a dead-lock occurred (1205). I'm currious, instead of writing SqlException.Number == 1205, is there an enum I can refer to that would produce something similar to SqlException.Number == SqlExceptionNumberEnum.DeadLockVictim?

It may not be feasible due to the shear volume of potential error messages/numbers but thought it was worth asking. Thanks!

like image 834
James Alexander Avatar asked Jul 01 '09 21:07

James Alexander


1 Answers

Not that I know of. In particular, you can define your own error numbers with sp_addmessage, and the errors change (grow) per SQL-Server version, so it would quickly be a problem if (for example) you were using .NET 2.0 with SQL Server 2008, as your numbers would exist.

like image 166
Marc Gravell Avatar answered Sep 19 '22 13:09

Marc Gravell