batch insert

[54Ezreal]

请问批量添加功能如何实现呢，我参照文档的 这样子的写法，这样子会有异常抛出，提示For 的Key 键不能为空！

INSERT INTO T_Test
(Name,Status)
VALUES

(@name,@Status)


我觉得批量添加在开发中还是会经常用到，比方说做Excel导入时，订单项添加时，都会用到批量添加，希望作者能够写一些示例。我查阅了SmartSqlStarter项目，内容较少也没有涉及到批量操作的功能。
Thanks

[Ahoo-Wang]

@HuUncle

    <Statement Id="InsertBatch">
      INSERT INTO T_Entity
      (FString
      ,FDecimal
      ,FNullDecimal
      ,FBool
      ,FNullBool
      ,Status
      ,NullStatus
      ,CreationTime
      ,LastUpdateTime)
      VALUES
      <For Open="" Close="" Key="T" Property="Items" Separator=",">
        (@FString
        ,@FDecimal
        ,@FNullDecimal
        ,@FBool
        ,@FNullBool
        ,@Status
        ,@NullStatus
        ,@CreationTime
        ,@LastUpdateTime)
      </For>
    </Statement>

            var items = new List<T_Entity> {
                new T_Entity
                {
                    CreationTime = DateTime.Now,
                    FBool = true,
                    FDecimal = 1,
                    FLong = 1,
                    FNullBool = false,
                    FString = Guid.NewGuid().ToString("N"),
                    FNullDecimal = 1.1M,
                    LastUpdateTime = DateTime.Now,
                    Status = EntityStatus.Ok
                },new T_Entity
                {
                    CreationTime = DateTime.Now,
                    FBool = true,
                    FDecimal = 1,
                    FLong = 1,
                    FNullBool = false,
                    FString = Guid.NewGuid().ToString("N"),
                    FNullDecimal = 1.1M,
                    LastUpdateTime = DateTime.Now,
                    Status = EntityStatus.Ok
                }
            };
            _sqlMapper.Execute(new RequestContext
            {
                Scope = Scope,
                SqlId = "InsertBatch",
                Request = new { Items = items }
            });

[ghd258]

方法不错