static BulkCopyRowsCopied OracleMultipleRowsCopy3(MultipleRowsHelper helper, IEnumerable source) { helper.StringBuilder .AppendFormat("INSERT INTO {0}", helper.TableName).AppendLine() .Append("("); foreach (var column in helper.Columns) { helper.StringBuilder .AppendLine() .Append("\t") .Append(helper.SqlBuilder.Convert(column.ColumnName, ConvertType.NameToQueryField)) .Append(","); } helper.StringBuilder.Length--; helper.StringBuilder .AppendLine() .AppendLine(")") ; helper.SetHeader(); foreach (var item in source) { helper.StringBuilder .AppendLine() .Append("\tSELECT "); helper.BuildColumns(item, _ => _.DataType == DataType.Text || _.DataType == DataType.NText); helper.StringBuilder.Append(" FROM DUAL "); helper.StringBuilder.Append(" UNION ALL"); helper.RowsCopied.RowsCopied++; helper.CurrentCount++; if (helper.CurrentCount >= helper.BatchSize || helper.Parameters.Count > 10000 || helper.StringBuilder.Length > 100000) { helper.StringBuilder.Length -= " UNION ALL".Length; helper.StringBuilder .AppendLine() ; if (!helper.Execute()) { return(helper.RowsCopied); } } } if (helper.CurrentCount > 0) { helper.StringBuilder.Length -= " UNION ALL".Length; helper.StringBuilder .AppendLine() ; helper.Execute(); } return(helper.RowsCopied); }
protected override BulkCopyRowsCopied MultipleRowsCopy <T>( DataConnection dataConnection, BulkCopyOptions options, IEnumerable <T> source) { var helper = new MultipleRowsHelper <T>(dataConnection, options, false); helper.StringBuilder.AppendLine("INSERT ALL"); helper.SetHeader(); foreach (var item in source) { helper.StringBuilder.AppendFormat("\tINTO {0} (", helper.TableName); foreach (var column in helper.Columns) { helper.StringBuilder .Append(helper.SqlBuilder.Convert(column.ColumnName, ConvertType.NameToQueryField)) .Append(", "); } helper.StringBuilder.Length -= 2; helper.StringBuilder.Append(") VALUES ("); helper.BuildColumns(item); helper.StringBuilder.AppendLine(")"); helper.RowsCopied.RowsCopied++; helper.CurrentCount++; if (helper.CurrentCount >= helper.BatchSize || helper.Parameters.Count > 10000 || helper.StringBuilder.Length > 100000) { helper.StringBuilder.AppendLine("SELECT * FROM dual"); if (!helper.Execute()) { return(helper.RowsCopied); } } } if (helper.CurrentCount > 0) { helper.StringBuilder.AppendLine("SELECT * FROM dual"); helper.Execute(); } return(helper.RowsCopied); }