CODEWITHSUNDEEP
c#sql-serverexception
Mac
Mac

Reputation: 7533

Common exceptions while executing sql queries

I have read that catching the particular exception separately enhanced the performance so I just wanted to know what are the most common exception that might generate while executing any sql query

Upvotes: 1

Views: 474

Answers (1)

gbn
gbn

Reputation: 432331

It won't enhance performance, but exception handling provides a good way to control code flow.

The best article (the subject is too long for an SO answer) is "Error Handling in SQL 2005 and Later" by Erland Sommarskog. And shameless plug of my question here

However, if you mean in c# then there is really only SQLException.

As to what causes them, the main ones may be

  • constraint violation (fails CHECK, duplicate/UNIQUE, no parent/FK etc)
  • overflow and conversions (eg -1 to tinyint)

Upvotes: 2

Related Questions