Npgsql.Bulk
0.10.1
.NET Standard 2.0
.NET Framework 4.5
Install-Package Npgsql.Bulk -Version 0.10.1
dotnet add package Npgsql.Bulk --version 0.10.1
<PackageReference Include="Npgsql.Bulk" Version="0.10.1" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Npgsql.Bulk --version 0.10.1
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: Npgsql.Bulk, 0.10.1"
#r directive can be used in F# Interactive, C# scripting and .NET Interactive. Copy this into the interactive tool or source code of the script to reference the package.
// Install Npgsql.Bulk as a Cake Addin
#addin nuget:?package=Npgsql.Bulk&version=0.10.1
// Install Npgsql.Bulk as a Cake Tool
#tool nuget:?package=Npgsql.Bulk&version=0.10.1
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
Npgsql.Bulk
Helper for performing COPY (bulk insert and update) operation easily, using Entity Framework + Npgsql.
.Net 4.5, Standard 2.0 are supported.
var uploader = new NpgsqlBulkUploader(context);
var data = GetALotOfData();
// To create a lot of objects
uploader.Insert(data);
// To update a lot of objects
uploader.Update(data);
For .Net 4.5 BulkSelect operation is implemented which emulates join in-memory table to DB table. Here is the example:
// We need DbContext first
var context = GetContext();
// Obtained a collection of 50k transactions
var transactions = GetListOfTransction();
// Need to get prices from DB for all transactions, do it with 1 SQL call
var prices = context.Prices.BulkSelect(
x => new { x.Ticker, x.TradedOn }, // need to specify key for JOIN
transactions.Select(x => new { x.Ticker, x.TradedOn }) // obtain key data from local objects
);
// Done, prices variable now contains List<Price> which matches the JOIN DB table to in-memory collection
Available on NuGet:
Install-Package Npgsql.Bulk
Product | Versions |
---|---|
.NET | net5.0 net5.0-windows net6.0 net6.0-android net6.0-ios net6.0-maccatalyst net6.0-macos net6.0-tvos net6.0-windows |
.NET Core | netcoreapp2.0 netcoreapp2.1 netcoreapp2.2 netcoreapp3.0 netcoreapp3.1 |
.NET Standard | netstandard2.0 netstandard2.1 |
.NET Framework | net45 net451 net452 net46 net461 net462 net463 net47 net471 net472 net48 |
.NETCore | netcore60 |
MonoAndroid | monoandroid |
MonoMac | monomac |
MonoTouch | monotouch |
Tizen | tizen40 tizen60 |
Universal Windows Platform | netcore50 |
Xamarin.iOS | xamarinios |
Xamarin.Mac | xamarinmac |
Xamarin.TVOS | xamarintvos |
Xamarin.WatchOS | xamarinwatchos |
Compatible target framework(s)
Additional computed target framework(s)
Learn more about Target Frameworks and .NET Standard.
-
.NETCore 6.0
- Npgsql.EntityFrameworkCore.PostgreSQL (>= 6.0.0)
- System.Reflection.Emit (>= 4.7.0)
-
.NETFramework 4.5
- EntityFramework6.Npgsql (>= 3.1.1)
- Npgsql (>= 4.0.0)
-
.NETStandard 2.0
- Npgsql.EntityFrameworkCore.PostgreSQL (>= 3.1.0)
- System.Reflection.Emit (>= 4.7.0)
NuGet packages (3)
Showing the top 3 NuGet packages that depend on Npgsql.Bulk:
Package | Downloads |
---|---|
Hikari
C#数据库连接池,管理多数据库连接 |
|
BlueBitSoft.BlueUtility
Package Description |
|
IIMes.Kernel
Package Description |
GitHub repositories
This package is not used by any popular GitHub repositories.
Version | Downloads | Last updated |
---|---|---|
0.10.1 | 23,878 | 12/10/2021 |
0.10.0 | 380 | 12/10/2021 |
0.9.0 | 302,279 | 11/19/2020 |
0.8.4 | 17,662 | 11/6/2020 |
0.8.3.1 | 907 | 11/2/2020 |
0.8.3 | 447 | 10/30/2020 |
0.8.2 | 28,295 | 9/3/2020 |
0.8.1.1 | 93,791 | 4/18/2020 |
0.8.1 | 393 | 4/18/2020 |
0.8.0 | 29,061 | 1/18/2020 |
0.8.0-beta | 319 | 1/5/2020 |
0.7.7.1 | 38,270 | 11/23/2019 |
0.7.7 | 9,269 | 11/14/2019 |
0.7.6.1 | 8,072 | 10/11/2019 |
0.7.6 | 2,267 | 10/6/2019 |
0.7.5 | 27,198 | 9/29/2019 |
0.7.4 | 3,803 | 7/20/2019 |
0.7.3 | 359 | 7/20/2019 |
0.7.2 | 6,715 | 6/25/2019 |
0.7.1 | 3,732 | 6/14/2019 |
0.7.0 | 5,568 | 5/19/2019 |
0.6.9 | 6,244 | 4/25/2019 |
0.6.8 | 3,877 | 4/3/2019 |
0.6.7 | 422 | 4/2/2019 |
0.6.6 | 1,820 | 3/22/2019 |
0.6.5 | 397 | 3/20/2019 |
0.6.4 | 1,265 | 3/2/2019 |
0.6.3 | 574 | 2/12/2019 |
0.6.2 | 11,196 | 11/1/2018 |
0.6.1 | 6,077 | 9/14/2018 |
0.6.0 | 625 | 9/13/2018 |
0.5.21 | 1,179 | 9/13/2018 |
0.5.20 | 898 | 8/23/2018 |
0.5.19 | 603 | 8/22/2018 |
0.5.18 | 612 | 8/21/2018 |
0.5.17 | 712 | 7/23/2018 |
0.5.16 | 965 | 5/23/2018 |
0.5.15 | 865 | 5/16/2018 |
0.5.14 | 778 | 5/1/2018 |
0.5.13 | 948 | 2/23/2018 |
0.5.12 | 823 | 1/10/2018 |
0.5.11 | 813 | 1/9/2018 |
0.5.10 | 808 | 12/26/2017 |
0.5.9 | 792 | 12/25/2017 |
0.5.8 | 946 | 12/11/2017 |
0.5.7 | 873 | 12/10/2017 |
0.5.6 | 746 | 11/16/2017 |
0.5.5 | 758 | 11/1/2017 |
0.5.4 | 725 | 10/25/2017 |
0.5.2 | 759 | 10/17/2017 |
Fix for generators