// Entity Framework Extensions

// Doc: https://entityframework-extensions.net/bulk-insert

​

// @nuget: Microsoft.EntityFrameworkCore.SqlServer

// @nuget: Z.EntityFramework.Extensions.EFCore

​

using Microsoft.EntityFrameworkCore;

using System.Collections.Generic;

using Microsoft.Data.SqlClient;

using System.ComponentModel.DataAnnotations;

using System.ComponentModel.DataAnnotations.Schema;

​

public class Program

{

    public static void Main()

    {

        using (var context = new EntityContext())

        {

            context.Database.EnsureCreated();

        }

        var parents = new ParentData(){

            Name = "Test123",

            Children = new List<ChildData>(){

                new ChildData(){

                 Name = "Test123_jr"    

                },

                new ChildData(){

                 Name = "Test124_jr"    

                }

            }

        };

        using (var context = new EntityContext())

        {

            context.BulkInsert(new List<ParentData>() { parents }, options => options.IncludeGraph = true);

            FiddleHelper.WriteTable("1 - Invoices", context.Parents);

            FiddleHelper.WriteTable("2 - InvoiceItems", context.Children);

        }   

    }

​

​

    public class EntityContext : DbContext

    {

        public EntityContext() 

        {

        }

​

        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)

        {

            optionsBuilder.UseSqlServer(new SqlConnection(FiddleHelper.GetConnectionStringSqlServer()));

​

            base.OnConfiguring(optionsBuilder);

        }

        public DbSet<ParentData> Parents { get; set; }

        public DbSet<ChildData> Children { get; set; }

    }

​

    public class ParentData

    {

        [Key(), Column("parent_id")]

        public int ParentId { get; set; }

        [Column("parent_name")]

        public string Name { get; set; }

        public List<ChildData> Children { get; set; }

    }

    public class ChildData

    {

        [Key(), Column("child_id")]

        public int ChildId { get; set; }

        [Column("parent_id")]

        public int ParentId { get; set; }

        [Column("child_name")]

        public string Name { get; set; }

        public ParentData Parent { get; set; }

    }

}