SqlBulkHelpers 1.0.5

A library for efficient and high performance bulk insert and update of data, into a Sql Database, from C# applications by leveraging the power of the C# SqlBulkCopy classes with added support for Identity primary key table columns.  Offerring compabitility with .NetStandard 2.0 to support .Net Core 2.0+ & .Net Framework 4.7.2+.

There is a newer version of this package available.
See the version list below for details.
Install-Package SqlBulkHelpers -Version 1.0.5
dotnet add package SqlBulkHelpers --version 1.0.5
<PackageReference Include="SqlBulkHelpers" Version="1.0.5" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add SqlBulkHelpers --version 1.0.5
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: SqlBulkHelpers, 1.0.5"
For F# scripts that support #r syntax, copy this into the source code to reference the package.

Release Notes

- Added support for custom match qualifiers to be specified even if bulk inserting/updating data with Identity columns.  This addresses some edge use cases whereby data syncing may be taking place and Identities are used to differentiate data from multiple sources, but the actual merge matches needs to occur on unique fields of the source system.
- Simplified initialization and constructors to provide easier use -- especially if SqlConnection/SqlTransaction already exists and ConnectionString is not available.  It's still recommended to use ISqlBulkHelpersConnectionProvider however, this may not be congruent with existin code bases so now the use of existing Sql Connection & Transaction is encapsulated.
- Provided in-memory cache implementation to help manage caching of Schema DB Loaders for performance.
- Improved pattern for Schema DB Loader management and encourage use of new Caching class; previously its possible that this was being re-loaded multiple times unnecessarily due to relying on internal behavior instead of managing it as a static/singleton.
- Added more Integration Tests for Constructors and Connections, as well as the new DB Schema Loader caching implementation.

Prior Relese Notes:
Fixed bug in dynamic initialization of SqlBulkHelpersConnectionProvider and SqlBulkHelpersDBSchemaLoader when not using the Default instances that automtically load the connection string from the application configuration setting.

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version History

Version Downloads Last updated 74 12/10/2020 69 12/10/2020
1.0.6 71 12/9/2020
1.0.5 121 12/9/2020
1.0.4 312 11/1/2019
1.0.2 160 10/29/2019