SQLite - Revision history

WikiSysop at 08:45, 14 August 2010

2010-08-14T08:45:42Z

← Older revision		Revision as of 08:45, 14 August 2010
Line 11:		Line 11:
	====SQLite Tutorials====		====SQLite Tutorials====
	* [http://souptonuts.sourceforge.net/readme_sqlite_tutorial.html SQLite Tutorial]		* [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====		====Using SQLite with C# .NET====

WikiSysop: /* Using SQLite with C# .NET */

2010-07-21T15:38:39Z

Using SQLite with C# .NET

← Older revision		Revision as of 15:38, 21 July 2010
Line 17:		Line 17:
	* [http://sourceforge.net/projects/sqlite-dotnet2/ ADO.NET 2.0 Provider for SQLite - Sourceforge]		* [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://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">

WikiSysop: /* Using SQLite with C# .NET */

2010-07-21T15:31:52Z

Using SQLite with C# .NET

← Older revision		Revision as of 15:31, 21 July 2010
Line 16:		Line 16:
	* [http://sqlite.phxsoftware.com/readme.htm System.Data.SQLite Readme]		* [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://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]
	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">

WikiSysop: /* Using SQLite with C# .NET */

2010-07-21T15:30:17Z

Using SQLite with C# .NET

← Older revision		Revision as of 15:30, 21 July 2010
Line 14:		Line 14:
	====Using SQLite with C# .NET====		====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://sourceforge.net/projects/sqlite-dotnet2/ ADO.NET 2.0 Provider for SQLite - Sourceforge]

WikiSysop: /* SQLite official homepage */

2010-07-21T15:15:03Z

SQLite official homepage

← Older revision		Revision as of 15:15, 21 July 2010
Line 8:		Line 8:
	* [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]

			====SQLite Tutorials====
			* [http://souptonuts.sourceforge.net/readme_sqlite_tutorial.html SQLite Tutorial]

	====Using SQLite with C# .NET====		====Using SQLite with C# .NET====

WikiSysop at 15:08, 21 July 2010

2010-07-21T15:08:06Z

← Older revision		Revision as of 15:08, 21 July 2010
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~~]		====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]

			====Using SQLite with C# .NET====
			* [http://sqlite.phxsoftware.com/ System.Data.SQLite]
	* [http://sourceforge.net/projects/sqlite-dotnet2/ ADO.NET 2.0 Provider for SQLite - Sourceforge]		* [http://sourceforge.net/projects/sqlite-dotnet2/ ADO.NET 2.0 Provider for SQLite - Sourceforge]

	* [http://sqlite.phxsoftware.com/ System.Data.SQLite]
	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">

WikiSysop at 12:58, 21 July 2010

2010-07-21T12:58:04Z

← Older revision		Revision as of 12:58, 21 July 2010
Line 6:		Line 6:
	* [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://sourceforge.net/projects/sqlite-dotnet2/ ADO.NET 2.0 Provider for SQLite - Sourceforge]		* [http://sourceforge.net/projects/sqlite-dotnet2/ ADO.NET 2.0 Provider for SQLite - Sourceforge]

WikiSysop at 12:54, 21 July 2010

2010-07-21T12:54:12Z

← Older revision		Revision as of 12:54, 21 July 2010
Line 5:		Line 5:
	* [http://www.sqlite.org/ SQLite official homepage]		* [http://www.sqlite.org/ SQLite official 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://sourceforge.net/projects/sqlite-dotnet2/ ADO.NET 2.0 Provider for SQLite - Sourceforge]		* [http://sourceforge.net/projects/sqlite-dotnet2/ ADO.NET 2.0 Provider for SQLite - Sourceforge]

WikiSysop at 12:37, 21 July 2010

2010-07-21T12:37:35Z

← Older revision		Revision as of 12:37, 21 July 2010
Line 18:		Line 18:
	</source>		</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.'''		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.'''
	[http://msdn.microsoft.com/en-us/library/bbx34a2h(VS.100).aspx ~~Specifies whether to enable the~~ .~~NET Framework version 2~~.~~0 runtime activation policy or to use the~~ .~~NET Framework version 4 activation policy~~]		[http://msdn.microsoft.com/en-us/library/bbx34a2h(VS.100).aspx Explanation from Microsoft] and another explanation can be found [http://www.marklio.com/marklio/PermaLink,guid,ecc34c3c-be44-4422-86b7-900900e451f9.aspx here].


	* [http://www.exendo.se/articles/software-development-tools-for-simple-local-file-versioning/the-best-database-for-desktop-applications The best database for desktop applications - Exendo - Articles on software development]		* [http://www.exendo.se/articles/software-development-tools-for-simple-local-file-versioning/the-best-database-for-desktop-applications The best database for desktop applications - Exendo - Articles on software development]

	<google>ENGELSK</google>		<google>ENGELSK</google>

WikiSysop at 12:35, 21 July 2010

2010-07-21T12:35:52Z

← Older revision		Revision as of 12:35, 21 July 2010
Line 18:		Line 18:
	</source>		</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.'''		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.'''
			[http://msdn.microsoft.com/en-us/library/bbx34a2h(VS.100).aspx Specifies whether to enable the .NET Framework version 2.0 runtime activation policy or to use the .NET Framework version 4 activation policy]

	* [http://www.exendo.se/articles/software-development-tools-for-simple-local-file-versioning/the-best-database-for-desktop-applications The best database for desktop applications - Exendo - Articles on software development]		* [http://www.exendo.se/articles/software-development-tools-for-simple-local-file-versioning/the-best-database-for-desktop-applications The best database for desktop applications - Exendo - Articles on software development]

	<google>ENGELSK</google>		<google>ENGELSK</google>