SQLite Data Provider

This version of the Enterprise Library SQLite Data Provider was tested against the SQLite Expert v2.3.2.1919
and uses the SQLite.NET data provider v1.0.65.0 downloaded separately.

The SQLite database and admin tools can be downloaded from http://www.sqliteexpert.com/download.html and are licence free.
The SQLite.NET data provider can be downloaded from http://sourceforge.net/projects/sqlite-dotnet2/files/SQLite%20for%20ADO.NET%202.0/ and is licence free.

Install SQLite Expert Personal. This will give you an admin tool for managing SQLite databases.
Install the SQLite ADO.NET 2.0/3.5 Data Provider using the downloaded installer which will put the System.Data.SQLite Data Provider into the GAC.

Note: SQLite does not support stored procedures and there is no user authentication security on the Database as such.

The following is an example of a configuration file using a SQLite Data Provider:

[XML]
<?xml version="1.0" encoding="utf-8"?>
<configuration>
	<configSections>
		<section name="dataConfiguration" type="Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings, Microsoft.Practices.EnterpriseLibrary.Data, Version=4.1.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" />
	</configSections>
	<dataConfiguration defaultDatabase="Service_Dflt">
		<providerMappings>
			<add databaseType="EntLibContrib.Data.SQLite.SQLiteDatabase, EntLibContrib.Data.SQLite, Version=4.1.0.0, Culture=neutral, PublicKeyToken=null" name="System.Data.SQLite" />
		</providerMappings>
	</dataConfiguration>
	<connectionStrings>
		<add	name="Service_Dflt"
			providerName="System.Data.SQLite"
			connectionString="Data Source=Northwind.db;Version=3;" />
		<add	name="NewDatabase"
			providerName="System.Data.SQLite"
			connectionString="Data Source=Northwind.db;Version=3;"/>
		<add	name="DbWithSQLiteAuthn"
			providerName="System.Data.SQLite"
			connectionString="Data Source=Northwind.db;Version=3;"/>
		<add	name="NwindPersistFalse"
			providerName="System.Data.SQLite"
			connectionString="Data Source=Northwind.db;Version=3;"/>
	</connectionStrings>
</configuration>