CNXConnection

Namespace: | System.Data.CONNX
Description: | The CNXConnection object is used to handle the physical connection to the database. Connection Pooling is available to conserve server resources, while still providing exceptional performance. The CNXConnection object also contains details about the data source that it is connected to.
Constructors: | CNXConnection
Description: | This constructor creates a new CNXConnection object. The ConnectionState property is closed, and the ConnectionString property is blank.
Parameters: | None
CNXConnection
Description: | This constructor accepts a String value assigned to the ConnectionString property.
Parameters: | sConnString
Type: | String
Description: | Yes
Properties: | ConnectionString
Type: | String
Description: | The ConnectionString property gets/sets the connection String for the current database connection.
ConnectionPoolTimeout
Type: | Int
Description: | The ConnectionPoolTimeout specifies how many seconds the connection remains in the pool before it is closed.
ConnectionTimeout
Type: | N/A
Description: | N/A
Database
Type: | String
Description: | The Database property is not implemented at this time.
PoolConnection
Type: | Boolean
Description: | Determines whether a connection will be added to the connection pool.
State
Type: | ConnectionState
Description: | The State property returns the ConnectState object that has the current state of the connection.
TransactionCapabilities
Type: | IDbTransaction
Description: | The TransactionCapabilities property gets the CNXTransactionCapabilities object that contains the transaction capabilities for the current database connection.
Methods: | BeginTransaction
Return Type: | IDbTransaction
Description: | The BeginTransaction method attempts to start a transaction on the current connection.
Parameters: | None
BeginTransaction
Return Type: | IDbTransaction
Description: | The BeginTransaction method attempts to start a transaction on the current connection. The IsolationLevel object is not used at this time.
Parameters: | dbName
Type: | IsolationLevel
Description: | Transaction isolation level
ChangeDatabase
Return Type: | Void
Description: | The ChangeDatabase method is not implemented at this time. String value consisting of database name to which you may want to change.
Parameters: | dbName
Type: | string
Description: | New database name
Close
Return Type: | Void
Description: | The Close method either closes or releases the current connection to the connection pool, depending on the ConnectionPooling property.
Parameters: | None
CreateCommand
Return Type: | IDbCommand
Description: | The CreateCommand method creates a new CNXCommand object with the Connection property set to the current connection. A CNXCommand object with the Connection property set to the current connection.
Parameters: | None
Dispose
Return Type: | void
Description: | The Dispose method releases any resources held by the object.
Parameters: | disposing
Type: | Bool
Description: | Specifies if managed resources should also be disposed (true).
Open
Return Type: | Void
Description: | The Dispose method releases any resources held by the object.
Parameters: | None