Hi all, I am using System.Data.SQLite, currently 1.0.98.1, with EntityFramework 6.1.3.
I want to make use of the SQLiteConnection.Progress event but can't get it to fire. I've set SQLiteConnection.ProgressOps to 1, 2 or 10, to no avail. I have also tried the other SQLiteConnection events. StateChange, Update, Authorize, Commit and Disposed all worked as anticipated, Trace did not. Could that be related? I obtain the current SQLiteConnection from EF's DbContext instance, set ProgressOps to non-zero and subscribe the Progress event. After that I run my queries or insert new data, commit the whole thing via DbContext.SaveChanges() and dispose of the context. All works fine, but SQLite just won't give progress feedback. Are there any tricks to get Progress working? Thanks Roland