due to my requirements my application should be able to access a SQLite DB in read-only mode through Telerik Data Access while the source application may still be writing to it (via native SQLite C++ API). It is sufficient if only those changes are visible to the application which were already commited at the time the DB connection was opened through the OpenAccessContext.
I was assuming this could be done by setting the IsolationLevel to Snapshot. But it seems I'm missing something here. My attempt was to setup the writing code with standard auto-commit behaviour on each insert/update and set the OpenAccessContext to
ContextOptions.IsolationLevel = System.Data.IsolationLevel.Snapshot
However, this results in an exception, even when the database is not open anymore by the producer application:
Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriverException: Unsupported isolation level Snapshot
Does my concept have any general flaw, is this simply nto supported by SQLite (I don't think so) or do I have toconfigure this differently for SQLite?