BulkOpsHelper 1.0.0-beta2

This is a prerelease version of BulkOpsHelper.

There is a newer version of this package available.
See the version list below for details.

dotnet add package BulkOpsHelper --version 1.0.0-beta2

NuGet\Install-Package BulkOpsHelper -Version 1.0.0-beta2

This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.

<PackageReference Include="BulkOpsHelper" Version="1.0.0-beta2" />

For projects that support PackageReference, copy this XML node into the project file to reference the package.

paket add BulkOpsHelper --version 1.0.0-beta2

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

#r "nuget: BulkOpsHelper, 1.0.0-beta2"

#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.

// Install BulkOpsHelper as a Cake Addin
#addin nuget:?package=BulkOpsHelper&version=1.0.0-beta2&prerelease

// Install BulkOpsHelper as a Cake Tool
#tool nuget:?package=BulkOpsHelper&version=1.0.0-beta2&prerelease

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

BulkOpsHelper streamlines the creation of data validations for bulk insert and bulk update operations in SQL Server databases.

Quickstart:

Run "CreateBulkOpsInfrastructure.sql" (only once) against your existing Sql Server database.
Run the following stored procedure(s) as needed:

To build a bulk INSERT feature:
EXEC [ZZ_BulkOpsHelper].[ScaffoldAn_INSERT_Feature] @DomainSchemaName = 'YourSchemaNameDboForExample', @DomainTableName = 'YourTableNamePersonsForExample', @StagingSchemaName = 'ZZ_BulkOpsHelper'
To build a bulk UPDATE feature:
EXEC [ZZ_BulkOpsHelper].[ScaffoldAn_UPDATE_Feature] @DomainSchemaName = 'YourSchemaNameDboForExample', @DomainTableName = 'YourTableNamePersonsForExample', @StagingSchemaName = 'ZZ_BulkOpsHelper'
Notice row(s) added to the ZZ_BulkOpsHelper.BulkOpFeatures table.

In your .NET project, install and reference the BulkOpsHelper.

.NET CLI: "dotnet add package BulkOpsHelper"
OR via package manager: "NuGet\Install-Package BulkOpsHelper"

Call the BulkOpsHelper in your C# code: DataSet results = bulkOpsHelper.ExecuteFeatureGivenFilePath( featureId: 1, csvFilePath: "C:\Path\To\CsvFile.csv");

Please see Slapp Framework for more details.

More About the BulkOpsHelper: Imagine you need to implement custom CSV uploads in your .NET application. The target table has foreign keys, unique keys, and custom constraints. How can you thoroughly validate a given CSV file, including providing detailed field-level feedback to the end-user, without building all the validation logic? The answer is the BulkOpsHelper!

BulkOpsHelper analyzes your destination table to provide comprehensive validations, ensuring that the data aligns with the table's definition. The core philosophy is simple: if the rules for the data are already defined in the table, why duplicate them elsewhere? BulkOpsHelper functions like an ORM but with added support for bulk operations, making it ideal for both bulk and single-record processing.

Please see Slapp Framework for more details.

Product	Compatible and additional computed target framework versions.
.NET	net8.0 is compatible. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed.