Edit

SqlConnection.FireInfoMessageEventOnUserErrors Property

  • Reference

Definition

Namespace:
System.Data.SqlClient
Assembly:
System.Data.SqlClient.dll
Assembly:
System.Data.dll
Package:
System.Data.SqlClient v4.8.6

Gets or sets the FireInfoMessageEventOnUserErrors property.

public:
 property bool FireInfoMessageEventOnUserErrors { bool get(); void set(bool value); };
public bool FireInfoMessageEventOnUserErrors { get; set; }
member this.FireInfoMessageEventOnUserErrors : bool with get, set
Public Property FireInfoMessageEventOnUserErrors As Boolean

Property Value

Boolean

true if the FireInfoMessageEventOnUserErrors property has been set; otherwise false.

Remarks

When you set FireInfoMessageEventOnUserErrors to true, errors that were previously treated as exceptions are now handled as InfoMessage events. All events fire immediately and are handled by the event handler. If is FireInfoMessageEventOnUserErrors is set to false, then InfoMessage events are handled at the end of the procedure.

Note

An error with a severity level of 17 or above that causes the server to stop processing the command needs to be handled as an exception. In this case, an exception is thrown regardless of how the error is handled in the InfoMessage event.

For more information on working with events, see Connection Events. For more information on errors generated by the SQL Server engine, see Database Engine Errors.

Applies to

See also