1. SmartSqlMapConfig

1.1. Demo

<?xml version="1.0" encoding="utf-8" ?>
<SmartSqlMapConfig xmlns="http://SmartSql.net/schemas/SmartSqlMapConfig.xsd">
  <Settings IsWatchConfigFile="true" />
  <Database>
    <!--ParameterPrefix:[SqlServer:@ | MySQL:? |Oracle::] -->
    <!--<DbProvider Name="MySqlClientFactory" ParameterPrefix="?" Type="MySql.Data.MySqlClient.MySqlClientFactory,MySql.Data"/>-->
    <!--<DbProvider Name="OracleClientFactory" ParameterPrefix=":" Type="Oracle.ManagedDataAccess.Client.OracleClientFactory,Oracle.ManagedDataAccess"/>-->
    <!--<DbProvider Name="NpgsqlFactory" ParameterPrefix="@" Type="Npgsql.NpgsqlFactory,Npgsql"/>-->
    <DbProvider Name="SqlClientFactory" ParameterPrefix="@" Type="System.Data.SqlClient.SqlClientFactory,System.Data.SqlClient"/>
    <Write Name="WriteDB" ConnectionString="Data Source=.;database=TestDB;uid=sa;pwd=SmartSql.net"/>
    <Read Name="ReadDB-0" ConnectionString="Data Source=.;database=TestDB;uid=sa;pwd=SmartSql.net" Weight="80"/>
    <Read Name="ReadDB-1" ConnectionString="Data Source=.;database=TestDB;uid=sa;pwd=SmartSql.net" Weight="20"/>
  </Database>
  <TypeHandlers>
    <TypeHandler Name="Json" Type="SmartSql.TypeHandler.JsonTypeHandler,SmartSql.TypeHandler"/>
    <TypeHandler Name="Xml" Type="SmartSql.TypeHandler.XmlTypeHandler,SmartSql.TypeHandler"/>
  </TypeHandlers>
  <SmartSqlMaps>
    <SmartSqlMap Path="Maps" Type="Directory"></SmartSqlMap>
    <!--<SmartSqlMap Path="Maps/T_Table.xml"></SmartSqlMap>-->
  </SmartSqlMaps>
</SmartSqlMapConfig>

1.2. Settings tag attribute

Attribute Description
IsWatchConfigFile Whether to monitor configuration files for configuration file hot updates, defaults to false
ParameterPrefix Global parameter prefix, defaults to $ for all DBs
IgnoreParameterCase Ignore parameter case
IsCacheEnabled Whether to enable caching

1.3. Database Subtag

Label Description
DbProvider DbProviderFactory implementation class for each Db Client

Write | Write Library (Required) | | Read | Read Library (optional) |

1.3.1. DbProvider Tags

Attribute Description
Name Name ID, DB environment recognition for Env tags
ParameterPrefix Parameter Prefix: [SqlServer:@ ; MySQL:? ; Oracle::]
Type Type

1.3.2. Write Tags

Attribute Description
Name Name Identification
ConnectionString Database Link String

1.3.3. Read Tags

Attribute Description
Name Name Identification
ConnectionString Database Link String
Weight Weight

1.4. TypeHandlers Subtag

1.4.1. TypeHandler tag

Attribute Description
Name Name Identification
Type Type

1.5. SmartSqlMaps Subtag

Label Description
SmartSqlMap Used to locate the location of SmartSqlMap files

1.5.1. SmartSqlMap tag

Attribute Description
Path Used to locate SmartSqlMap files/directories Location
Type Enumeration type: File/Directory, File: is a file resource; Directory: is a directory resource, take all Map files under this directory