Raise exception in stored procedure

[Oleg Ogurok]

Hi all,

Could someone please point me to any docs explaining how to raise exceptions
in stored procedures and catch them in C# ?
Thanks,

Oleg.

 

[Scott Allen]

Assuming you are using SQL Server, you can use RAISERROR in a stored
procedure to produce a SqlException in your C# code.

The section entitled "Generating Errors from Stored Procedures" in the
".NET Data Access Architecture Guide" explains this method in more
detail:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnbda/html/daag.asp

 

[Mary Chipman]

You can raise an exception in a stored procedure with RAISERROR and
supplying a severity level -- this is all documented in SQL Books
Online. You can catch any SqlError in your try/catch block that has a
severity level of between 11 and 16 by looping through
SqlException.Errors.

-- Mary
MCW Technologies
http://www.mcwtech.com