"The given ColumnMapping does not match up with any column in the source or destination" - When using GetDataTable<T> about efcore.bulkextensions HOT 16 CLOSED

[Column("CostingAllocationDetailAmountID")]
public int CostingAllocationDetailAmountId { get; set; }

    [JsonConverter(typeof(CentraStageDeviceBaseConverter))]
    public abstract class CentraStageDeviceBase : Entity<long>
    {
        public bool A64Bit { get; set; }
        public string CagVersion { get; set; }

        [JsonConverter(typeof(EpochConverter))]
        public DateTime CreationDate { get; set; }

        public bool Deleted { get; set; }
        public string Description { get; set; }
        public string DeviceClass { get; set; }

        [JsonIgnore]
        public CentraStageDeviceType DeviceType { get; set; } = new CentraStageDeviceType();

        [JsonIgnore]
        public string Category { get;set; }

        [JsonIgnore]
        public string Type {get; set; }

        public string DisplayVersion { get; set; }
        public string Domain { get; set; }
        public string ExtIpAddress { get; set; }
        public string Hostname { get; set; }
        public string IntIpAddress { get; set; }

        [JsonConverter(typeof(EpochConverter))]
        public DateTime? LastAuditDate { get; set; }

        public string LastLoggedInUser { get; set; }

        [JsonConverter(typeof(EpochConverter))]
        public DateTime? LastReboot { get; set; }

        [JsonConverter(typeof(EpochConverter))]
        public DateTime? LastSeen { get; set; }

        public bool Online { get; set; }
        public string OperatingSystem { get; set; }
        public string PortalUrl { get; set; }
        public bool RebootRequired { get; set; }
        public virtual CentraStageSite Site { get; set; }
        public int SiteId { get; set; }
        public string SiteName { get; set; }
        public string SiteUid { get; set; }
        public bool SnmpEnabled { get; set; }
        public bool Suspended { get; set; }
        public CentraStageDeviceUdf Udf { get; set; }
        public string Uid { get; set; }
    }

    [JsonConverter(typeof(CentraStageDeviceBaseConverter))]
    public class CentraStageDevice : CentraStageDeviceBase
    {
        public virtual ICollection<CentraStageDeviceLogicalDisk> LogicalDisks { get; set; }
        public virtual ICollection<CentraStageDeviceSoftware> Software { get; set; }
        public virtual CentraStageDeviceSystemInfo SystemInfo { get; set; }

        // some methods
    }

SELECT [Id]
      ,[A64Bit]
      ,[CagVersion]
      ,[CreationDate]
      ,[Deleted]
      ,[Description]
      ,[DeviceClass]
      ,[DisplayVersion]
      ,[Domain]
      ,[ExtIpAddress]
      ,[Hostname]
      ,[IntIpAddress]
      ,[LastAuditDate]
      ,[LastLoggedInUser]
      ,[LastReboot]
      ,[LastSeen]
      ,[Online]
      ,[OperatingSystem]
      ,[PortalUrl]
      ,[RebootRequired]
      ,[SiteId]
      ,[SiteName]
      ,[SiteUid]
      ,[SnmpEnabled]
      ,[Suspended]
      ,[Uid]
      ,[Category]
      ,[Type]
      ,[Udf_Udf1]
      ,[Udf_Udf10]
      ,[Udf_Udf2]
      ,[Udf_Udf3]
      ,[Udf_Udf4]
      ,[Udf_Udf5]
      ,[Udf_Udf6]
      ,[Udf_Udf7]
      ,[Udf_Udf8]
      ,[Udf_Udf9]
  FROM [PortalCore].[dbo].[CentraStageDevices]

    public class CentraStageDeviceBaseConfiguration : IEntityTypeConfiguration<CentraStageDeviceBase>
    {
        public void Configure(EntityTypeBuilder<CentraStageDeviceBase> builder)
        {
            builder
                .Ignore(p => p.DeviceType);

            builder
                .OwnsOne(p => p.Udf);

            builder
                .ToTable("CentraStageDevices")
                .HasDiscriminator<string>("DeviceClass")
                .HasValue<CentraStageDevice>("device")
                .HasValue<CentraStageEsxiHost>("esxihost")
                .HasValue<CentraStagePrinter>("printer");
        }
    }

    public class CentraStageDeviceConfiguration : IEntityTypeConfiguration<CentraStageDevice>
    {
        public void Configure(EntityTypeBuilder<CentraStageDevice> builder)
        {
            builder
                .Property(p => p.Id)
                .ValueGeneratedNever();

            builder
                .HasBaseType<CentraStageDeviceBase>();

            builder
                .HasMany(p => p.Software)
                .WithOne(c => c.Device)
                .HasForeignKey(c => c.DeviceId);

            builder
                .HasMany(p => p.LogicalDisks)
                .WithOne(c => c.Device)
                .HasForeignKey(c => c.DeviceId);

            builder
                .HasOne(p => p.SystemInfo)
                .WithOne(c => c.Device)
                .HasForeignKey<CentraStageDeviceSystemInfo>(c => c.DeviceId);

            builder
                .HasIndex(p => p.Uid);
        }
    }

public class TestContext : DbContext
{
    // ...
    
