Ccna final exam - java, php, javascript, ios, cshap all in one. This is a collaboratively edited question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
Monday, June 4, 2012
Is there a .NET/C# wrapper for SQLite?
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?
"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.
UPDATE New fork available at http://system.data.sqlite.org/
The folks from sqlite.org have taken over the development of the ADO.NET provider:
From their homepage:
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.
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.
The complete list of features can be found at on their wiki. Highlights include
ADO.NET 2.0 support Full Entity Framework support Full Mono support Visual Studio 2005/2008 Design-Time support Compact Framework, C/C++ support
Released DLLs can be downloaded directly from the site.
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.
dotConnect for SQLite is an enhanced data provider for SQLite that builds on ADO.NET technology to present a complete solution for developing SQLite-based database applications. As a part of the Devart database application development framework, dotConnect for SQLite offers both high performance native connectivity to the SQLite database and a number of innovative development tools and technologies.
dotConnect for SQLite introduces new approaches for designing application architecture, boosts productivity, and leverages database application implementation.
Yes, you can find a wrapper here:
ReplyDeletehttp://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.
UPDATE
New fork available at http://system.data.sqlite.org/
Here are the ones I can find:
ReplyDeletemanaged-sqlite
SQLite.NET wrapper
System.Data.SQLite
Sources:
sqlite.org
other posters
There's also now this option: http://code.google.com/p/csharp-sqlite/ - a complete port of SQLite to C#.
ReplyDeleteThe folks from sqlite.org have taken over the development of the ADO.NET provider:
ReplyDeleteFrom their homepage:
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.
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.
The complete list of features can be found at on their wiki. Highlights include
ADO.NET 2.0 support
Full Entity Framework support
Full Mono support
Visual Studio 2005/2008 Design-Time support
Compact Framework, C/C++ support
Released DLLs can be downloaded directly from the site.
I'd definitely go with System.Data.SQLite (as previously mentioned: http://sqlite.phxsoftware.com/)
ReplyDeleteIt 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.
http://sqlite.phxsoftware.com/
ReplyDeleteVersion 1.2 of Monotouch includes support for System.Data. You can find more details here:
ReplyDeletehttp://monotouch.net/Documentation/System.Data
But basically it allows you to use the usual ADO .NET patterns with sqlite.
http://www.devart.com/dotconnect/sqlite/
ReplyDeletedotConnect for SQLite is an enhanced data provider for SQLite that builds on ADO.NET technology to present a complete solution for developing SQLite-based database applications. As a part of the Devart database application development framework, dotConnect for SQLite offers both high performance native connectivity to the SQLite database and a number of innovative development tools and technologies.
dotConnect for SQLite introduces new approaches for designing application architecture, boosts productivity, and leverages database application implementation.
I use the standard version,it works perfect :)
A barebones wrapper of the functions as provided by the sqlite library. Latest version supports functions provided sqlite library 3.7.10
ReplyDeleteSQLiteWrapper project