ObjectBulkCopy 0.2.0
dotnet add package ObjectBulkCopy --version 0.2.0
NuGet\Install-Package ObjectBulkCopy -Version 0.2.0
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="ObjectBulkCopy" Version="0.2.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="ObjectBulkCopy" Version="0.2.0" />
<PackageReference Include="ObjectBulkCopy" />
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 ObjectBulkCopy --version 0.2.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: ObjectBulkCopy, 0.2.0"
#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 ObjectBulkCopy@0.2.0
#: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=ObjectBulkCopy&version=0.2.0
#tool nuget:?package=ObjectBulkCopy&version=0.2.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
ObjectBulkCopy
A super simple C# library for performing SqlBulkCopy directly on your CLR objects. No need to manually map properties--just plug in your list of objects and copy them to SQL Server with minimal setup. Ideal for high-performance data inserts in .NET applications.
Support Platform
- .NET 8.0+
How to use
using System.ComponentModel.DataAnnotations.Schema;
[Table("Users")] // must set table name
public class User
{
[Column("Id", Order = 0)] // must set zero-based order
public required int Id { get; init; }
[Column("Name", Order = 1)]
public required string Name { get; init; }
}
using ObjectBulkCopy;
using (var connection = new SqlConnection(...))
{
User[] records
= [
new(){ Id = 0, Name = "xin9le" },
new(){ Id = 1, Name = "Takaaki Suzuki" },
];
const SqlBulkCopyOptions options = SqlBulkCopyOptions.Default;
int? timeout = null;
var affectedCount = await connection.BulkInsertAsync(records, options, timeout, cancellationToken);
}
Installation
Getting started from downloading NuGet package.
dotnet add package ObjectBulkCopy
License
This library is provided under MIT License.
Author
Takaaki Suzuki (a.k.a @xin9le) is software developer in Japan who awarded Microsoft MVP for Developer Technologies (C#) since July 2012.
| Product | Versions 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. net9.0 is compatible. 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 is compatible. 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.
-
net10.0
- Microsoft.Data.SqlClient (>= 6.1.3)
-
net8.0
- Microsoft.Data.SqlClient (>= 6.1.3)
-
net9.0
- Microsoft.Data.SqlClient (>= 6.1.3)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.