Re: [sqlite] System.Data.SQLite c#/Linq concurrent reads

2011-07-07 Thread Benjamin Savs
Thanks for the hint. Using a separate data context for the other thread solves the problem. But it doesn't make the situation much better, because the data context seem to have separate cashes. So it does not help to cash stuff in the background, because it won't be ready for the main thread

Re: [sqlite] System.Data.SQLite c#/Linq concurrent reads

2011-07-07 Thread Benjamin Savs
:06, Joe Mistachkin <sql...@mistachkin.com> wrote: > > Benjamin Savs wrote: > > If I run Linq-queries from several threads I will get an exception that > states > "*DataReader has been closed*". Is this normal or should there be a way to > issue > concurre

[sqlite] System.Data.SQLite c#/Linq concurrent reads

2011-07-07 Thread Benjamin Savs
Hello everybody, I stumbled upon this mailing list via http://system.data.sqlite.org/ and hope it is the right place to ask. I'm doing queries with c# and linq using System.Data.SQLite and noticed that it doesn't seem to be possible to do concurrent reads on the data. If I run Linq-queries from