FireInfoMessageEventOnUserErrors Property

SqlConnection.FireInfoMessageEventOnUserErrors Property

 

Gets or sets the FireInfoMessageEventOnUserErrors property.

Namespace:   System.Data.SqlClient
Assembly:  System.Data (in System.Data.dll)

public bool FireInfoMessageEventOnUserErrors { get; set; }

Property Value

Type: System.Boolean

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

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.

System_CAPS_noteNote

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 SQL Server Books Online.

Universal Windows Platform
Available since 10
.NET Framework
Available since 2.0
Return to top
Show:
© 2016 Microsoft