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.