SqlException Class (System.Data.SqlClient)

Examples The following example generates a SqlException and then displays the exception. public static void ShowSqlException(string connectionString) { string queryString = "EXECUTE NonExistantStoredProcedure"; StringBuilder errorMessages = new StringBuilder(); using (SqlConnection connection = new SqlConnection(connectionString)) { SqlCommand command = new SqlCommand(queryString, connection); try

[Itisango]

The SqlConnection remains open when the severity level is 19 or less. When the severity level is 20 or greater, the server ordinarily closes the SqlConnection. See Database Engine Events and Errors. The SqlException class maps to SQL Server severity.

[JunichiIto]

SqlException発生時にNumberに応じて処理を切り分けるサンプルコード。(デッドロック発生や制約違反等の切り分け)