1. SmartSqlMap

1.1. ResultMap

    <ResultMap Id="UserExtendResultMap">
      <Result Column="Data" Property="Info" TypeHandler="Json"/>
    </ResultMap>

1.1.1. ResultMap.Result

1.2. ParameterMap

    <ParameterMap Id="UserExtendParameterMap">
      <Parameter Property="Info" TypeHandler="Json"/>
    </ParameterMap>

1.2.1. ParameterMap.Parameter

1.3. MultipleResultMap

    <MultipleResultMap Id="QueryByPage_Map">
      <Result Property="Total"/>
      <Result Property="List"/>
    </MultipleResultMap>

    Public class QueryByPageResponse
    {
        Public int Total { get; set; }
        Public IEnumerable<T_Entity> List { get; set; }
    }

1.3.1. MultipleResultMap.Result

1.4. Statement tag

Cache | Cache policy number, referenced from Cache tag | | CommandType | Text/StoredProcedure , Default:Text | SourceChoice | Unknow/Write/Read , Default:Unknow | ResultMap | ResultMap.Id for result mapping, list VS attribute name mapping, and field type processor processing | | ParameterMap | ParameterMap.Id | MultipleResultMap | MultipleResultMap.Id to return multiple result set mappings |

1.5. Statement Filter subtab

IsEmpty | null or empty string or empty IEnumerable | | IsEqual | Equal to comparison value | | IsFalse | The parameter is false | | IsGreaterEqual | Parameter is greater than or equal to comparison value | | IsGreaterThan | Parameter is greater than comparison value | | IsLessEqual | Parameter is less than or equal to comparison value | | IsLessThan | Parameter is less than comparison value | | IsNotEmpty | !(null or empty string or empty IEnumerable) | | IsNotEqual | Parameter is not equal to comparison value | | IsNotNull | Parameter is not equal to null | | IsNull | Parameters equal to null | | IsProperty | Query Object Contains Attribute Name | | IsTrue | The parameter is true | | Switch | Switch Tags | | Case | Sub-label of the Switch tag, equal to the comparison value | Defalut | Subtag of the Switch tag, hitting this tag when any Case subtag is missed |

1.6. Statement Other subtags

Dynamic | Dynamic tags for wrapping filter tags, the prefix of the first filtered tag matched will be ignored | | For | For parameters IEnumerable, traversal parameters dynamic splicing Sql | Where | Inherit to Dynamic for wrapping filter tags, matching the first filter tag prefix is ​​ignored, and adding the Where prefix | | Set | Inherit to Dynamic for Update, parcel filter tag, match the first filter tag prefix is ​​ignored, add the Set prefix, must match at least one subtag, otherwise a SmartSqlException will be thrown. | | Placeholder | Placeholder tag to replace parameter key values ​​|

1.7. Cache tag

Type | Cache type inherits from ICacheProvider, built-in constants: Lru least recently used algorithm, memory cache, Fifo FIFO algorithm, other inheritance from ICacheProvider cache type, for example: Type="SmartSql.Cache.Redis.RedisCacheProvider, SmartSql .Cache.Redis" |

1.7.1. Cache subtab

1.7.2. FlushInterval

1.7.3. FlushOnExecute

1.7.4. Parameter