How to check for duplicate key violation?

  • Thread starter Thread starter EC
  • Start date Start date
E

EC

I get an SqlException caused by trying to insert a duplicate key into a
table. The user needs to be informed and asked to supply a new input. I
check the SqlException object and see these two properties:

ex.Number = 2627
ex.Message = "Violation of UNIQUE KEY constraint ..."

So is it safe to check the Number property against 2627 ? If not, what is
the proper way to check this exception?
 
Back
Top