How to configure SQLite in IBatis.net

IBatis configures SQLite3 as follows:

SqlMap. config

<?xml version="1.0" encoding="utf-8"?><sqlMapConfig xmlns="http://ibatis.apache.org/dataMapper" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">  <settings>    <setting useStatementNamespaces="true"/>    <setting cacheModelsEnabled="true"/>  </settings>  <providers resource="Providers.config"/>  <database>    <provider name="SQLite3"/>    <dataSource name ="IBatisNet" connectionString="Data Source = invoicing.db3;Version = 3" />  </database></sqlMapConfig>

 

 

Providers. config

  <!--SQLite 3 Support-->  <provider name="SQLite3"      description="SQLite, SQLite.NET provider V1.0.81.0"        enabled="true"        assemblyName="System.Data.SQLite, Version=1.0.81.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"    />