The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

  • Twitter Updates

  • My Flickr Stream

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 2,810 other followers

C#/.NET: Assessing the SqlException severity

Posted by jpluimers on 2012/02/22

When handling SqlExceptions in C#, it is wise to assess the Class, as it indicates the severity.

Some classes are user error, others are fatal, etc.

This extension class will help you:

using System;
using System.Data.SqlClient;

namespace bo.MsSql
    /// <summary>
    /// see
    /// </summary>
    public static class SqlExceptionSeverety
        public static bool IsInformational(this SqlException sqlException)
            return sqlException.Class < 10;

        public static bool IsUserCorractable(this SqlException sqlException)
            return (sqlException.Class >= 10) && (sqlException.Class < 17);

        public static bool IsSoftwareError(this SqlException sqlException)
            return (sqlException.Class >= 17) && (sqlException.Class < 20);

        public static bool IsFatalSystemProblem(this SqlException sqlException)
            return sqlException.Class >= 20;


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: