Is there a .NET/C# wrapper for SQLite?

Question

I'd sort of like to use SQLite from within C#.Net, but I can't seem to find an appropriate library. Is there one? An official one? Are there other ways to use SQLite than with a wrapper?

Answer 1

Yes, you can find a wrapper here:

http://sqlite.phxsoftware.com/

"System.Data.SQLite is the original SQLite database engine and a complete ADO.NET 2.0 provider all rolled into a single mixed mode assembly. It is a complete drop-in replacement for the original sqlite3.dll (you can even rename it to sqlite3.dll). Unlike normal mixed assemblies, it has no linker dependency on the .NET runtime so it can be distributed independently of .NET."

It even supports mono.

Answer 2

http://sqlite.phxsoftware.com/

Answer 3

Here are the ones I can find:

• managed-sqlite
• SQLite.NET wrapper
• System.Data.SQLite

Sources:

• sqlite.org
• other posters

Answer 4

I'd definitely go with System.Data.SQLite (as previously mentioned: http://sqlite.phxsoftware.com/)

It is coherent with ADO.NET (System.Data.*), and is compiled into a single DLL. No sqlite3.dll - because the C code of SQLite is embedded within System.Data.SQLite.dll. A bit of managed C++ magic.

Answer 5

There's also now this option: http://code.google.com/p/csharp-sqlite/ - a complete port of SQLite to C#.

Answer 6

Version 1.2 of Monotouch includes support for System.Data. You can find more details here: http://monotouch.net/Documentation/System.Data

But basically it allows you to use the usual ADO .NET patterns with sqlite.