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>

Last edited Feb 24, 2010 at 9:48 AM by ewdev, version 3

Comments

modma Sep 12, 2013 at 8:09 PM 
any way to do work Enterprise Library 6 Log/ExceptionHandling Logging with SQLite? i'm mad to do work with this.... (the connection with the db is ok, but can't do the log process) i need a script to initialize the db or any thing more?
thanks