1
2
3
4
5
6
7
8

<database>
    <provider name="SQLite3"/>
    <dataSource name="Test" connectionString="Data Source=Test.s3db;Version=3;useutf16encoding=false;"/>
</database>
 
<sqlMaps>
    <sqlMap resource="Maps/Customer.xml" />
</sqlMaps>

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19

<provider name="SQLite3"
    description="SQLite, SQLite.NET provider V1.0.48.0"
    enabled="true"
    assemblyName="System.Data.SQLite, Version=1.0.48.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139"
    connectionClass="System.Data.SQLite.SQLiteConnection"
    commandClass="System.Data.SQLite.SQLiteCommand"
    parameterClass="System.Data.SQLite.SQLiteParameter"
    parameterDbTypeClass="System.Data.SQLite.TypeAffinity"
    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"
  />

1
2
3
4

public Customer GetCustomerByID(int partyNo)
{
    return Mapper.Instance().QueryForObject<Customer>("GetCustomerByNo", partyNo);           
}