Rectangle 27 0

Is there a .NETC wrapper for SQLite?


"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."

@NathanRidley - Are you sure its 100% managed, because this answer says "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. "

Just for consistency, because people is talking about both as different things. In sqlite.phxsoftware.com you are pointed to sourceforge.net/projects/sqlite-dotnet2 for downloading.

System.Data.SQLite was started by Robert Simpson. Robert still has commit privileges on this repository but is no longer an active contributor. Development and maintenance work is now mostly performed by the SQLite Development Team. The SQLite team is committed to supporting System.Data.SQLite long-term.

This is an old question but I had to add my $0.02. System.Data.SQLite rocks. It is super refined, stable and commercial grade quality. Best of all, it's 100% managed code and has been released as public domain source code.

This wrapper is no longer being developed by its original author, and development seems to have been taken over by SQLite itself. The new site is at system.data.sqlite.org, though at the moment it seems less user-friendly and more work-in-progress compared to the original.

Note
Rectangle 27 0

Is there a .NETC wrapper for SQLite?


"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."

@NathanRidley - Are you sure its 100% managed, because this answer says "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. "

FYI, I tried using Microsoft's Microsoft.Data.Sqlite .NET Standard Nuget package, but it failed on a handful of integration tests in the AsyncPoco Github library. After switching to System.Data.SQLite, everything worked perfectly.

Just for consistency, because people is talking about both as different things. In sqlite.phxsoftware.com you are pointed to sourceforge.net/projects/sqlite-dotnet2 for downloading.

System.Data.SQLite was started by Robert Simpson. Robert still has commit privileges on this repository but is no longer an active contributor. Development and maintenance work is now mostly performed by the SQLite Development Team. The SQLite team is committed to supporting System.Data.SQLite long-term.

This is an old question but I had to add my $0.02. System.Data.SQLite rocks. It is super refined, stable and commercial grade quality. Best of all, it's 100% managed code and has been released as public domain source code.

This wrapper is no longer being developed by its original author, and development seems to have been taken over by SQLite itself. The new site is at system.data.sqlite.org, though at the moment it seems less user-friendly and more work-in-progress compared to the original.

Note
Rectangle 27 0

Is there a .NETC wrapper for SQLite?


  • 0 dependencies aside from a compiled form of the sqlite2 library.
  • Not an ADO.NET implementation. This is not a full SQLite driver. If you need that, use System.Data.SQLite.
  • Thin wrapper over SQLite and should be fast and efficient. (The library should not be the performance bottleneck of your queries.)
  • Very easy to integrate with existing projects and with MonoTouch projects.
  • Very simple methods for executing CRUD operations and queries safely (using parameters) and for retrieving the results of those query in a strongly typed fashion.
  • Works with your data model without forcing you to change your classes. (Contains a small reflection-driven ORM layer.)

I notice that most of the comment prior 2014 said System.Data.SQLite which I tried to install on my Windows Store App (didn't work). Sqlite-net works.

It is available as a Nuget package, where it is the 2nd most popular SQLite package with over 60,000 downloads as of 2014.

It is written in C# and is meant to be simply compiled in with your projects. It was first designed to work with MonoTouch on the iPhone, but has grown up to work on all the platforms (Mono for Android, .NET, Silverlight, WP7, WinRT, Azure, etc.).

sqlite-net is an open source, minimal library to allow .NET and Mono applications to store data in SQLite 3 databases. More information at the wiki page.

sqlite-net was designed as a quick and convenient database layer. Its design follows from these goals:

Note
Rectangle 27 0

Is there a .NETC wrapper for SQLite?


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.

Note
Rectangle 27 0

Is there a .NETC wrapper for SQLite?


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

Note
Rectangle 27 0

Is there a .NETC wrapper for SQLite?


Historical versions, as well as the original support forums, may still be found at http://sqlite.phxsoftware.com, though there have been no updates to this version since April of 2010.

Released DLLs can be downloaded directly from the site.

The complete list of features can be found at on their wiki. Highlights include

The folks from sqlite.org have taken over the development of the ADO.NET provider:

This is a fork of the popular ADO.NET 4.0 adaptor for SQLite known as System.Data.SQLite. The originator of System.Data.SQLite, Robert Simpson, is aware of this fork, has expressed his approval, and has commit privileges on the new Fossil repository. The SQLite development team intends to maintain System.Data.SQLite moving forward.

Note
Rectangle 27 0

Is there a .NETC wrapper for SQLite?


Here are the ones I can find:

Note
Rectangle 27 0

Is there a .NETC wrapper for SQLite?


This seems the thinnest of all worlds, minimizing your dependence on third party libraries. If I had to do this project from scratch, this is the way I would do it.

Note
Rectangle 27 0

Is there a .NETC wrapper for SQLite?


Microsoft now provides Microsoft.Data.Sqlite as a first-party SQLite solution for .NET, which is provided as part of ASP.NET Core. The license is the Apache License, Version 2.0.

Note
Rectangle 27 0

Is there a .NETC wrapper for SQLite?


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.

Note