Using a SQLiteProgressCallbackHander with Linq

[HadleyHope]

Really like working with linqConnect so far, but I have a couple of long running queries, is it possible to display a progress bar?

I note that the SQLiteConnection class has a RegisterProgressHandler method, but I am at the moment just using the data context created from the database via the Entity Developer passing in a connection string.


Thanks Martin

[MariiaI]

You could try doing this in the next way - after creating a DataContext object, get its connection, cast it to SQLiteConnection and then use RegisterProgressHandler/UnRegisterProgressHandler methods. For example:

Code: Select all

 MainContext.MainDataContext dt = new MainContext.MainDataContext();           
 SQLiteConnection conn = (SQLiteConnection) dt.Connection;
 conn.Open();
 conn.RegisterProgressHandler(handler);
 ....
 conn.UnRegisterProgressHandler();

Please tell us if this helps.