Class : 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. |
||
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 |