Search code examples
sql-serverado.net

Is there a ENUM that I can use for `SqlException.Number` exceptions?

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 curious, 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!

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.