SqlExecutionException Class

Definition

Namespace:

System.Web.Management

Assembly:

System.Web.dll

Defines a class for SQL execution exceptions in the System.Web.Management namespace.

public ref class SqlExecutionException sealed : SystemException

[System.Serializable]
public sealed class SqlExecutionException : SystemException

[<System.Serializable>]
type SqlExecutionException = class
    inherit SystemException

Public NotInheritable Class SqlExecutionException
Inherits SystemException

Inheritance

Object

Exception

SystemException

SqlExecutionException

Attributes

SerializableAttribute

Examples

The following code example shows how to use the SqlExecutionException exception type. This code example is part of a larger example provided for the SqlServices class.

Console.WriteLine(
    "An SQL execution exception occurred.");
Console.WriteLine();
Console.WriteLine("  Message: {0}",
    sqlExecutionException.Message);
Console.WriteLine("  Server: {0}",
    sqlExecutionException.Server);
Console.WriteLine("  Database: {0}",
    sqlExecutionException.Database);
Console.WriteLine("  Commands: {0}",
    sqlExecutionException.Commands);
Console.WriteLine("  SqlFile: {0}",
    sqlExecutionException.SqlFile);
Console.WriteLine("  Inner Exception: {0}",
    sqlExecutionException.Exception);

Console.WriteLine( _
    "An SQL execution exception occurred.")
Console.WriteLine()
Console.WriteLine("  Message: {0}", _
    sqlExecutionException.Message)
Console.WriteLine("  Server: {0}", _
    sqlExecutionException.Server)
Console.WriteLine("  Database: {0}", _
    sqlExecutionException.Database)
Console.WriteLine("  Commands: {0}", _
    sqlExecutionException.Commands)
Console.WriteLine("  SqlFile: {0}", _
    sqlExecutionException.SqlFile)
Console.WriteLine("  Inner Exception: {0}", _
    sqlExecutionException.Exception)

Remarks

This class is provided as a means to differentiate SQL execution exceptions from other application exceptions.

Constructors

SqlExecutionException()	Initializes a new instance of the SqlExecutionException class using default values.
SqlExecutionException(String, Exception)	Initializes a new instance of the SqlExecutionException class using the passed message and exception.
SqlExecutionException(String, String, String, String, String, SqlException)	Initializes a new instance of the SqlExecutionException class.
SqlExecutionException(String)	Initializes a new instance of the SqlExecutionException class using the passed message.

Properties

Commands	Gets the SQL commands being run when the exception occurred.
Data	Gets a collection of key/value pairs that provide additional user-defined information about the exception. (Inherited from Exception)
Database	Gets the name of the database being accessed when the exception occurred.
Exception	Gets the exception encountered when processing the SQL commands.
HelpLink	Gets or sets a link to the help file associated with this exception. (Inherited from Exception)
HResult	Gets or sets HRESULT, a coded numerical value that is assigned to a specific exception. (Inherited from Exception)
InnerException	Gets the Exception instance that caused the current exception. (Inherited from Exception)
Message	Gets a message that describes the current exception. (Inherited from Exception)
Server	Gets the SQL Server instance being accessed when the exception occurred.
Source	Gets or sets the name of the application or the object that causes the error. (Inherited from Exception)
SqlFile	Gets the path and name of the file containing the SQL commands being run when the exception occurred.
StackTrace	Gets a string representation of the immediate frames on the call stack. (Inherited from Exception)
TargetSite	Gets the method that throws the current exception. (Inherited from Exception)

Methods

Equals(Object)	Determines whether the specified object is equal to the current object. (Inherited from Object)
GetBaseException()	When overridden in a derived class, returns the Exception that is the root cause of one or more subsequent exceptions. (Inherited from Exception)
GetHashCode()	Serves as the default hash function. (Inherited from Object)
GetObjectData(SerializationInfo, StreamingContext)	Allows the exception to be serialized.
GetType()	Gets the runtime type of the current instance. (Inherited from Exception)
MemberwiseClone()	Creates a shallow copy of the current Object. (Inherited from Object)
ToString()	Creates and returns a string representation of the current exception. (Inherited from Exception)

Events

SerializeObjectState

Occurs when an exception is serialized to create an exception state object that contains serialized data about the exception. (Inherited from Exception)

See also

• SqlServices
• SystemException
• SqlException