Hi,
it would be nice if we would update to the latest version of the ADO.NET provider, as some bugs seem to be fixed. From the changelog:
-alibert
it would be nice if we would update to the latest version of the ADO.NET provider, as some bugs seem to be fixed. From the changelog:
Quote:
- Code merge with SQLite 3.3.6
- Added support for the |DataDirectory| keyword in the Data Source filename string.
- Added hook notification support to SQLiteConnection. Specifically, there are three new events on the SQLiteConnection object which are raised when an update/insert/delete occurs and when transactions are committed and rolled back.
- Changed SQLiteTransaction to default to BEGIN IMMEDIATE instead of just BEGIN, which solves a multithreaded race condition.
- Changed SQLiteDataReader to better support SQLite's typelessness. The data reader no longer caches column affinity, but re-evaluates it for each column/row.
- Fixed a bug in Prepare() which caused an intermittant fault due to the code accessing the memory of an unpinned variable.
- Fixed a multithreaded lock-retry bug in in SQLiteConnection.Open() and in SQLiteTransaction, which failed to use a command timeout before giving up.
-alibert