Utilities.SqlBulkTools
1.0.5
dotnet add package Utilities.SqlBulkTools --version 1.0.5
NuGet\Install-Package Utilities.SqlBulkTools -Version 1.0.5
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="Utilities.SqlBulkTools" Version="1.0.5" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="Utilities.SqlBulkTools" Version="1.0.5" />
<PackageReference Include="Utilities.SqlBulkTools" />
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package.
paket add Utilities.SqlBulkTools --version 1.0.5
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: Utilities.SqlBulkTools, 1.0.5"
#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.
#:package Utilities.SqlBulkTools@1.0.5
#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package.
#addin nuget:?package=Utilities.SqlBulkTools&version=1.0.5
#tool nuget:?package=Utilities.SqlBulkTools&version=1.0.5
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
<html> <head> </head> <body>
This NuGet package provides efficient methods for performing bulk insert and update operations on SQL Server databases. It is designed to significantly improve performance compared to traditional row-by-row methods, especially when dealing with large datasets.
Key Features:
- Bulk Insert: Quickly and efficiently loads large amounts of data into SQL Server tables.
- Bulk Update: Updates multiple rows in a table based on specified criteria, optimizing performance.
- Customizable: Allows for configuration of options like batch size
- Performance-Optimized: Leverages SQL Server's bulk loading capabilities for maximum speed.
- Easy to Use: Simple API with clear methods and parameters.
Usage:
using SqlBulkTools;
// Initiate object of BulkOperations class
var bulkOperations = new BulkOperations(ConnectionString, "TableName");
// or ovedrride the default batch size tomake it faster for large datasets
var bulkOperations = new BulkOperations(ConnectionString, "TableName",100000);
// Perform a bulk insert
await bulkOperations.BulkInsertAsync(data)
// Perform a bulk update
await bulkOperations.BulkUpdateAsync(list)
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net6.0 is compatible. net6.0-android was computed. net6.0-ios was computed. net6.0-maccatalyst was computed. net6.0-macos was computed. net6.0-tvos was computed. net6.0-windows was computed. net7.0 was computed. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 was computed. 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. net9.0 was computed. net9.0-android was computed. net9.0-browser was computed. net9.0-ios was computed. net9.0-maccatalyst was computed. net9.0-macos was computed. net9.0-tvos was computed. net9.0-windows was computed. net10.0 was computed. net10.0-android was computed. net10.0-browser was computed. net10.0-ios was computed. net10.0-maccatalyst was computed. net10.0-macos was computed. net10.0-tvos was computed. net10.0-windows was computed. |
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.
-
net6.0
- Microsoft.Data.SqlClient (>= 5.2.2)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.