using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Threading.Tasks;
using Microsoft.Data.SqlClient;
public static async Task Main()
CreateDatabaseAndDataSeeding();
var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServer());
SELECT * FROM [Order] WHERE OrderID = @orderID;
SELECT * FROM [OrderItem] WHERE OrderID = @orderID;
using (var multi = await connection.QueryMultipleAsync(sql, new {orderID = 1}))
var order = multi.ReadFirst<Order>();
var orderItems = multi.Read<OrderItem>().ToList();
FiddleHelper.WriteTable("Order", new List<Order>() { order});
FiddleHelper.WriteTable("OrderItem", orderItems);
public static void CreateDatabaseAndDataSeeding()
var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServer());
var context = new DapperPlusContext(connection);
context.Entity<Customer>("KeepIdentity")
.UseBulkOptions(options => {
options.InsertKeepIdentity = true;
options.MergeKeepIdentity = true;
.Identity(x => x.CustomerID, true);
.Identity(x => x.OrderID, true);
context.Entity<OrderItem>()
.Identity(x => x.OrderItemID, true);
connection.CreateTable<Customer>();
connection.CreateTable<Order>();
connection.CreateTable<OrderItem>();
var customers = new List<Customer>();
customers.Add(new Customer() { CustomerID = 13, Name = "Jonathan Magnan", Orders = new List<Order>() {
new Order() { State = "New", Items = new List<OrderItem>() {
new OrderItem() { ProductName = "Dapper Plus", Quantity = 9 },
new OrderItem() { ProductName = "Entity Framework Extensions", Quantity = 19 }
customers.Add(new Customer() { CustomerID = 33, Name = "ZZZ Projects", Orders = new List<Order>() {
new Order() { State = "New", Items = new List<OrderItem>() {
new OrderItem() { ProductName = "C# Eval Expression", Quantity = 14 }
context.BulkMerge("KeepIdentity", customers)
.AlsoBulkInsert(customer => customer.Orders)
.AlsoBulkInsert(customer => customer.Orders.SelectMany(y => y.Items));
[DatabaseGenerated(DatabaseGeneratedOption.Identity)]
public int CustomerID { get; set; }
public string Name { get; set; }
public List<Order> Orders { get; set; }
[DatabaseGenerated(DatabaseGeneratedOption.Identity)]
public int OrderID { get; set; }
public int CustomerID { get; set; }
public string State { get; set; }
public List<OrderItem> Items { get; set; }
[DatabaseGenerated(DatabaseGeneratedOption.Identity)]
public int OrderItemID { get; set; }
public int OrderID { get; set; }
public string ProductName { get; set; }
public int Quantity { get; set; }