ServerConnection Class

Creates a ServerConnection object taking in the token. The extra boolean is used to overload this constructor as another constructor with string is present.

Constructs a new ServerConnection object

Constructs a new ServerConnection object

Constructs a new ServerConnection object from the given SqlConnection

Constructs a new ServerConnection object from the given SqlConnection

Infinite wait

The application intent of the connection Valid values are ReadWrite and ReadOnly

The name of the application. 'SQL Management' if no application name has been provided. Exceptions: ConnectionCannotBeChangedException InvalidPropertyValueException

The authentication type of the connection

Defines the batch separator used by the ExecuteNonQuery methods. Default is "GO". The batch separator is case-insensitive.

Gets or sets a value indicating whether ServerConnection instances should cache query results

If set to true, the connection will be made with the credentials of the specified user. This will assume impersonation, however the LoginSecure flags and Login and Password fields will not be affected. ConnectionCannotBeChangedException

Specifies the NT user that is used when creating an impersonated connection. Exceptions: ConnectionCannotBeChangedException InvalidPropertyValueException PropertyNotSetException

Specifies password of the NT user that is used when creating an impersonated connection. Exceptions: ConnectionCannotBeChangedException InvalidPropertyValueException PropertyNotSetException

Connection protocol.

The property will return either the user specified connection string or it will return the computed connection string based on object settings. If explicitly set, All properties in the ServerConnection object will be populated to reflect the passed in connection string. Exceptions: ConnectionCannotBeChangedException InvalidPropertyValueException

The length of time (in seconds) to wait for a connection to the server before terminating the attempt and throwing an exception. Default is 30 seconds (same as Shiloh). Exceptions: ConnectionCannotBeChangedException InvalidPropertyValueException

Returns the current database context.

The edition of the Database Engine

Returns the database engine type of SQL Server. Exceptions: ConnectionFailureException

TBD

whether "encrypt=true" is specified in the connection string

Returns an enum that specified the fixed server role the login is member of.

The host platform of the server (Linux/Windows/etc)

Returns true if the object has been connected with the server at least once. If true, property changes are not allowed any more and ConnectionCannotBeChangedException will be thrown when a property has been changed.

Returns true if the database engine authenticates using contained authentication. Exceptions: ConnectionFailureException

Indicates that the connection has been forcefully disconnected

Returns true if the SqlConnection object is connected with the server. This can only return true for non pooled connections as pooled connections are always closed directly after an operation.

LockTimeout is the Lock timeout in seconds. Default -1 is for indefinite. InvalidPropertyValueException is thrown for all other negative numbers. Positive LockTimeout will be multiplied by 1000 and then used for "SET LOCK_TIMEOUT" setting.

The SQL Server Login name that is used to connect to the server. Exceptions: ConnectionCannotBeChangedException InvalidPropertyValueException PropertyNotSetException

If set to true, Windows integrate security is used and Login and Password are ignored. If not set, Sql Server Authentication is used. Exceptions: ConnectionCannotBeChangedException

The maximum number of connections allowed in the pool. Exceptions: ConnectionCannotBeChangedException InvalidPropertyValueException

The minimum number of connections maintained in the pool. Exceptions: ConnectionCannotBeChangedException InvalidPropertyValueException

Enable MARS from the connection. Default is false.

Identifies the client network protocol that is used to connect to SQL Server. If you do not specify a network and you use a local server, shared memory is used. If you do not specify a network and you use a remote server, the one of the configured client protocols is used. Exceptions: ConnectionCannotBeChangedException InvalidPropertyValueException

By default, all connections to SQL Server are taken from an ADO.NET connection pool.If set to true, this allows users to create a non-pooled connection (will not be reused when closed). Exceptions: ConnectionCannotBeChangedException

Size in bytes of the network packets used to communicate with an instance of SQL Server. Default is 8192. Exceptions: ConnectionCannotBeChangedException InvalidPropertyValueException

Gets or sets a value indicating the QueryParameterizationMode QueryParameterizationMode all ServerConnection instances use

