×
Tony Moore | Pat Loika

Handling User Defined SQL Exceptions in C# 7

Written by Khalid Abuhakmeh
2
This post is days old.

Let’s say you are developing a new Infinity War SQL stored procedure. Thanos, your boss, has explicity told you to add validation to a stored procedure and warn developers of their impending doom. To halt the execution of the stored procedure, you may decide to THROW an exception like so:

;THROW 50001,'I know what it''s like to lose; to feel so desperately that you''re right, yet fail all the same.',1;

Note that the line of SQL throws a 50001 which denotes the error as being user defined. Now, to deal with those developers.

In C#, we can use pattern matching to catch the SqlException and convert it into a helpful message.

try {
    // Execute SQL Command
} catch (SqlException e) 
  when (e.Number == 50001) {
      return new ThanosQuoteResult(e.Message);
  }

Note that you want to look at the Number property on a SqlException and not the ErrorCode.

Khalid Abuhakmeh
Khalid Abuhakmeh
Director of Software Development
development
c#
sql
Suggested reading

Understanding User Access Within Your Ecosystem

development
Security is an essential part of any application ecosystem, but it can also b...
Read now

Find Numbers In A C# String

development
Data can often be messy and cleaning it up falls on the shoulders of you, the...
Read now

Comments

Stay fresh! The brighter green, the fresher the article!