SQLite and the .NET Framework.ppt

SQLite and the .NET Framework What is SQLite? SQLite is a small C library that implements a self-contained, embeddable, zero-configuration SQL database engine. Transactions are atomic, consistent, isolated, and durable (ACID) even after system crashes and power failures. Zero-configuration - no setup or administration needed. Implements most of SQL92. A complete database is stored in a single disk file. Database files can be freely shared between machines with different byte orders. Supports databases up to 2 terabytes (241 bytes) in size. Sizes of strings and BLOBs limited only by available memory. What is SQLite – continued Faster than popular client/server database engines for most common operations. Simple, easy to use API. Bindings for many languages available Well-commented source code with over 95% test coverage. Self-contained: no external dependencies. Sources are in the public domain. Use for any purpose. There is now a robust SQLite.NET ADO.NET provider! Small code footprint: less than 30K lines of C code, less than 250KB code space Installation: Just set “Build Action” to “Content” on Database file! More SQLite Features Create Database Programmatically in Connection string No need to distribute or install database SQL to create database, tables, triggers can be embedded Triggers Triggers can be used to handle many of the functions of stored procedures. Vacuum Just like “Compact Database” in MS Access. The SQLite ADO.NET Provider Conforms to normal ADO.NET Best practices Offers: SQLiteConnection SQLiteCommand - all Methods except “Xml” SQLiteDataAdapter SQLiteCommandBuilder Supports NTFS compression of Database File SQLite 3.0 ODBC Driver Http://www.ch-werner.de/sqliteodbc/html/ This is an experimental open source ODBC driver for the wonderful SQLite 2.8.* and SQLite 3.* (alpha) Database Engine/Library. So far it is more a proof of concept and might contain lots of memory leaks and all other kinds of bugs. Thus I highly appreciate