CODEWITHSUNDEEP
c#sqliteado
bill seacham
bill seacham

Reputation: 395

How to use SQLite in c# without an ADO wrapper

Is this even possible? All of the aritcles I have read state that an ADO wrapper is necessary, but the SQLite website implies that nothing other than their DLL is needed. IF it is possible, then I would expect there to be code examples out there.

Upvotes: 2

Views: 1065

Answers (3)

Matthew Abbott
Matthew Abbott

Reputation: 61617

Question is, why wouldn't you want to use an ADO.NET provider? It's the standard framework for accessing databases in .NET. I suppose you could use P/Invoke and access the SqlLite library, but thats a lot of work, and why reinvent the wheel when an ADO.NET provider already exists. ADO.NET is not just the plumbing for accessing database, it also provides a common pattern for accessing data, regardless of provider.

IMO, stick with the SqlLite ADO.NET Provider.

Upvotes: 1

code4life
code4life

Reputation: 15794

Look here:

http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers

Specifically, search for ".NET Framework".

One of there wrappers there: http://www.phpguru.org/static/SQLite.NET.html - this one does not use ADO, it's just an extremely lightweight SQLite access library.

There's quite a few wrappers there, I'm sure you'll find one to your liking.

Upvotes: 3

Paul Talbot
Paul Talbot

Reputation: 1603

Take a look at these two pages

http://adodotnetsqlite.sourceforge.net/

http://www.connectionstrings.com/sqlite

HTH

Upvotes: 0

Related Questions