[IBATISNET-233] SQLite Provider node uses abandoned library. Updated node included

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: DataMapper 1.6.1
• Fix Version/s: DataMapper 1.6.2
• Component/s: DataMapper
• Assignee: Gilles Bayon
• Reporter: Michael T. Schall
• Created: 23/Jul/07 19:31
• Updated: 11/Sep/07 18:36
• Resolved: 11/Sep/07 18:36

Description

The svn provider config file references the Finisar.SQLite provider. This provider is not under active development and it's site points to the System.Data.SQLite provider. Included is an updated node that seems to work. It is not fully tested as I only needed dynamic sql, but select, insert, delete dynamic sql statements work great.

<provider name="SQLite3"
description="SQLite, SQLite.NET provider V1.0.43.0"
enabled="true"
assemblyName="System.Data.SQLite, Version=1.0.43.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139"
connectionClass="System.Data.SQLite.SQLiteConnection"
commandClass="System.Data.SQLite.SQLiteCommand"
parameterClass="System.Data.SQLite.SQLiteParameter"
parameterDbTypeClass="System.Data.SQLite.SQLiteType"
parameterDbTypeProperty="DbType"
dataAdapterClass="System.Data.SQLite.SQLiteDataAdapter"
commandBuilderClass="System.Data.SQLite.SQLiteCommandBuilder"
usePositionalParameters="false"
useParameterPrefixInSql="true"
useParameterPrefixInParameter="true"
parameterPrefix="@"
setDbParameterPrecision="false"
setDbParameterScale="false"
allowMARS="false"
/>