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>