LINQ with SQLite (linqtosql)

Question

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

After installation, I noticed that it contains SQLLinq.dll. Before investigating too much effort, and because I don't see a good example on the Internet, I would like to know if anyone has a good result with SQLite and LINQ?

* If linqtosql works the same as always, the SQL database let me know. I was interested with Dll when I saw this, because I had never used Linqtosql before, and I thought it was a great opportunity to try it,

Answer 1

I recently discovered DBLinq , which supports SQLite among other databases:

Answer 2

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

Answer 3

LINQ to SQL only supports SQL Server / Compact, but SQLite people can write their own LINQ provider with the assembly name.

If in this case you could use the LINQ query syntax by adding a link to it, but you would not get LINQ to SQL specific functions, such as DataContext / designer / SQL Metal / Column / EntitySet / EntityRef and others.

Answer 4

I know this question is old, but at this time I think we can find the official implementation of SQLite support for .NET here: http://system.data.sqlite.org/index.html/doc/trunk/www/ index.wiki . A good introductory article can be found here: http://www.codeproject.com/Articles/236918/Using-SQLite-embedded-database-with-entity-framewo

Answer 5

This is not the answer to your question as such, but as an alternative, you can use SQL Compact:

http://www.microsoft.com/Sqlserver/2005/en/us/compact.aspx

Which has good LINQ-to-SQL support, and (despite the name) is great for desktop applications with low storage requirements.

Answer 6

There the package on NuGet is called "LINQ to SQLite". I have not tried it, but it seems fresh.

https://www.nuget.org/packages/linq2db.SQLite/

Answer 7

this is a good linq for sqlite ..

http://www.devart.com/dotconnect/sqlite/

Answer 8

SqLite support has been improved with EntityFramework 7, and EntityFramework.Commands can be used to create some migrations. Here is a tutorial:

https://xamlbrewer.wordpress.com/2016/06/01/getting-started-with-sqlite-and-entity-framework-on-uwp/

As a prerequisite, you must install at least PowerShell3.

Answer 9

Since DBLinq is no longer supported, I continued searching and found this answer that fuzzily points to a solution using Linq to Sql, Entity Framework, and SQLite. The blog post he is linking to is a bit outdated, but with some tweaks I got a working example up on GitHub.

It should start OOTB in Visual Studio 2013. It shows the addition of a record (with a related record to another table), changes and deletes. The Artist and Album classes represent entries in their respective tables (I assume this is part of the Entity Framework). See the Readme for a few fixes to keep in mind.