|
Close |
|
|
CreateCommand |
|
|
CreateDataAdapter |
|
|
CreateDeleteQueryBuilder |
|
|
CreateSelectQueryBuilder |
Create a Select Query Builder. |
|
CreateSelectQueryBuilderFast |
Create and initialise a Select Query Builder. |
|
CreateSqlWhereBuilder |
|
|
CreateUnionSelectQuery |
Create a Union Select Query. |
|
CreateUpdateQueryBuilder |
|
|
CurrentProviderBuilderUtilities |
|
|
CurrentProviderUtilities |
|
|
DataReaderClose |
Close and dispose of a DataReader. |
|
DataReaderOpen |
Open a DataReader. Only a single connected DataReader can be open at any one time on most databases hence the option to use a disconnected reader based upon a DataTable. |
|
DataSetOpen |
|
|
DataTableClose |
Close and dispose of a DataTable. |
|
DataTableOpen |
|
|
Escape |
Escape (if necessary) a field or table name. |
|
EscapeList |
Escapes (if necessary) a comma separated list. |
|
Execute |
|
|
FormatSqlBoolean |
|
|
FormatSqlDate |
|
|
FormatSqlDecimal |
|
|
FormatSqlDouble |
|
|
FormatSqlInteger |
|
|
FormatSqlIntegerBoolean |
|
|
FormatSqlLong |
|
|
FormatSqlShort |
|
|
FormatSqlString |
|
|
GetFieldBinary |
|
|
GetFieldBoolean |
|
|
GetFieldDate |
Returns the field as a Date/Time. The DateTimeKind will be set as 'Unspecified'. |
|
GetFieldDateNullable |
|
|
GetFieldDecimal |
|
|
GetFieldDouble |
|
|
GetFieldEnum |
|
|
GetFieldInteger |
|
|
GetFieldIntegerBoolean |
|
|
GetFieldIntegerTimeZoneId |
|
|
GetFieldLong |
|
|
GetFieldString |
Returns a String value for a Record's Column. A DBNull value is treated as a blank string. |
|
GetFieldULong |
|
|
GetFieldUtcDate |
Returns the field as a UTC Date/Time, i.e. the DateTimeKind is 'Utc'. |
|
GetRecordCount |
Get a Record Count. |
|
GetScalarBinary |
Retrieve a Binary value from the Database. |
|
GetScalarBoolean |
Retrieve a single Boolean value from the Database. |
|
GetScalarDate |
Retrieve a single Date value from the Database. |
|
GetScalarDecimal |
Retrieve a single Decimal value from the Database. |
|
GetScalarDouble |
Retrieve a single Double value from the Database. |
|
GetScalarEnum |
Retrieve a single Enum value from the Database. |
|
GetScalarInteger |
Retrieve a single Integer value from the Database. |
|
GetScalarIntegerBoolean |
Retrieve a single Boolean value from the Database where the Boolean value is represented by an Integer on the Database. |
|
GetScalarLong |
Retrieve a single Long value from the Database. |
|
GetScalarString |
Retrieve a single String value from the Database. |
|
GetSqlWhereFromRange |
|
|
IsConnectionAlive |
Returns True if the Database Connection is alive. |
|
Open |
|
|
OpenDirect |
Open Directly using a Connection String. |
|
ProviderBuilderUtilities |
|
|
ProviderUtilities |
|
|
SqlCase |
Creates an SQL string containing this provider's equivalent of an CASE function. |
|
SqlChoose |
Creates an SQL string containing this provider's equivalent of an CHOOSE function. |
|
SqlIif |
Generate an IIF (or equivalent) SQL block. |
|
SqlLength |
Generate a LEN (or LENGTH) SQL expression. |
|
TransactionBegin |
Begins a Database Transaction. |
|
TransactionBegin2 |
Begins a Database Transaction. |
|
TransactionCommit |
|
|
TransactionRollback |
|