Databases
How can I use SQLITE in your hosting account?
Databases
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
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
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> |
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