using System.Collections.Generic;
using System.Data.SqlClient;
public int SupplierID {get;set;} public string SupplierName {get;set;} public Product Product {get;set;} public int ProductID {get;set;} public string ProductName {get;set;} public int SupplierID {get;set;} public static void Main()
List<Supplier> suppliers = new List<Supplier>();
using (var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServerW3Schools()))
suppliers.AddRange(connection.Query<Supplier, Product, Supplier>("Select TOP 1 A.SupplierID, A.SupplierName, B.ProductID, B.ProductName, B.SupplierID FROM Suppliers as A inner join Products as B on B.SupplierID =A.SupplierID where productID = 24",(supplier, product) => { supplier.Product = product; return supplier; },splitOn: "ProductID").ToList()); suppliers.ForEach(x => x.SupplierName = "ExampleSupplierBulkUpdate" );
suppliers.ForEach(x => x.Product.ProductName = "ExampleProductBulkUpdate" );
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);
using (var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServerW3Schools()))
FiddleHelper.WriteTable(connection.Query<Supplier>("Select TOP 10 * FROM Suppliers WHERE SupplierName = 'ExampleSupplierBulkUpdate'").ToList()); FiddleHelper.WriteTable(connection.Query<Product>("Select TOP 10 * FROM Products WHERE ProductName = 'ExampleProductBulkUpdate'").ToList()); FiddleHelper.WriteTable(connection.QueryFirstOrDefault("Select * FROM Suppliers WHERE SupplierName = 'ExampleSupplierBulkUpdate' order by SupplierID")); FiddleHelper.WriteTable(connection.QueryFirstOrDefault("Select * FROM Products WHERE ProductName = 'ExampleProductBulkUpdate' order by ProductID")); 
