Does sqlite support linq-to-SQL?

Question

possible duplicate of http://stackoverflow.com/questions/250071/linq-with-sqlite-linqtosql — Matthew Flaschen, Apr 28 '10 at 04:57

score 3 · Accepted Answer · answered Apr 28 '10 at 04:56

3

No database supports LINQ. LINQ is an abstraction layer on top of the database so it depends on the ADO.NET provider. LINQ-to-SQL is also bound to SQL Server.

That being said this SQLLite provider has support for LINQ to Entities.

answered Apr 28 '10 at 04:56

willbt

1,875
13
11

Yes, Linq-to-Entities = Entity Framework. The OP was asking about Linq-to-SQL, though – marc_s Apr 28 '10 at 05:09
I'm aware of that but I have noticed alot of confusion between LINQ-to-SQL and Entity Framework. Entity Framework is designed to work with any Database where as LINQ-to-SQL is not. – willbt Apr 28 '10 at 05:48
@willbt - thanks - so if I'm working with SQLite and have a driver/binding that lets me do SQL to the database, then I should be able to get EF working to the it too then? whereas for Linq-to-sql I'd have to look for specific support in the binding/driver? is this correct – Greg Apr 28 '10 at 21:02

score 1 · Answer 2 · answered Apr 28 '10 at 05:09

1

There's a third-party library called LinqConnect that is aiming at providing Linq-to-SQL support to a variety of database backends - including SQLite.

answered Apr 28 '10 at 05:09

marc_s

732,580
175
1,330
1,459

I've just noted another at http://code.google.com/p/dblinq2007/ . Any idea which one would be best to go with? – Greg Apr 28 '10 at 06:39
@Greg: no, since I've never had that requirement, I've never tried either of the two (wasn't aware of the dblinq2007). So I can't give any first-hand reports on which one works better, sorry. – marc_s Apr 28 '10 at 07:45

score 1 · Answer 3 · answered Apr 18 '11 at 22:55

There's also IQToolkit, which does nothing other than reimplement all of LINQ-to-SQL in open source. This is great if you want "raw" access to your database. IQToolkit Contrib could be handy too if you go this route.

If you're more of an ORM type, you could look at SubSonic (which is built on IQToolkit).

Does sqlite support linq-to-SQL?

3 Answers3