Best practices for catching exceptions from SQL in C#

Question

What are some good ways to catch business logic exceptions or return values from SQL in C#? For instance, upon creating a new user, if the user already exists, the system and the user must be notified. I have used the raise_error() method with a particular state int value, I have used a stored procedure returning int values, and I have also selected a msg column with a particular structure. Are there any best practices for this?

Steven A. Lowe · Accepted Answer · 2008-10-08 04:17:24Z

1

i always do two things:

use raiseerror, which manifests on the code side as an exception, and
return an error code

this lets me catch errors both in C# code and also when one stored procedure calls another

[sql server now supports a try-catch block, but i haven't used it yet]

answered Oct 8, 2008 at 4:17

Steven A. Lowe

61.5k19 gold badges136 silver badges206 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Best practices for catching exceptions from SQL in C#

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related