Dapper.Contrib.BulkInsert 0.1.13

.NET Core 3.1 This package targets .NET Core 3.1. The package is compatible with this framework or higher. 
dotnet add package Dapper.Contrib.BulkInsert --version 0.1.13                

                    
                

            
NuGet\Install-Package Dapper.Contrib.BulkInsert -Version 0.1.13
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="Dapper.Contrib.BulkInsert" Version="0.1.13" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
paket add Dapper.Contrib.BulkInsert --version 0.1.13                

                    
                

            
#r "nuget: Dapper.Contrib.BulkInsert, 0.1.13"
#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 Dapper.Contrib.BulkInsert as a Cake Addin
#addin nuget:?package=Dapper.Contrib.BulkInsert&version=0.1.13

// Install Dapper.Contrib.BulkInsert as a Cake Tool
#tool nuget:?package=Dapper.Contrib.BulkInsert&version=0.1.13

Dapper.Contrib.BulkInsert

Easy to use Dapper batch insert, support MySQL, SQLServer, ClickHouse and other instances of DbConnection

Demo

Entity

    [Table("TestUser")]
    public class TestUser
    {
        [Date]
        public DateTime ResisterDate { get; set; }
        [ClickHouseColumn(Name= "ResisterTime", IsOnlyIgnoreInsert =true)]
        public DateTime ResisterTime { get; set; }
        [ColumnName("Name")]
        public string Name { get; set; }
        public int Age { get; set; }
    }

InsertBulk

MySqlConnection conn = new MySqlConnection("server=127.0.0.1;Database=Demo;Uid=root;Pwd=root");
conn.Open();
conn.Execute("CREATE TABLE IF NOT EXISTS TestUser (ResisterDate Date, ResisterTime DateTime, Name varchar(200), Age int(11)) ENGINE=InnoDB");
var user = new TestUser() { ResisterDate = DateTime.Now, ResisterTime = DateTime.Now, Age = 18, Name = "Jack" };
var user2 = new TestUser() { ResisterDate = DateTime.Now, ResisterTime = DateTime.Now, Age = 18, Name = "Tom" };

var users = new List<TestUser>() { user, user2 };
conn.InsertBulk(users);

Dapper: https://github.com/StackExchange/Dapper

ClickHouse: https://github.com/yandex/ClickHouse

ClickHouse Ado.NET Driver: https://github.com/YahuiWong/ClickHouse.Client

Product Compatible and additional computed target framework versions.
.NET net5.0 was computed.  net5.0-windows was computed.  net6.0 was computed.  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. 
.NET Core netcoreapp3.1 is compatible. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (1)

Showing the top 1 NuGet packages that depend on Dapper.Contrib.BulkInsert:

Package Downloads
RaaLabs.Edge.Modules.Timescaledb

Package Description

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
0.1.13 20,357 7/13/2021
0.1.9 359 6/25/2021
0.1.7 333 6/10/2021
0.1.5 651 6/8/2021
0.1.0 2,176 5/15/2021