CODEWITHSUNDEEP
c#linqsqlite
Eric Dand
Eric Dand

Reputation: 1210

How do I make LINQ queries to an SQLite database?

The System.Data.SQLite namespace includes a sub-namespace, System.Data.SQLite.Linq, which the website claims provides LINQ support. However, I can find no documentation of how to actually use it. In the following piece of code, what kind of object must table be, and how do I create one?

var rows = 
    from row in table
    where row.Id == 4345
    select column1, column2

Upvotes: 3

Views: 2577

Answers (1)

Gautam Jain
Gautam Jain

Reputation: 6849

I haven't use the library that you mentioned. So I can't tell why it is not working.

However, I think you may want to try the open source Sqlite.Net library. Even better is Sqlite.Net Extensions which supports one-to-many relationships etc.

I am using the latter (PCL version) in my Xamarin project successfully with linq queries.

Upvotes: 3

Related Questions