bo/AppServer/Data/Entity/BOContext.decl.cs

using Microsoft.EntityFrameworkCore;

namespace BO.AppServer.Data.Entity
{
    public partial class BOContext
    {
        partial void OnModelCreatingPartial(ModelBuilder modelBuilder)
        {
            modelBuilder.Entity<Workspace>(entity =>
                {
                    // WORKAROUND temporary solution for keyless entity
                    //modelBuilder.Entity<UserWorkspace>()
                    //    .HasAlternateKey(x => x.Id);
                    
                    modelBuilder.Entity<UserWorkspace>()
                        .HasKey(t => new { t.WorkspaceId, t.UserId });
                        

                    modelBuilder.Entity<UserWorkspace>()
                        .HasOne(am => am.User)
                        .WithMany(a => a.UserWorkspaces)
                        .HasForeignKey(am => am.UserId);

                    modelBuilder.Entity<UserWorkspace>()
                        .HasOne(am => am.Workspace)
                        .WithMany(m => m.UserWorkspaces)
                        .HasForeignKey(am => am.WorkspaceId);


                    modelBuilder.Entity<Workspace>().HasOne(d => d.BillingInfo)
                    .WithOne(p => p.Workspace)
                    .OnDelete(DeleteBehavior.ClientSetNull)
                    .HasConstraintName("REL_Workspace_BillingInfo");
                }
            );
        }
    }
}