Hi, I asked the following question a few weeks ago, but did not get any responses, hoping someone may have an idea.
We are currently running System.Data.SQLite.dll 1.0.80.0 and would like to upgrade to a newer version. However there are a variety of issues we have run into, most of which I have now resolved, however one remains. Assume I have a database which is "malformed" due to rowid xxx missing from a table index. Using the 1.0.80.0 driver the following code would return the results from the pragma integrity_check call. private static IEnumerable<string> IntegrityCheck(SQLiteConnection connection) { using (var command = new SQLiteCommand(connection)) { command.CommandTimeout = 0; command.CommandText = "pragma integrity_check"; using (var reader = command.ExecuteReader()) { while (reader.Read()) { yield return reader.GetString(0); } } } } Our system would get a list of the rowid problems allowing it to log them and inform the user. I am currently testing using the 1.0.105.1 driver, however the ExecuteReader() call (above) throws an exception saying the database is malformed. That is not very helpful and effectively stops the system obtaining integrity check information. If I replace the integrity_check with quick_check it works and returns ok, so access to the file is ok, just some internal indexes are messed up. Is there any way to get the above working in the later drivers, or can someone tell me which driver update changed this behaviour? Kind Regards, Fugro Intersite. Barry Roberts. b.robe...@fugro.com<mailto:b.robe...@fugro.com> | www.fugro.com _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users