Mapping an owned type to a different table produces an error on SqlServer

[AndriySvyryd]

The PK on the owned type is being erroneously marked as ValueGenerated.OnAdd

Originally reported in #17448

Exception message:Microsoft.Data.SqlClient.SqlException: 'Cascading foreign key 'FK_OrderDetails_DetailedOrders_OrderId' cannot be created where the referencing column 'OrderDetails.OrderId' is an identity column.
Could not create constraint or index. See previous errors.'

protected override void OnModelCreating(ModelBuilder modelBuilder)
{
    modelBuilder.Entity<DetailedOrder>().OwnsOne(p => p.OrderDetails, od =>
    {
        od.ToTable("OrderDetails");
    });
}

public class DetailedOrder
{
    public int Id { get; set; }
    public OrderDetails OrderDetails { get; set; }
}

public class OrderDetails
{
    public DetailedOrder Order { get; set; }
    public string BillingAddress { get; set; }
    public string ShippingAddress { get; set; }
}