SQLite is an embedded SQL database engine.
Unlike most other SQL databases, SQLite does not have a separate
server process. SQLite reads and writes directly to ordinary disk
files. A complete SQL database with multiple tables, indices,
triggers, and views, is contained in a single disk file.
SQLite can be use with many scripts, such as Tcl, C#,PHP, Java. It is much more faster then the popular database Mysql?PostgreSQL with ODBC connection.
We support ASP.NET+SQLite, if you get error when using it, please follow the instructions below(let's use System.Data.SQLite 1.0.57.0 as the example)
1. Please add the script below in your web.config file
<system.data>
<DbProviderFactories>
<remove invariant="System.Data.SQLite"/>
<add name="SQLite Data Provider" invariant="System.Data.SQLite" description=".Net Framework Data Provider for SQLite" type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite, Version=1.0.57.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139" />
</DbProviderFactories>
</system.data> |
2. Upload the necessary DLL files to BIN folder.
System.Data.SQLite.DLL
System.Data.SQLite.Linq.dll
System.Data.SQLite offical download url
http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki
Article ID: 247, Created: October 22, 2012 at 10:43 PM, Modified: October 22, 2012 at 10:43 PM