Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

LINQ with SQLite (linqtosql)

I have a small project that require a storage (I choose SQLite) and I got good result with the ADO DLL for .Net for Sqlite.

After the Install, I noticed that it contain a SQLLinq.dll. Before investigating too much effort, and because I haven't see any good example on the web, I would like to know if anyone got any good result with SQLite and LINQ?

*If linqtosql work the same way what ever the SQL database, let me know it. I was interesting with the Dll when I saw it because I never use Linqtosql before and I thought it would be a great opportunity to try,

like image 266
Patrick Desjardins Avatar asked Oct 30 '08 12:10

Patrick Desjardins


People also ask

Can I use LINQ with SQLite?

LinqConnect (formerly known as LINQ to SQLite) is a fast and lightweight ORM solution, which is closely compatible to Microsoft LINQ to SQL and contains its own advanced features, such as complex type support, advanced data fetching options, configurable compiled query caching, and others.

Does LINQ work with PostgreSQL?

No, LINQ to SQL works only with MS SQL Server. You have to use 3-rd party provider to access PostgreSQL datasource.

Why use SQLite?

The advantage of SQLite is that it is easier to install and use and the resulting database is a single file that can be written to a USB memory stick or emailed to a colleague. Many applications use SQLite as a cache of relevant content from an enterprise RDBMS.


2 Answers

I've recently discovered DBLinq, which supports SQLite among other DB:

like image 51
Ricardo Amores Avatar answered Sep 17 '22 13:09

Ricardo Amores


From my own experience, Microsoft SQL Compact Framework is a REAL NO-GO. It is REALLY FREAKING slow and its Query Analyzer is just really poor. I had to ask my team to rewrite all the plumbing code of my Windows Mobile component to get rid of the awful performances of SQL CE.

like image 31
fmarceau Avatar answered Sep 19 '22 13:09

fmarceau