Dapper Plus - Bulk Update

最新推荐文章于 2024-05-24 09:51:20 发布

lion_6

最新推荐文章于 2024-05-24 09:51:20 发布

阅读量515

点赞数

分类专栏： database

本文链接：https://blog.csdn.net/lion_6/article/details/102975828

版权

database 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

Dapper Plus - Bulk Update

Description

UPDATE entities using Bulk Operation.

Example - Update Single

UPDATE a single entity with Bulk Operation.

DapperPlusManager.Entity<Customer>().Table("Customers"); 

using (var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServerW3Schools()))
{
    connection.BulkUpdate(customers);
}

Try it online

Example - Update Many

UPDATE many entities with Bulk Operation.

DapperPlusManager.Entity<Customer>().Table("Customers");

using (var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServerW3Schools()))
{
    connection.BulkUpdate(customers);
}

Try it online

Example - Update with relation (One to One)

UPDATE entities with a one to one relation with Bulk Operation.

DapperPlusManager.Entity<Supplier>().Table("Suppliers").Identity(x => x.SupplierID);
DapperPlusManager.Entity<Product>().Table("Products").Identity(x => x.ProductID);

using (var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServerW3Schools()))
{	
    connection.BulkUpdate(suppliers, x => x.Product);
}

Try it online

Example - Update with relation (One to Many)

UPDATE entities with a one to many relation with Bulk Operation.

DapperPlusManager.Entity<Supplier>().Table("Suppliers").Identity(x => x.SupplierID);
DapperPlusManager.Entity<Product>().Table("Products").Identity(x => x.ProductID);

using (var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServerW3Schools()))
{
    connection.BulkUpdate(suppliers, x => x.Products);
}

Try it online