    public DbSet<CentraStageDevice> CentraStageDevices { get; set; }
    public DbSet<CentraStageDeviceLogicalDisk> CentraStageDeviceLogicalDisks { get; set; }
    public DbSet<CentraStageDeviceSystemInfo> CentraStageDeviceSystemInfos { get; set; }
    public DbSet<CentraStageDeviceType> CentraStageDeviceTypes { get; set; }
    public DbSet<CentraStageSite> CentraStageSites { get; set; }
    
    protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
        // ...
        
        modelBuilder.Entity<CentraStageDevice>()
            .ToTable("CentraStageDevice")
            .HasDiscriminator<string>("DeviceClass")
            .HasValue<CentraStageDevice>("device");

        modelBuilder.Entity<CentraStageDevice>().HasMany(p => p.LogicalDisks)
            .WithOne(c => c.Device)
            .HasForeignKey(c => c.DeviceId);

        modelBuilder.Entity<CentraStageDevice>()
            .HasOne(p => p.SystemInfo)
            .WithOne(c => c.Device)
            .HasForeignKey<CentraStageDeviceSystemInfo>(c => c.DeviceId);

        modelBuilder.Entity<CentraStageDevice>()
            .HasIndex(p => p.Uid);
    }
}

public class CentraStageDeviceLogicalDisk
{
    public int Id { get; set; }
    public string LogicalDisk { get; set; }

    public CentraStageDevice Device { get; set; }
    public long DeviceId { get; set; }
}

public class CentraStageDeviceSystemInfo
{
    public int Id { get; set; }
    public string SystemInfo { get; set; }

    public CentraStageDevice Device { get; set; }
    public long DeviceId { get; set; }
}

public class CentraStageDeviceType
{
    public int Id { get; set; }
    public string DeviceType { get; set; }
}

public class CentraStageSite
{
    public int Id { get; set; }
    public string Site { get; set; }
}

[Owned]
public class CentraStageDeviceUdf
{
    public string Udf1 { get; set; }
    public string Udf2 { get; set; }
}

public class CentraStageDevice : CentraStageDeviceBase
{
    public virtual ICollection<CentraStageDeviceLogicalDisk> LogicalDisks { get; set; }
    public virtual CentraStageDeviceSystemInfo SystemInfo { get; set; }
}

/*public abstract class Entity<T>
{
    [DatabaseGenerated(DatabaseGeneratedOption.None)]
    public T Id { get; set; }
}*/

public abstract class CentraStageDeviceBase// : Entity<long>
//public class CentraStageDevice
{
    [DatabaseGenerated(DatabaseGeneratedOption.None)]
    public long Id { get; set; }

    public bool A64Bit { get; set; }
    public string CagVersion { get; set; }

    public string DeviceClass { get; set; }

    [NotMapped]
    public CentraStageDeviceType DeviceType { get; set; } = new CentraStageDeviceType();

    public virtual CentraStageSite Site { get; set; }
    public int? SiteId { get; set; }

    public CentraStageDeviceUdf Udf { get; set; }

    public string Uid { get; set; }
    
    // Added here temporary for DB creation
    //public virtual ICollection<CentraStageDeviceLogicalDisk> LogicalDisks { get; set; }
    //public virtual CentraStageDeviceSystemInfo SystemInfo { get; set; }
}

public void OperationsTest(bool isBulkOperation)
{
    //...
    using (var context = new TestContext(ContextUtil.GetOptions()))
    {
        var entities = new List<CentraStageDevice>();
        for (int i = 1; i < EntitiesNumber; i++)
        {
            var entity = new CentraStageDevice
            {
                Id = i,
                A64Bit = true,
                DeviceClass = "DC1"
                Udf = new CentraStageDeviceUdf(),

            };
            entities.Add(entity);
        }
        context.BulkInsert(entities);
    }
}

    public class CostingAllocationDetailAmount
    {
        [Key]
        public int CostingAllocationDetailAmountId { get; set; }
        public int CostingAllocationDetailId { get; set; }
        public DateTime DistributedWorkPeriodStartDate { get; set; }
        public DateTime DistributedWorkPeriodEndDate { get; set; }
        public decimal Pay { get; set; }
        public decimal Longevity { get; set; }
        public decimal BenefitsEarningsWithLongevity { get; set; }
        public decimal Retirement { get; set; }
        public decimal PreTaxEarnings { get; set; }
        public decimal GIPAmount { get; set; }
        public decimal OASIAmount { get; set; }
        public decimal OAHIAmount { get; set; }
        public decimal WCIAmount { get; set; }
        public decimal UCIAmount { get; set; }
        public decimal ACAPTaxAmount { get; set; }
        public decimal MeritAmount { get; set; }
        public decimal PromotionAmount { get; set; }
        public decimal AdditionalAdjustmentAmount { get; set; }
        public decimal CurrentFteMonthlyRate { get; set; }
        public decimal CurrentFteSourceAmount { get; set; }
        public decimal AnnualWorkPeriodMultiplier { get; set; }
        public decimal TotalRateAdjustmentAmount { get; set; }
        public decimal IntervalPercentOfAnnualWorkPeriod { get; set; }

        [ForeignKey(nameof(CostingAllocationDetailId))]
        public virtual CostingAllocationDetail Detail { get; set; }
    }
}
``