Tigran's Blog » Getting started with SQLite in C# Part One. SQLite Administrator - International Milestone Beta. Using SQLite With C# - C# Tutorials. Download Page. Small. Fast. Reliable.Choose any three. Build Product Names Build products are named using one of the following templates: sqlite-product-version.zip sqlite-product-version.tar.gz sqlite-product-os-cpu-version.zip sqlite-product-date.zip Templates (1) and (2) are used for source-code products.
The version is encoded so that filenames sort in order of increasing version number when viewed using "ls". The date in template (4) is of the form: YYYYMMDDHHMM Source Code Repositories The SQLite source code is maintained in three geographically-dispersed self-synchronizing Fossil repositories that are available for anonymous read-only access. Note that a unix-like development environment, including a recent version of Tcl, is required in order to build from the repository sources. (Dallas) (Newark) (Fremont) The documentation is maintained in separate Fossil repositories located at: System.Data.SQLite: System.Data.SQLite Download Page. Build Product Names Beginning with System.Data.SQLite version 1.0.74.0 (3.7.7.1), the following templates will be used for the names of the build products: sqlite-netFx-source-version.zip sqlite-netFx-source-version.tar.gz sqlite-framework-setup-cpu-year-version.exe sqlite-framework-setup-bundle-cpu-year-version.exe sqlite-framework-binary-platform-year-version.zip sqlite-framework-binary-bundle-platform-year-version.zip sqlite-framework-static-binary-platform-year-version.zip sqlite-framework-static-binary-bundle-platform-year-version.zip sqlite-netFx-source-date.zip System.Data.SQLite.version.nupkg System.Data.SQLite.variant.version.nupkg Templates (1) and (2) are used for source-code packages.
Template (1) is used for generic source-code packages and template (2) is used for source-code packages that are generally only useful on unix-like platforms. The framework in templates (3), (4), (5), (6), (7), and (8) will be one of netFx20, netFx35, netFx40, netFx45, netFx451. Using SQLite in your C# Application. Introduction SQLite is a small, fast and embeddable database where the database engine and the interface are combined into a single library. It also has the ability to store all the data in a single file. So if your application requires a standalone database, SQLite is perhaps the perfect choice for you. There are, of course, other reasons for choosing SQLite including: SQLite has a small memory footprint and only a single library is required to access databases, making it ideal for embedded database applications.
SQLite has been ported to many platforms and runs even on Windows CE and Palm OS. SQLite is ACID-compliant, meeting all four criteria - Atomicity, Consistency, Isolation, and Durability. Using the Code To use SQLite in your C# application, you need to download a third party free ADO.NET data provider (SQLite.NET.0.21_x68_dll.zip) from here. Fig 1: Demo C# SQLite application.
To administer SQLite database, an open-source SQLite GUI Database Browser utility is of much use. SQLite C# tutorial. Home This is a C# tutorial for the SQLite database. It covers the basics of SQLite programming with C#. The examples were created and tested on Linux. Table of Contents SQLite & C# SQLite is an embedded relational database engine. C# is a modern, high-level, general-purpose, object-oriented programming language. Similar tutorials The SQLite tutorial covers the SQLite embedded database engine. Introduction to SQLite. HomeContents This is SQLite tutorial. It covers the SQLite database engine, sqlite3 command line tool and the SQL language covered by the database engine. It is an introductory tutorial for the beginners. It covers SQLite version 3.0. SQLite database SQLite is an embedded relational database engine. SQLite implements most of the SQL-92 standard for SQL. Definitions A relational database is a collection of data organized in tables. Tables used Here we will list all the tables that are used throughout the tutorial.
Sqlite> .read authors.sql Here we execute the SQL statements located in the authors.sql file. Movies database This is the movies.db database. This is the Actors table. This is the Movies table. This is the ActorsMovies table. Test database Here we have the tables from the test.db. This is the Cars table. This is the Orders table. This is the Friends table. This are the Customers and Reservations tables. This is the Books table. Sources This chapter was an introduction to the SQLite database.