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); } } }
/// <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); }