SQLite: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| (5 intermediate revisions by the same user not shown) | |||
| Line 3: | Line 3: | ||
* [http://en.wikipedia.org/wiki/SQLite SQLite - Wikipedia] | * [http://en.wikipedia.org/wiki/SQLite SQLite - Wikipedia] | ||
* [http://www.sqlite.org/ | ====SQLite official homepage==== | ||
* [http://www.sqlite.org/ Homepage] | |||
* [http://www.sqlite.org/version3.html SQLite Version 3 Overview] | * [http://www.sqlite.org/version3.html SQLite Version 3 Overview] | ||
* [http://www.sqlite.org/lang.html SQL As Understood By SQLite] | * [http://www.sqlite.org/lang.html SQL As Understood By SQLite] | ||
* [http://www.sqlite.org/datatype3.html Datatypes In SQLite Version 3] | * [http://www.sqlite.org/datatype3.html Datatypes In SQLite Version 3] | ||
* [http://sourceforge.net/ | ====SQLite Tutorials==== | ||
* [http://souptonuts.sourceforge.net/readme_sqlite_tutorial.html SQLite Tutorial] | |||
====Optimizing SQLite==== | |||
* [http://web.utk.edu/~jplyon/sqlite/SQLite_optimization_FAQ.html SQLite Optimization FAQ] | |||
====Using SQLite with C# .NET==== | |||
* [http://sqlite.phxsoftware.com/ System.Data.SQLite] | * [http://sqlite.phxsoftware.com/ System.Data.SQLite] | ||
* [http://sqlite.phxsoftware.com/readme.htm System.Data.SQLite Readme] | |||
* [http://sourceforge.net/projects/sqlite-dotnet2/ ADO.NET 2.0 Provider for SQLite - Sourceforge] | |||
* [http://connectionstringexamples.com/staticpages/index.php?page=Connection-strings-Examples-for-SQLite Connection strings Examples for SQLite] | |||
* [http://www.csharphacker.com/technicalblog/index.php/2009/06/16/sqlite-for-c-part-1-am-i-allowed-to-use-it/ SQLite for C# – Part 1-8] | |||
If you are using '''.NET Framework 4''' and '''System.Data.SQLite''' you need to add following to yout applications config file. | If you are using '''.NET Framework 4''' and '''System.Data.SQLite''' you need to add following to yout applications config file. | ||
<source lang="xml"> | <source lang="xml"> | ||
Latest revision as of 08:45, 14 August 2010
SQLite official homepage
SQLite Tutorials
Optimizing SQLite
Using SQLite with C# .NET
- System.Data.SQLite
- System.Data.SQLite Readme
- ADO.NET 2.0 Provider for SQLite - Sourceforge
- Connection strings Examples for SQLite
- SQLite for C# – Part 1-8
If you are using .NET Framework 4 and System.Data.SQLite you need to add following to yout applications config file. <source lang="xml">
<configuration> <startup useLegacyV2RuntimeActivationPolicy="true"> <supportedRuntime version="v4.0" /> </startup> </configuration>
</source> otherwise you will get an exception: Mixed mode assembly is built against version 'v2.0.50727' of the runtime and cannot be loaded in the 4.0 runtime without additional configuration information. Explanation from Microsoft and another explanation can be found here.
<google>ENGELSK</google>