// Dapper Plus

// Doc: https://dapper-plus.net/identity-key-propagation

​

// @nuget: Dapper

// @nuget: Microsoft.Data.SqlClient

// @nuget: Z.Dapper.Plus

​

using System.Collections.Generic;

using System.ComponentModel.DataAnnotations;

using System.ComponentModel.DataAnnotations.Schema;

using System.Linq;

using Microsoft.Data.SqlClient;

using Dapper;

using Z.Dapper.Plus;

​

public class Program

{   

    public static void Main()

    {

        // Map your entity

        DapperPlusManager.Entity<Order>().Identity(x => x.OrderID);

        DapperPlusManager.Entity<OrderItem>().Identity(x => x.OrderItemID);

        var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServer());

        connection.CreateTable<Order>();

        connection.CreateTable<OrderItem>();

​

        // Get new orders

        var newOrders = GetNewOrders();

        // Save orders

        connection.BulkInsert(newOrders)

            .ThenForEach(x => x.Items?.ForEach(y => y.OrderID = x.OrderID))

            .ThenBulkInsert(x => x.Items);

        FiddleHelper.WriteTable("1 - Orders", connection.Query<Order>("SELECT * FROM [Order]"));

        FiddleHelper.WriteTable("2 - OrderItems", connection.Query<OrderItem>("SELECT * FROM [OrderItem]"));

    }

    public static List<Order> GetNewOrders()

    {

        var orders = new List<Order>();

        // order #1

        orders.Add(new Order() { State = "New", Items = new List<OrderItem>() {

                new OrderItem() { ProductName = "Dapper Plus", Quantity = 9 },

                new OrderItem() { ProductName = "C# Eval Expression", Quantity = 14 }   

            }

        });

        // order #2

        orders.Add(new Order() { State = "New", Items = new List<OrderItem>() {

                new OrderItem() { ProductName = "Entity Framework Extensions", Quantity = 19 }  

            }

        });

        return orders;

    }

    [Table("Order")]

    public class Order

    {

        [Key]

        [DatabaseGenerated(DatabaseGeneratedOption.Identity)]

        public int OrderID { get; set; }

        public string State { get; set; }   

        public List<OrderItem> Items { get; set; }

    }

    [Table("OrderItem")]

    public class OrderItem

    {

        [Key]

        [DatabaseGenerated(DatabaseGeneratedOption.Identity)]

        public int OrderItemID { get; set; }

        public int OrderID { get; set; }

        public string ProductName { get; set; }

        public int Quantity { get; set; }

    }

}