Class : CNXConnection

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.

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