×
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

Using .NET Core, Tuple Deconstruction, and NPoco For Performant SQL Access

sql
Regardless of your opinion on Object Relational Mappers (ORM), I think they a...
Read now

Querying Json Recursively in Azure SQL Database

development
Dealing with JSON data in SQL Database introduces several challenges. This p...
Read now

Does A Property Exist On My C# Object

development
We are in the middle of writing a template engine to define dynamic forms. Th...
Read now

Install Hugo (Extended) Latest With Shell Script For macOS

development
We are living on the bleeding edge that is Hugo’s release cycle. To keep our ...
Read now

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!