DB Extensions
Bulk Update
BulkUpdate updates multiple records in your database in a single, efficient operation. It matches rows based on one or more ID columns and updates the specified fields. Ideal for high-volume updates with minimal database round-trips.
Example
using System.Data.SqlClient;
using ETLBox.DbExtensions;
var connection = new SqlConnection("your-connection-string");
var customers = Enumerable.Range(1, 2_500)
.Select(i => new Customer {
Id = i,
Name = $"Updated {i}",
City = $"City {i % 25}"
});
connection.BulkUpdate(customers);
public class Customer {
[IdColumn]
public int Id { get; set; }
public string Name { get; set; }
public string City { get; set; }
}Method Signatures
IDbConnection BulkUpdate<T>(
this IDbConnection connection,
IEnumerable<T> data
)
IDbConnection BulkUpdate<T>(
this IDbConnection connection,
IEnumerable<T> data,
Action<BulkOptions<T>> options
)Customization Options
You can configure the operation using the optional BulkOptions<T> parameter:
var connection = new SqlConnection("your-connection-string");
var customers = Enumerable.Range(2_000, 4_500)
.Select(i => new Customer { Id = i, Name = $"Options update {i}", City = $"My City {i % 25}" });
connection.BulkUpdate(customers, options => {
options.BatchSize = 500;
options.IdColumns = new[] { new IdColumn() { IdPropertyName = "Id" }};
options.UpdateColumns = new[] { new UpdateColumn() { UpdatePropertyName = "Name" } };
options.BeforeBatchWrite = (batch) => {
Console.WriteLine($"Before batch with {batch.Length} rows.");
return batch;
};
});For a complete list of available options, see the BulkOptions reference.
IdColumns and UpdateColumns
To identify which rows should be updated, ETLBox uses the IdColumns. These must uniquely identify a row in your table.
By default, any property marked with [IdColumn] is used. You can override this manually in BulkOptions.
If you only want to update specific fields, define them with UpdateColumns.
connection.BulkUpdate(customers, options => {
options.IdColumns = new[] {
new IdColumn("Id")
};
options.UpdateColumns = new[] {
new UpdateColumn("Name"),
new UpdateColumn("City")
};
});If UpdateColumns are not set, all non-ID columns will be updated.
Table Naming Convention
By default, the table name is inferred from the class name. For example:
public class Customer { ... }This maps to either Customer or Customers.
You can override the name using TableName, or adjust it with TablePrefix and TableSuffix inside BulkOptions.
Example Code on GitHub
You can find both examples — basic usage and usage with options — in the official demo project on GitHub:
The demo is ready to run and shows how to configure the connection, create the table, and execute bulk operations with real data.