如何在IBatis.net配置SQLite

IBatis 配置 SQLite3 如下：

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"  
  />