// Entity Framework Extensions

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

​

// @nuget: Microsoft.EntityFrameworkCore.SqlServer -Version 7.0.20

// @nuget: Z.EntityFramework.Extensions.EFCore -Version 7.103.8.1-beta1

​

using System;

using System.Collections.Generic;

using System.Linq;

using Microsoft.Data.SqlClient;

using Microsoft.EntityFrameworkCore;

​

public class Program

{

    public static void Main()

    {

        using (var context = new EntityContext())

        {

            context.Database.EnsureCreated();

        }

        var stores = new List<Post>()

        {

            new Post() { Content = "Store_A", Location = new Location() { Address = "Address_A" } },

            new Post() { Content = "Store_B", Location = new Location() { Address = "Address_B" } },

        };      

        using (var context = new EntityContext())

        {

            var referenceEquality = new ReferenceEqualityComparer<object>();

            context.BulkInsert(stores, options => {         

                options.IncludeGraph = true;

                options.UnsafeMode = true;

                options.DictionaryEqualityComparer = referenceEquality;

            });

            FiddleHelper.WriteTable("Locations", context.Locations.AsNoTracking());

            FiddleHelper.WriteTable("Posts", context.Posts.Include(x => x.Location).AsNoTracking());

        }

    }

    public class EntityContext : DbContext

    {

        public EntityContext() 

        {

        }

​

        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)

        {

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

​

            base.OnConfiguring(optionsBuilder);

        }

        public DbSet<Location> Locations { get; set; }

        public DbSet<Post> Posts { get; set; }

    }

​

    public class Location

    {

        public int LocationID { get; set; }

        public string Address { get; set; }

        public List<Post> Posts { get; set; }

        public override bool Equals(object other)

        {

            return other != null &&

               LocationID == (other as Location).LocationID &&

               Address == (other as Location).Address;

        }

​

        public override int GetHashCode()

        {

            return HashCode.Combine(LocationID, Address);

        }

    }

    public class Post

    {

        public int Id  { get; set; }

        public string Content  { get; set; }

        public Location Location  { get; set; }

    }   

    public sealed class ReferenceEqualityComparer<T> : IEqualityComparer<T> where T : class

    {

            private static readonly ReferenceEqualityComparer<T> _instance = new ReferenceEqualityComparer<T>();

​

            public static ReferenceEqualityComparer<T> Instance => Instance;

​

            /// <inheritdoc /> 

            public bool Equals(T left, T right) => Object.ReferenceEquals(left, right);

​

            /// <inheritdoc /> 

            public int GetHashCode(T value)

            {

                   return System.Runtime.CompilerServices.RuntimeHelpers.GetHashCode(value);

            }

    }

​

}