Z.BulkOperations Pro 2.10.1 Retail
Z.BulkOperations Pro 2.10.1 Retail | 351 Kb
Use scalable bulk operations (Bulk Insert, Update, Delete, and Merge) and always get the best performance available for your database provider.
SQL Server 2008+
SQL Azure
SQL Compact
MySQL
SQLite
PostgreSQL
Oracle (Coming soon)
Output Identity Value
Overcome SqlBulkCopy limitations and use flexible features to output inserted identity and concurrency column values.
var bulk = new BulkOperation(connection)
// Output newly inserted identity value after an insert
bulk.ColumnMappings.Add("CustomerID", ColumnMappingDirectionType.Output);
bulk.BulkInsert(dt);
Insert, Update, Delete, Merge and more...
Bulk Operations is not only about inserting, get more capability over SqlBulkCopy.
BulkInsert
BulkUpdate
BulkDelete
BulkMerge (Upsert)
BulkSaveChanges
BulkSynchronize
// Support all type of operations
var bulk = new BulkOperation(connection);
bulk.BulkInsert(dt);
bulk.BulkUpdate(dt);
bulk.BulkDelete(dt);
bulk.BulkMerge(dt);
bulk.BulkSaveChanges(ds);
bulk.BulkSynchronize(dt);
Generic List<> as DataSource
Improve code maintainability by using strongly-typed lambda expression over hard coded string.
Use Bulk Operations with Generic List<>
Use Bulk Operations with Expando Object
Use Lambda Expression for mapping
var bulk= new BulkOperation<Customer>(connection);
bulk.DestinationTableName = "Customer";
// Column Columns to Input
bulk.ColumnInputExpression = c => new { c.Code, c.Name };
// Choose Columns to Output
bulk.ColumnOutputExpression = c => c.CustomerID;
// Choose Key to Use
bulk.ColumnPrimaryKeyExpression = c => c.Code;
bulk.BulkMerge(customers);
Setup License
// using Z.BulkOperations; // Don't forget to include this.
string licenseName = //... PRO license name
string licenseKey = //... PRO license key
Z.BulkOperations.LicenseManager.AddLicense(licenseName, licenseKey);
[/b]
[b] Only for V.I.P
Warning! You are not allowed to view this text.