// @nuget: Microsoft.EntityFrameworkCore.SqlServer

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

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

​

using System;

using System.Collections.Generic;

using System.Linq;

using Z.EntityFramework.Plus;

using Microsoft.EntityFrameworkCore;

using Microsoft.Data.SqlClient;

​

public class Program

{

    public static void Main()

    {   

        ussding (var context = new EntityContext())

        {

            context.Database.EnsureCreated();

        }

        // ADD seed data here

        using (var context = new EntityContext())

        {

            context.Customers.Add(new Customer() { Name ="Customer_A", IsActive = false  });            

            context.SaveChanges();          

        }

        // ADD code to reproduce the issue here

        using (var context = new EntityContext())

        {

            // issue

            var customer = context.Customers.First();

            context.Orders.Add(new Order() { Description = "This should work", Customer = customer } );

            context.Orders.Add(new Order() { Description = "This should also work", Customer = customer } );

            context.Orders.Add(new Order() { Description = "This will fail since there is no customer" } );

            try

            {

                context.BulkSaveChanges();

                //context.SaveChanges();

            }

            catch (DbUpdateException ex)

            {

                // This is where we end up when using the traditional SaveChanges

                // However, even then the list of entries is not the correct one 

                // either it's the first, or sometimes it's all of them. Can't tell why

                var entries = ex.Entries.Select(e => ((Order)e.Entity).Description).ToArray();

                FiddleHelper.Dump(entries);

            }

            catch (SqlException ex)

            {

                // This is where we end up when using BulkSaveChanges

                FiddleHelper.Dump(ex);

            }

        }

    }

    public class EntityContext : DbContext

    {

        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)

        {

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

​

            base.OnConfiguring(optionsBuilder);

        }

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

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

    }

    public class Customer

    {

        public int CustomerID { get; set; }

        public string Name { get; set; }

        public Boolean IsActive { get; set; }

        public ICollection<Order> Orders {get; set;}

    }

    public class Order 

    {

        public int OrderID {get; set;}

        public string Description {get; set;}

        public int CustomerID {get; set;}

        public Customer Customer {get; set;}

    }

}