I'm going to update a couple of older projects that are still using
REALSQLDatabase with using
Quite some functions are currently setting
REALSQLDatabase(DB).AutoCommit = False. And the generated SQL Statements of course require that (e.g. add an explicit
COMMIT after an Update-Statement that is outside of a Transaction).
So: How am I going to deal with that?
It seems there is no
SQLiteDatabase.AutoCommit any longer… Is there some other way to get the "old" behavior? Or do I need to dig through all of the code to respect that (by removing the Commit's for Updates outside of Transactions - such as it would not be neccessary if AutoCommit is ON)?
I'd prefer to have AutoCommit explicitly disabled... and not having to use
SQLiteDatabase in AutoCommit mode.