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?



Source: Tips4all

9 comments:

  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.

    UPDATE
    New fork available at http://system.data.sqlite.org/

    ReplyDelete
  2. Here are the ones I can find:


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


    Sources:


    sqlite.org
    other posters

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

    ReplyDelete
  4. 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.

    ReplyDelete
  5. 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.

    ReplyDelete
  6. http://sqlite.phxsoftware.com/

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

    ReplyDelete
  8. http://www.devart.com/dotconnect/sqlite/

    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.

    I use the standard version,it works perfect :)

    ReplyDelete
  9. A barebones wrapper of the functions as provided by the sqlite library. Latest version supports functions provided sqlite library 3.7.10

    SQLiteWrapper project

    ReplyDelete