Hi
Does sqlite support linq-to-SQL?
+1
A:
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.
willbt
2010-04-28 04:56:54
Yes, Linq-to-Entities = Entity Framework. The OP was asking about Linq-to-SQL, though
marc_s
2010-04-28 05:09:22
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
2010-04-28 05:48:52
@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
2010-04-28 21:02:29
+1
A:
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.
marc_s
2010-04-28 05:09:57
I've just noted another at http://code.google.com/p/dblinq2007/ . Any idea which one would be best to go with?
Greg
2010-04-28 06:39:30
@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
2010-04-28 07:45:38