Tim Stowell wrote: > > SELECT TOP (20) [t0].[field1], [t0].[ field1], [t0].[field2] FROM > [tablename] AS [t0] > > Instead of the "TOP" keyword it should be "LIMIT" >
As far as I can tell, this cannot currently be generated by the System.Data.SQLite.Linq (or EF6) assembly. In the past, I believe there was an issue where it would not emit the LIMIT clause; however, that was fixed long ago. Perhaps the project is picking up an outdated version of the managed assemblies for System.Data.SQLite somewhere? -- Joe Mistachkin