SqlException constraint violation

Question

I'm working on an asp.net app. Is there a way, when catching a SqlException, to know which constraint was violated?

Answer 1

SqlException has a collection of SqlError objects: Errors. The SqlError have properties for error Number and you can compare this with the known constraint violation error numbers (eg. 2627).

While is true that SqlException itself exposes a Number property, it is not accurate if multiple errors happen in a single batch and hence is better to inspect the Errors collection.