var srcTable = da.ExecuteDataTable(@"DECLARE @n INT; DECLARE @t TABLE(Name NVARCHAR(50),Age INT,Remark NVARCHAR(50))
                                    SET @n=1;WHILE (@n<=100)BEGIN INSERT INTO @t VALUES( N'中国人' + CONVERT(NVARCHAR(10),@n),@n+10,N'仅供测试'); SET @n=@n+1; END SELECT * FROM @t;");

                    var sqlParams = da.ParameterHelper.AddParameter("@Name", DbType.String, "Name", 50).AddParameter("@Age", DbType.Int32, "Age").AddParameter("@Remark", DbType.String, "Remark", 50).ToParameterArray();
                    BatchExecuteCommand("INSERT INTO dbo.T_TestPeople(Name,Age,Remark) VALUES(@Name,@Age,@Remark)", sqlParams, srcTable);




//我写的一个通用批量执行的方法
        public int BatchExecuteCommand(string sqlCmdText, object[] paramObjs, DataTable srcTable, int batchSize = 0)
        {
            var dbCmd = BuildDbCommand(sqlCmdText, CommandType.Text, paramObjs);
            dbCmd.UpdatedRowSource = System.Data.UpdateRowSource.None;
            var dbAdapter = dbProviderFactory.CreateDataAdapter();
            sqlCmdText = sqlCmdText.Trim();
            string bathExecType = System.Text.RegularExpressions.Regex.Match(sqlCmdText, @"^\w+\b").Value.ToUpper();

            switch (bathExecType)
            {
                case "INSERT":
                    {
                        dbAdapter.InsertCommand = dbCmd;
                        srcTable.Select().ToList().ForEach((r) => { r.SetAdded(); });
                        break;
                    }
                case "UPDATE":
                    {
                        dbAdapter.UpdateCommand = dbCmd;
                        srcTable.Select().ToList().ForEach((r) => { r.SetModified(); });
                        break;
                    }
                case "DELETE":
                    {
                        dbAdapter.DeleteCommand = dbCmd;
                        srcTable.Select().ToList().ForEach((r) => { r.Delete(); });
                        break;
                    }
                default:
                    {
                        throw new ArgumentException("无效的SQL命令！", "sqlCmdText");
                    }
            }

            dbAdapter.UpdateBatchSize = batchSize;
            int execResult = dbAdapter.Update(srcTable);
            ClearCommandParameters(dbCmd);
            return execResult;
        }