0
Download ZZZ Projects Bulk Operations v4.0.7 + License Key (BulkInsert, BulkDelete, BulkUpdate, BulkMerge, and More)

Download ZZZ Projects Bulk Operations v4.0.7 + License Key (BulkInsert, BulkDelete, BulkUpdate, BulkMerge, and More)

Version: 4.0.7
Product Release Date: September 11, 2023
Download Zzz Projects Bulk Operations V4.0.7 + License Key (Bulkinsert, Bulkdelete, Bulkupdate, Bulkmerge, And More)
ZZZ Projects Bulk Operations helps you overcome SqlBulkCopy limitations by adding high-performance bulk operations: BulkInsert, BulkUpdate, BulkDelete, BulkMerge, and more. Overcome SqlBulkCopy limitations and use flexible features to output inserted identity and concurrency column values.
Add to your wishlist or like it:
0

ZZZ Projects Bulk Operations helps you in overcoming SqlBulkCopy limitations by adding high-performance bulk operations like BulkInsert, BulkUpdate, BulkDelete, BulkMerge, and more.

The BulkInsert and BulkInsertAync allow you insert a large number of entities in your database.

The options parameter allows you to customize the way entities are inserted.

If your entity has an identity property, you want to force it to insert a specific value instead. The InsertKeepIdentity option allows you to keep the identity value of your entity.

In ZZZ Projects Bulk Operations, by default, the BulkInsert method doesn’t return the identity when inserted.

You can return the identity by specifying it should be returned.

Zzz Projects Bulk Operations

In ZZZ Projects Bulk Operations, if you want to insert entities, only those that don’t exist in the database:

  • InsertIfNotExists: This option allows you to insert only an entity that doesn’t already exist.
  • AutoMapKeyExpression: This option allows you to customize the key with expression and keep the Auto Mapping.
  • PrimaryKeyExpression: This option lets you customize the key to check if the entity exists. This option disables Auto Mapping.
  • AutoMapKeyName: This option lets you customize the key by names and keep the Auto Mapping.

You want to insert your entities but only for specific properties:

  • ColumnInputExpression: This option allows you to choose which properties to map.
  • IgnoreOnInsertExpression: This option allows you to ignore properties that are auto-mapped.

ZZZ Projects Bulk Operations Features:

  • Output Identity Value – Overcome SqlBulkCopy limitations and use flexible features to output inserted identity and concurrency column values.
  • Insert, Update, Delete, Merge, and more… – Bulk Operations is not only about inserting, get more capability over SqlBulkCopy.
    • BulkInsert
    • BulkMerge (Upsert)
    • BulkSaveChanges
    • BulkUpdate
    • BulkDelete
    • BulkSynchronize
  • Generic List<> as DataSource – Improve code maintainability using a strongly-typed lambda expression over the hard-coded string.
    • Use Bulk Operations with Generic List<>
    • Use Bulk Operations with Expando Object
    • Use Lambda Expression for mapping.
  • Bulk Operations from LINQ Query – Perform bulk operations from LINQ Query without loading entities in memory.
    • DeleteFromQuery
    • UpdateFromQuery
  • AutoMap with Case Insensitive – Sick of not being able to map columns because of case sensitivity issues? Use flexible features to customize the configuration.
    • Auditing
    • Batch Size
    • Case Sensitivity
    • Logging