SQLite LINQ Provider Data Context

Question

I am trying to get LINQ to work with SQLite in C# .NET

I downloaded http://system.data.sqlite.org/downloads/1.0.92.0/sqlite-netFx451-setup-bundle-x86-2013-1.0.92.0.exe and it has an assembly in it:

System.Data.SQLite.Linq.dll

How can I get the LINQ provider working? How do I setup a data context? I have looked at many Google search results to no avail.

See also this question http://stackoverflow.com/questions/9470583/creating-database-using-datacontext-and-system-data-sqlite-in-c-sharp — Astronavigator, Aug 03 '14 at 10:15

bricelam · Answer 1 · 2014-08-18T23:22:53.380

11

LINQ is just a specification. It requires an implementation (aka a provider) to actually work. Examples of implementations include LINQ to Objects, LINQ to XML, and Entity Framework.

The System.Data.SQLite.Linq assembly contains SQLite's Entity Framework provider. A while ago, I wrote a blog post on how to get started. See Entity Framework on SQLite.

edited Aug 18 '14 at 23:22

answered Mar 21 '14 at 16:12

bricelam

28,825
9
92
117

6

There was no references to EF in question. Likely author is trying to use Linq-to-SQL, which is different technique. – Astronavigator Aug 03 '14 at 10:08
-1 because your answer didn't talk about using LINQ with SQLite. – John Jesus Aug 14 '14 at 19:32
@JohnJesus The referenced blog post does under the *Start Coding* section. – bricelam Aug 18 '14 at 21:02
Ah, OK. I'll remove my downvote if you explain in your answer why we need EF to use LINQ on SQL. I had the same question as the OP and your answer did not really help me. – John Jesus Aug 18 '14 at 23:13
2

Thanks @JohnJesus, I've enhanced my answer. – bricelam Aug 18 '14 at 23:24
Cool. I get the idea now. – John Jesus Aug 19 '14 at 03:21

SQLite LINQ Provider Data Context

1 Answers1

Linked