// Dapper Plus

// Doc: https://dapper-tutorial.net/query

// @nuget: Dapper -Version 1.60.6

using System;

using Microsoft.EntityFrameworkCore;

using System.Collections.Generic;

using System.Linq;

using System.Threading.Tasks;

​

public class Program

{

    public class MyDbContext : DbContext

    {

        public DbSet<Customer> Customer { get; set; }

​

        public DbSet<Order> Order { get; set; }

​

        public DbSet<OrderDetail> OrderDetail { get; set; }

​

        public DbSet<Product> Product { get; set; }

    }

​

    public class Customer

    {

        public int Id { get; set; }

​

        public string Name { get; set; }

​

        public List<Order> Orders { get; set; } = new List<Order>();

    }

​

    public class Order

    {

        public int CustomerId { get; set; }

​

        public DateTime Date { get; set; }

​

        public string State { get; set; }

​

        public List<OrderDetail> OrderDetails { get; set; } = new List<OrderDetail>();

    }

​

    public class OrderDetail

    {

        public int OrderId { get; set; }

​

        public Order Order { get; set; }

​

        public int ProductId { get; set; }

​

        public Product Product { get; set; }

​

        public int Quantity { get; set; }

    }

​

    public class Product

    {

        public int Id { get; set; }

​

        public string Name { get; set; }

​

        public decimal Price { get; set; }

    }

​

    public static async Task Main()

    {

        using (MyDbContext context = new MyDbContext())

        {

        // write querries here

        }

    }

}