.NET SqlClient Error Number Enum Type
ado.net, sql-server
Solution
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.
Problem
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!