Sqlite and the net framework
1 / 11

SQLite and the .NET Framework - PowerPoint PPT Presentation

  • Updated On :

SQLite and the .NET Framework. This PPT: Http://www.eggheadcafe.com/articles/SQLite.ppt. What is SQLite?. SQLite is a small C library that implements a self-contained, embeddable, zero-configuration SQL database engine.

Related searches for SQLite and the .NET Framework

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

PowerPoint Slideshow about 'SQLite and the .NET Framework' - betty_james

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Sqlite and the net framework l.jpg

SQLite and the .NET Framework

This PPT: Http://www.eggheadcafe.com/articles/SQLite.ppt

What is sqlite l.jpg
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 l.jpg
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 l.jpg
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 l.jpg
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 l.jpg
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 feedback.

  • WIN32 binaries (the ODBC driver DLL, install/uninstall programs) are in http://www.ch-werner.de/sqliteodbc/sqliteodbc-win32.zip

  • It works! It is SLOOOOW!

Sqlite in action a first look l.jpg
SQLite in Action: A First Look

private void CreateDatabase()


SQLiteConnection Conn = new SQLiteConnection();

string strPath=Server.MapPath("blog.db");

Conn.ConnectionString = "Data Source="+strPath+"; Compress=False;Synchronous=Off;New=True;Version=3";


SQLiteCommand Cmd = new SQLiteCommand();

Cmd = Conn.CreateCommand();

Cmd.CommandText="CREATE TABLE BlogItems (Blogid integer primary key , title varchar(250), link varchar(300), [description] varchar(8000), pubDate datetime, guid varchar(128), [public] integer )";

Cmd.ExecuteNonQuery(); . . . .

Important scenarios l.jpg
Important Scenarios

  • Mobile Code

    • Device-hosted applications

    • Database runs 100% on Device

    • “Zero configuration” installation

    • NO Client License Fees

  • Server / Desktop Code

    • Alternative to MSDE, MSAccess, MySql

    • No installation Required

    • Fast database engine

    • MultiThreaded

Mobile code scenario l.jpg
Mobile Code Scenario

  • Advantages of mobile code database

    • Executes locally for performance and rich features

    • Can use a WebService to receive “GetChanges” DataSets to update database on server

    • No dependency on “what kind” of database is used on the server.

    • No complicated Server configuration

    • No Client license fees to use SQLite

Urls articles and sample code l.jpg
URLS - Articles and Sample Code!

  • ASP.NET CacheDependency:http://www.eggheadcafe.com/articles/20040916.asp

  • SQLite DB and SQLiteBlog:

  • http://www.eggheadcafe.com/articles/20040714.asp

  • .Net Forum Control with SQLite: http://www.eggheadcafe.com/articles/20041009.asp

  • SQLite Compact Framework: http://www.eggheadcafe.com/articles/sqlitecf3.zip