EF.DB.DBX

DBExpress-based database access layer.

TEFDBDBXInfo class

Retrieves metadata from a database through DBX. Should support all databases supported by DBX, depending on the driver used.

constructor Create(const AConnection: TSQLConnection);

Creates the info object bound to the given DBX connection.

property Connection: TSQLConnection read FConnection write FConnection;

The DBX connection used to retrieve database metadata.

TEFSQLConnection class

TSQLConnection descendant used internally by the DBX adapter.

TEFDBDBXConnection class

DBExpress implementation of TEFDBConnection. Supports the databases reachable through the configured DBX driver.

procedure AfterConstruction;

Creates the internal TSQLConnection and connection string.

destructor Destroy;

Closes and destroys the internal TSQLConnection.

function IsOpen: Boolean;

DBX implementation of TEFDBConnection.IsOpen.

function ExecuteImmediate(const AStatement: string): Integer;

DBX implementation of TEFDBConnection.ExecuteImmediate.

procedure InternalStartTransaction;

DBX implementation of TEFDBConnection.InternalStartTransaction.

procedure InternalCommitTransaction;

DBX implementation of TEFDBConnection.InternalCommitTransaction.

procedure InternalRollbackTransaction;

DBX implementation of TEFDBConnection.InternalRollbackTransaction.

function IsInTransaction: Boolean;

DBX implementation of TEFDBConnection.IsInTransaction.

function GetLastAutoincValue(const ATableName: string = ''): Int64;

Auto-inc fields are not supported in dbExpress; always returns 0.

function FetchSequenceGeneratorValue(const ASequenceName: string): Int64;

Fetches the next value of a sequence generator (Oracle and IB/Fb only).

function CreateDBCommand: TEFDBCommand;

DBX implementation of TEFDBConnection.CreateDBCommand.

function CreateDBQuery: TEFDBQuery;

DBX implementation of TEFDBConnection.CreateDBQuery.

function GetConnection: TObject;

Returns the underlying TSQLConnection instance.

TEFSQLQuery class

Customized TSQLQuery used inside TEFDBXCommand and TEFDBDBXQuery.

function ExecSQL(ExecDirect: Boolean = False): Integer;

Patches unknown parameter types before delegating to the inherited ExecSQL, to avoid the DBX "No value for parameter X" error.

TEFDBDBXCommand class

DBExpress implementation of TEFDBCommand (statements returning no result set), backed by an internal TEFSQLQuery.

procedure AfterConstruction;

Creates the internal TEFSQLQuery.

destructor Destroy;

Destroys the internal TEFSQLQuery.

function Execute: Integer;

DBX implementation of TEFDBCommand.Execute; returns the number of affected rows.

TEFDBDBXQuery class

DBExpress implementation of TEFDBQuery (statements returning a result set), backed by an internal TEFSQLQuery.

procedure AfterConstruction;

Creates the internal TEFSQLQuery.

destructor Destroy;

Destroys the internal TEFSQLQuery.

function Execute: Integer;

Execute and Open are synonims in this class. Execute always returns 0.

procedure Open;

DBX implementation of TEFDBQuery.Open; opens the underlying dataset.

procedure Close;

DBX implementation of TEFDBQuery.Close; closes the underlying dataset.

function IsOpen: Boolean;

DBX implementation of TEFDBQuery.IsOpen.

TEFDBDBXConnectionConfig class

DBExpress connection parameters. YAML path: DatabaseRouter/DatabaseName/Connection

TEFDBDBXAdapter class

Database adapter that creates DBExpress connections. Registered with the adapter registry under the ClassId 'DBX'.