I am working on a system with multiple processes (independent executables written in C#) that communicate status information through a single table in a common sqlite database. The system works fine if the database is not encrypted. Each process is able to insert records into and select records from the table (we always insert new records into the table and never update records).
When we encrypt the database, strange things begin to happen. Records are mysteriously deleted. Date/time fields of previously inserted records are updated. Generally unhappy things:-(
A few other details:
1. We are using version 1.0.65.0 of System.Data.SQLite as reported by the Assembly Cache Viewer (@ %windir%\Assembly)
2. The tables with which we are having trouble do have some triggers that update a date/time field after an insert.
3. All processes ultimately use the same piece of code (through a shared dll) to execute queries on the database.
Any ideas about how to troubleshoot this problem?