nce.adoole.Connection

This class is an implementation of ADODB.Connection object in .NET, and it is based on System.OleDB namespace.

nce.adosql.Connection

This class is an implementation of ADODB.Connection object in .NET, and it is based on System.SqlDb namespace.

nce.adoora.Connection

This class is an implementation of ADODB.Connection object in .NET, and it is based on System.Data.OracleClient namespace.


Supported list

Following table is the supported list of Connection object for .NET:

Property Supported
Attributes Yes
CommandTimeout Yes
ConnectionString Yes
ConnectionTimeout Yes
CursorLocation Yes
DefaultDatabase Yes (nce.adoora is not supported DefaultDatabase.)
IsolationLevel Yes
Mode Yes
Provider Yes
State Yes
Version Yes
Method Supported
BeginTrans Yes
CommitTrans Yes
RollbackTrans Yes
Execute Yes
(Unsupported adExecuteAsync, adFetchAsync)
Open Yes
OpenSchema Yes

For nce.adoora namespace, it does not support OpenSchema.
For nce.adosql namespace, only supports following schema:
  • adSchemaAsserts
  • adSchemaCatalogs
  • adSchemaColumns
  • adSchemaCheckConstraints
  • adSchemaConstraintColumnUsage
  • adSchemaConstraintTableUsage
  • adSchemaKeyColumnUsage
  • adSchemaReferentialConstraints
  • adSchemaTableConstraints
  • adSchemaColumnsDomainUsage
  • adSchemaColumnPrivileges
  • adSchemaTablePrivileges
  • adSchemaProcedures
  • adSchemaSchemata
  • adSchemaTables
  • adSchemaViews
  • adSchemaViewColumnUsage
  • adSchemaViewTableUsage
  • adSchemaProcedureParameters
  • adSchemaProcedureColumns