Name | Description | |
---|---|---|
SqlConnection Constructor | Overloaded. Initializes a new instance of the SqlConnection class. |
The following tables list the members exposed by SqlConnection.
Name | Description | |
---|---|---|
SqlConnection Constructor | Overloaded. Initializes a new instance of the SqlConnection class. |
Name | Description | |
---|---|---|
ColumnEncryptionKeyCacheTtl | ||
ColumnEncryptionQueryMetadataCacheEnabled | ||
ConnectionString | Overridden. Gets or sets the string used to open a SQL Server connection. | |
ConnectionTimeout | Overridden. Gets the time to wait while trying to establish a connection before terminating the attempt and generating an error. | |
Container | Gets the System.ComponentModel.IContainer that contains the System.ComponentModel.Component. (Inherited from System.ComponentModel.Component) | |
Database | Gets or sets the name of the current database or the database to be used once a connection is open. | |
DataSource | Gets or sets the name of the instance of SQL Server to which to connect. | |
FireInfoMessageEventOnUserErrors | Determines whether to handle errors, treated as exceptions, in the InfoMessage event handler. | |
InDistributedTransaction | Indicates whether the connection is enlisted in a distributed transaction. (Inherited from Devart.Common.DbConnectionBase) | |
LocalFailover | Determines whether the ConnectionLost event, which allows implicit reconnecting and reexectuting the corresponding operation, occurs after connection is lost. | |
Name | Gets or sets the name of the component. | |
Owner | Gets or sets a form or other container that the SqlConnection instance belongs to. | |
Password | Gets or sets the user's password to connect. | |
ServerVersion | Overridden. Gets a string containing the version of the instance of SQL Server to which the client is connected. | |
Site | Gets or sets the System.ComponentModel.ISite of the System.ComponentModel.Component. (Inherited from System.ComponentModel.Component) | |
State | Gets the current state of the connection. | |
StatisticsEnabled | Determines whether to enable statistics gathering for the connection. | |
UserId | Gets or sets the name of the user to connect. | |
WorkstationId | Gets a string that identifies the database client. |
Name | Description | |
---|---|---|
BeginOpen | Starts an asynchronous invocation of an Open method. (Inherited from Devart.Common.DbConnectionBase) | |
BeginTransaction | Overloaded. Starts a database transaction. | |
ChangeDatabase | Overridden. Changes the current database. | |
ChangePassword | Changes the password for the user specified in the connection string. | |
ClearAllPools | Clears all pools associated with the connection. | |
ClearPool | Clears the pool matching ConnectionString of provided SqlConnection object. | |
Clone | Creates a new object that is a copy of the current instance. | |
Close | Closes the connection to the database. This is the preferred method of closing any open connection. (Inherited from Devart.Common.DbConnectionBase) | |
CreateCommand | Creates and returns a SqlCommand object associated with the SqlConnection. | |
CreateObjRef | Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object. (Inherited from System.MarshalByRefObject) | |
Dispose | Releases all resources used by the System.ComponentModel.Component. (Inherited from System.ComponentModel.Component) | |
EndOpen | Ends an asynchronous invocation of the Open method. (Inherited from Devart.Common.DbConnectionBase) | |
EnlistDistributedTransaction | Enlists in the specified transaction as a distributed transaction. | |
EnlistTransaction | Overridden. Enlists in the specified transaction. | |
GetLifetimeService | Retrieves the current lifetime service object that controls the lifetime policy for this instance. (Inherited from System.MarshalByRefObject) | |
GetSchema | Overloaded. Returns list of metadata collections and number of restrictions for a collection. (Inherited from Devart.Common.DbConnectionBase) | |
InitializeLifetimeService | Obtains a lifetime service object to control the lifetime policy for this instance. (Inherited from System.MarshalByRefObject) | |
Open | Overridden. Opens a SQL Server connection with the property settings specified by the ConnectionString. | |
ResetStatistics | Resets all values to 0 if statistics gathering is enabled. | |
RetrieveStatistics | Returns a collection of statistics at the moment the method is called. | |
ToString | Returns a System.String containing the name of the System.ComponentModel.Component, if any. This method should not be overridden. (Inherited from System.ComponentModel.Component) |
Name | Description | |
---|---|---|
ConnectionLost | Occurs when connection to the data source is lost in case LocalFailover is set to true. You may use this event to implicitly reconnect and reexecute the current operation. | |
Disposed | Occurs when the component is disposed by a call to the System.ComponentModel.Component.Dispose method. (Inherited from System.ComponentModel.Component) | |
Error | Occurs when SQL Server returns an error. | |
InfoMessage | Occurs when SQL Server returns a warning or informational message. | |
StateChange | Occurs when the state of the connection changes. (Inherited from Devart.Common.DbConnectionBase) | |
TransactionStateChanged | Occurs when the state of the transaction is changed. (Inherited from Devart.Common.DbConnectionBase) | |
TransactionStateChanging | Occurs when the state of the transaction is changing. (Inherited from Devart.Common.DbConnectionBase) |