public void BulkInsert(IDbConnection dbConnection, DataTable dataTable, BulkOptions bulkOptions)
        {
            NpgsqlConnection connection = (NpgsqlConnection)dbConnection;

            using (NpgsqlBinaryImporter writer = connection.BeginBinaryImport(BuildCopyFromCommand(dataTable)))
            {
                foreach (DataRow dataRow in dataTable.Rows)
                {
                    writer.WriteRow(dataRow.ItemArray);
                }
            }
        }
示例#2
0
 /// <summary>
 /// Writes an entire row of columns.
 /// Equivalent to calling <see cref="StartRow"/>, followed by multiple <see cref="Write{T}(T)"/>
 /// on each value.
 /// </summary>
 /// <param name="values">An array of column values to be written as a single row</param>
 public void WriteRow(params object[] values)
 {
     _binaryImporter.WriteRow(values);
 }