The password that is used with Login to connect to the server. Exceptions: ConnectionCannotBeChangedException InvalidPropertyValueException PropertyNotSetException

When a connection is returned to the pool, its creation time is compared with the current time, and the connection is destroyed if that time span (in seconds) exceeds the value specified by connection lifetime. Exceptions: ConnectionCannotBeChangedException InvalidPropertyValueException

The ProcessID property returns the SQL Server process identifier for the connection used by the ServerConnection object.

Gets the ProductVersion server property of this connection

Tells us whether ConnectionString needs to be reset in SqlConnectionObject property of ConnectionManager or not.

The property will return a SecureString version of either the user specified connection string or it will return the computed connection string based on object settings. If explicitly set, All properties in the ServerConnection object will be populated to reflect the passed in connection string. Exceptions: ConnectionCannotBeChangedException

The password that is used with Login to connect to the server. Exceptions: ConnectionCannotBeChangedException InvalidPropertyValueException PropertyNotSetException

The name of the SQL Server the object will connect to. If not set, the local server is implied. Exceptions: ConnectionCannotBeChangedException InvalidPropertyValueException

Returns the major version number of SQL Server. I.e. 8 for SQL Server 2000. Exceptions: ConnectionFailureException

Returns a reference to the SqlConnection object used by the ConnectionContext object. This should always return the valid sqlConnection object with the latest valid ConnectionString set. Exceptions: PropertyNotAvailableException

Determines if SQL statements are captured or sent to the server.

This is the number of seconds that a statement is attempted to be sent to the server before it fails. Default is 600 seconds (same as Shiloh). Exceptions: InvalidPropertyValueException

Provides the transaction depth as counted by the object model. This doesn't include any transactions that may have been started on the server, or by issuing BEGIN TRAN with the ExecuteNonQuery method.

The TrueLogin property returns the login record name used by the current connection.

The TrueName property returns the result set of the Microsoft® SQL Server global function @@INSTANCENAME.

Indicate whether the client trusts the server certificate

Gets or sets the DeferredUseMode UseMode all ServerConnection instances use

The UserProfile property returns a high-level role description for the Microsoft SQL Server login used by the current connection.

The name of the workstation connecting to SQL Server. Exceptions: ConnectionCannotBeChangedException InvalidPropertyValueException

Starts a new transaction. If CaptureMode is true, the transaction statement will be added to the capture buffer.It is possible to nest transactions. It is the user's responsibility to commit or rollback every opened transaction. It is not guaranteed that all T-SQL emitted by the object model, can be encapsulated by a transaction. Furthermore, the state of the objects that have been changed will not reflect the actual database state until a transaction has been committed or after a transaction has been rolled backed. It is the responsibility of the user to refresh affected objects. Use with care.

Check if we are connecting to a supported server version. block off <= 7.0 in ServerConnection.

Commits a transaction. If CaptureMode is true, the transaction command will be added to the capture buffer. Exceptions: NotInTransactionException

Creates the actual connection to SQL Server. Ignored if already connected. It is optional to call this method, as the connection will be opened when required. Exceptions: ConnectionFailureException

This function performs a deep copy

Closes the connection with SQL Server. Ignored if already disconnected. Exceptions: ConnectionFailureException

Executes a T-SQL statement. The command termininator ('GO') is recognized by ExecuteNonQuery. Batches will be sent and executed individually. The statement is recorded and not executed if CaptureMode has been set to true. An int value is returned that contain the numbers of rows affected. If multiple batches are executed, the total numbers of affected rows of all batches is returned. The Connect() method will be called if the connection with the server is not open. Exceptions: ConnectionFailureException ExecutionFailureExeception

Executes a T-SQL statement. The command termininator ('GO') is recognized by ExecuteNonQuery. Batches will be sent and executed individually. The statement is recorded and not executed if CaptureMode has been set to true. An int value is returned that contain the numbers of rows affected. If multiple batches are executed, the total numbers of affected rows of all batches is returned. The Connect() method will be called if the connection with the server is not open. Exceptions: ConnectionFailureException ExecutionFailureExeception

