EF.DB.ADO

ADO-based database access layer.

TEFDBADOParams class

Utility class used to adapt ADO's TParameters to the standard TParams.

procedure AssignValuesTo(const ADestination: TParameters);

Sets the Value property of every parameter in ADestination whose name matches the name of a parameter in the current object to that of the current object's parameter.

procedure AssignValuesFrom(const ASource: TParameters);

Retrieve the Value property of every parameter from ASource whose name matches the name of a parameter in the current object to that of the current object's parameter.

TEFDBADOInfo class

Retrieves metadata from a database through ADO. Currently only SQL Server is supported.

constructor Create(const AConnection: TADOConnection);

Creates the info object bound to the given ADO connection.

property Connection: TADOConnection read FConnection write FConnection;

The ADO connection used to retrieve database metadata.

TEFDBADOConnection class

ADO/OLEDB implementation of TEFDBConnection. Currently targets SQL Server.

procedure AfterConstruction;

Creates the internal TADOConnection.

destructor Destroy;

Destroys the internal TADOConnection.

function IsOpen: Boolean;

ADO implementation of TEFDBConnection.IsOpen.

function ExecuteImmediate(const AStatement: string): Integer;

ADO implementation of TEFDBConnection.ExecuteImmediate.

procedure InternalStartTransaction;

ADO implementation of TEFDBConnection.InternalStartTransaction.

procedure InternalCommitTransaction;

ADO implementation of TEFDBConnection.InternalCommitTransaction.

procedure InternalRollbackTransaction;

ADO implementation of TEFDBConnection.InternalRollbackTransaction.

function IsInTransaction: Boolean;

ADO implementation of TEFDBConnection.IsInTransaction.

function FetchSequenceGeneratorValue(const ASequenceName: string): Int64;

Sequence generators are not supported by the ADO adapter; always returns 0.

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

Returns the last generated autoincrement value (SQL Server @@IDENTITY).

function CreateDBCommand: TEFDBCommand;

ADO implementation of TEFDBConnection.CreateDBCommand.

function CreateDBQuery: TEFDBQuery;

ADO implementation of TEFDBConnection.CreateDBQuery.

function GetConnection: TObject;

Returns the underlying TADOConnection instance.

TEFDBADOCommand class

ADO implementation of TEFDBCommand (statements returning no result set), backed by a TADOCommand.

procedure AfterConstruction;

Creates the internal TADOCommand and its parameters.

destructor Destroy;

Destroys the internal TADOCommand and its parameters.

function Execute: Integer;

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

TEFDBADOQuery class

ADO implementation of TEFDBQuery (statements returning a result set), backed by a TADOQuery.

procedure AfterConstruction;

Creates the internal TADOQuery and its parameters.

destructor Destroy;

Destroys the internal TADOQuery and its parameters.

function Execute: Integer;

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

procedure Open;

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

procedure Close;

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

function IsOpen: Boolean;

ADO implementation of TEFDBQuery.IsOpen.

TEFDBADOConnectionConfig class

ADO/OLEDB connection parameters. YAML path: DatabaseRouter/DatabaseName/Connection

TEFDBADOAdapter class

Database adapter that creates ADO/OLEDB connections. Registered with the adapter registry under the ClassId 'ADO'.