|Title:||Multi thread access for encrypted database error!|
|Last Modified:||2016-02-15 19:29:13|
|Version Found In:||184.108.40.206|
anonymous added on 2013-10-30 06:09:52:
Issue is happening when encrypted database opened by two or more program. (Databases without encryption are working good.) Data modification of the first program is shown by the second one only if it is the first, third, 5th, 7th, etc. (odd) modification sequentially. After modifying two, four, six, etc. (even) data sequentially the result is not available in second program. The select command by the second program will get a previous state of database. I hope it was understandable :) It would be important for me. regards, Akos
mistachkin added on 2013-10-30 07:41:22:
The CryptoAPI-based encryption included with System.Data.SQLite is a legacy feature, has known issues, and is officially unsupported. It is being retained only for the purpose of backward compatibility with legacy applications that make use of it. Alternatively, you might want to look into the commercial SEE extension, which does work with System.Data.SQLite and is fully supported for use with it.