Re: [sqlite] SQLite Linq not being loaded

Thanks! I'll give that a try! On 9 September 2013 12:47, Kevin Benson wrote: > I am not familiar with the Windows System.Data.SQLite environment. The > maintainer (Joe Mistachkin) is pretty good about catching up to the users > list when he has time. Have you tried

Re: [sqlite] SQLite Linq not being loaded

I am not familiar with the Windows System.Data.SQLite environment. The maintainer (Joe Mistachkin) is pretty good about catching up to the users list when he has time. Have you tried what's mentioned at the bottom of this page?

Re: [sqlite] SQLite Linq not being loaded

Thanks, but that just confirms what I mentioned which is that SCOPE_IDENTITY is not valid in SQLite. The issue here is that the generation of SQL statements from Linq statements is not being done by System.Data.SQLite.Linq which should be generating the correct syntax. There are other examples of

Re: [sqlite] SQLite Linq not being loaded

On Sun, Sep 8, 2013 at 2:36 AM, Steve Palmer wrote: > Hi! > > Has anybody successfully used System.Data.SQLite.Linq in their project and > can perhaps help me with this? > > Even after including this DLL in my project reference, it is apparent that > Linq is calling the wrong

Re: [sqlite] SQLite Linq not being loaded

I've not had any response but it seems that System.Data.SQLite.Linq.dll doesn't work with DataContext at all. I'm not sure why it is supplied. I've found no examples of anything that uses this so it doesn't seem worth shipping this. I've found SQLite.Net which is a different C# sqlite wrapper

[sqlite] SQLite Linq not being loaded

Hi! Has anybody successfully used System.Data.SQLite.Linq in their project and can perhaps help me with this? Even after including this DLL in my project reference, it is apparent that Linq is calling the wrong provider when building the appropriate SQL statements. It is throwing an exception in