Check if database supports transactions using FireDac
How to check if the DBMS supports transactions using FireDac components?
I usually use something like the following code to perform a transaction in my DAO class using dbExpress.
...
connection: TSQLConnection;
dbxTransaction: TDBXTransaction;
...
if (connection.TransactionsSupported) AND ((not connection.InTransaction) OR (connection.MultipleTransactionsSupported)) then
begin
dbxTransaction := connection.BeginTransaction(TDBXIsolations.ReadCommitted);
end;
So what are the properties of correspondents in FireDac that I use in dbExpress: TransactionsSupported
InTransaction
MultipleTransactionsSupported
Thanks in advance.
+3
source to share