Skip to content

Facing issue on Bulk Update of a table(has table splits) #352

@Bhargavi88

Description

@Bhargavi88

I have an entity Order which has a table split as in (https://docs.microsoft.com/en-us/ef/core/modeling/table-splitting).

public class Order
{
public int Id { get; set; }
public OrderStatus? Status { get; set; }
public DetailedOrder DetailedOrder { get; set; }
}

public class DetailedOrder
{
public int Id { get; set; }
public OrderStatus? Status { get; set; }
public string BillingAddress { get; set; }
public string ShippingAddress { get; set; }
public byte[] Version { get; set; }
}

modelBuilder.Entity(dob =>
{
dob.ToTable("Orders");
dob.Property(o => o.Status).HasColumnName("Status");
});

modelBuilder.Entity(ob =>
{
ob.ToTable("Orders");
ob.Property(o => o.Status).HasColumnName("Status");
ob.HasOne(o => o.DetailedOrder).WithOne()
.HasForeignKey(o => o.Id);
});

When I try to perform BulkUpdate as _context.BulkUpdate(orders), I am seeing issue "The specified schema name "dbo" either does not exist or you do not have permission to use it.
Microsoft.Data.SqlClient.SqlException (0x80131904): The specified schema name "dbo" either does not exist or you do not have permission to use it".

Does this support table splits or Is there any way to configure for splits?

Metadata

Metadata

Assignees

No one assigned

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions