×
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 (Former)
development
c#
sql
Suggested reading

Vue 3 is official

development
Get ready to celebrate because, as of Friday, September 18, 2020, Evan You, c...
Read now

Vue 3 Composition API

development
Have you found yourself getting lost in large Vue components that have multip...
Read now

Artifact Conference 2019

development
How are we building our websites? Are they truly for everyone or if we ask ou...
Read now

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

Comments

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