# SmartSqlMapConfig

# Demo

<?xml version="1.0" encoding="utf-8" ?>
<SmartSqlMapConfig xmlns="http://SmartSql.net/schemas/SmartSqlMapConfig.xsd">
  <Settings/>
  <Database>
    <DbProvider Name="SqlServer"/>
    <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"/>
  </TypeHandlers>
  <SmartSqlMaps>
    <SmartSqlMap Path="Maps" Type="Directory"></SmartSqlMap>
  </SmartSqlMaps>
</SmartSqlMapConfig>

# Settings Label Attribute

Attribute Note
ParameterPrefix Global parameter prefix, using the default to fit all DB
IgnoreParameterCase Ignore parameter case
IsCacheEnabled Whether to turn on caching

# Database Child elements

element Note
DbProvider DbProviderFactory implementation classes for each Db Client
Write Write Library (required)
Read Read library (optional)

# DbProvider element

Attribute Note
Name Name identification, DB environment identification available for Env tags
ParameterPrefix Parameter prefix:[SqlServer:@ ; MySQL:? ; Oracle::]
Type Type

# Write element

Attribute Note
Name Name identification
ConnectionString Database Connection string

# Read element

Attribute Note
Name Name identification
ConnectionString Database Connection string
Weight Weight

# TypeHandlers

# TypeHandler element

Attribute Note
Name Name identification
Type Type

# SmartSqlMaps child element

element Note
SmartSqlMap Used to locate SmartSqlMap file locations

# SmartSqlMap element

Attribute Note
Path Used to locate SmartSqlMap File/directory location
Type Enumeration type: File/Directory,File: for file resources; directory: for directory resources, take all MAP files under that directory