Executes the T-SQL statements in the StringCollection. The command termininator ('GO') is recognized by ExecuteNonQuery. Batches separated with the GO statement will be sent and executed individually. The statement is recorded and not executed if CaptureMode has been set to true. An array of int values is returned that contain the numbers of rows affected for each statement in the StringCollection. If multiple batches are executed, the total numbers of affected rows of all batches is returned. The Connect() method will be called if the connection with the server is not open. Exceptions: ConnectionFailureException ExecutionFailureExeception

Executes the T-SQL statements in the StringCollection. The command termininator ('GO') is recognized by ExecuteNonQuery. Batches separated with the GO statement will be sent and executed individually. The statement is recorded and not executed if CaptureMode has been set to true. An array of int values is returned that contain the numbers of rows affected for each statement in the StringCollection. If multiple batches are executed, the total numbers of affected rows of all batches is returned. The Connect() method will be called if the connection with the server is not open. Exceptions: ConnectionFailureException ExecutionFailureExeception

Executes T-SQL statements. A SqlDataReader object is returned that can be used to read the stream of rows that are returned by SQL Server. A SqlCommand object is also returned that can be used to cancel the data reader pipe if an abort of a long-running query is needed. it doesn't automatically disconnect Exceptions: ConnectionFailureException ExecutionFailureExeception

Executes T-SQL statements. A SqlDataReader object is returned that can be used to read the stream of rows that are returned by SQL Server. A SqlCommand object is also returned that can be used to cancel the data reader pipe if an abort of a long-running query is needed. it doesn't automatically disconnect Exceptions: ConnectionFailureException ExecutionFailureExeception

Executes T-SQL statements. A SqlDataReader object is returned that can be used to read the stream of rows that are returned by SQL Server. The Connect() method will be called if the connection with the server is not open. it doesn't automatically disconnect Exceptions: ConnectionFailureException ExecutionFailureExeception

Executes a T-SQL statement. An objects is returned that contains the first column of the first row of the result set. The Connect() method will be called if the connection with the server is not open. Exceptions: ConnectionFailureException ExecutionFailureExeception

Executes the T-SQL statements in the StringCollection. An array of objects are returned that each contain the first column of the first row of the result set of each executed statement. The Connect() method will be called if the connection with the server is not open. Exceptions: ConnectionFailureException ExecutionFailureExeception

Executes T-SQL using the appropriate methods depending on the action information passed as the parameter.

Executes the T-SQL statements in sqlCommand. A DataSet is returned that contains the results. The Connect() method will be called if the connection with the server is not open. Exceptions: ConnectionFailureException ExecutionFailureExeception

Executes the T-SQL statements in sqlCommand. A DataSet is returned that contains the results. The Connect() method will be called if the connection with the server is not open. Exceptions: ConnectionFailureException ExecutionFailureExeception

Executes the T-SQL statements in the StringCollection. An array of DataSets are returned that contain the results for each statement in the StringCollection. The Connect() method will be called if the connection with the server is not open. Exceptions: ConnectionFailureException ExecutionFailureExeception

Enforces a disconnect and ensures that connection cannot be re-opened again

Returns a connection that has the specified database name in the connection string

Returns a connection that has the specified database name in the connection string

Tests if login is member of any of the specified server roles.

Translate a query with embedded literals to a normalized form (all literals replaced by a standard token)

Overload for the above function -- see it for details

Aborts a transaction (all changes made will not be saved to the database). If CaptureMode is true, the transaction command will be added to the capture buffer. Exceptions: NotInTransactionException

Occurs when SQL Server returns a warning or informational message. Uses SqlClient.SqlInfoMessageEventHandler.

Called when the server needs to connect to remote servers and the login fails

Occurs when SQL Server returns a warning or informational message. Uses SqlClient.SqlInfoMessageEventHandler.

Occurs when the state of the connection changes. Uses System.Data.StateChangeEventHandler.