How to Join AbpUsers table in EFCore #3275

8 Answer(s)

• 

  0

  mikemey01 created 9 years ago

  For reference here is what I'm using:

  I'm subclassing AbpUsers<User> and using the InverseProperty attribute:

  public class User : AbpUser<User>
      {
          [InverseProperty("CreatorUser")]
          public ICollection<PMNotes> CreatorNotes { get; set; }
          [InverseProperty("DeleterUser")]
          public ICollection<PMNotes> DeleterNotes { get; set; }
          
      }
  

  then in the table that I want to reference I'm doing:

  [Table("PMNotes")]
      public class PMNotes : FullAuditedEntity, IMustHaveTenant
      {
          public virtual int TenantId { get; set; }
  
          public virtual User CreatorUser { get; set; }
          public virtual User DeleterUser { get; set; }
          
          [Required]
          public virtual string Note { get; set; }
      }
  

  but i get this error:

  Unable to determine the relationship represented by navigation property 'User.DeleterUser' of type 'User'. Either manually configure the relationship, or ignore this property from the model.

  Markdown is supported

  Copy & paste or drag & drop images (max 30 MB per image)

  Save Cancel
• 

  0

  ismcagdas created 9 years ago

  Support Team

  Hi,

  Does your scenario works for CreatorUser when you remove DeleterUser InverseProperty ?

  Thanks.

  Markdown is supported

  Copy & paste or drag & drop images (max 30 MB per image)

  Save Cancel
• 

  0

  mikemey01 created 9 years ago

  Hi - unfortunately not, I get the following error:

  Unable to determine the relationship represented by navigation property 'User.DeleterUser' of type 'User'. Either manually configure the relationship, or ignore this property from the model.

  Markdown is supported

  Copy & paste or drag & drop images (max 30 MB per image)

  Save Cancel
• 

  0

  ismcagdas created 9 years ago

  Support Team

  Hi,

  Can you define your entity like this ?

  public class PMNotes : FullAuditedEntity<User>, IMustHaveTenant
  {
  ...
  }
  

  You will need to remove CreatorUser and DeletorUser as well.

  If it does not work, you can try to configure it manually.

  Thanks.

  Markdown is supported

  Copy & paste or drag & drop images (max 30 MB per image)

  Save Cancel
• 

  0

  mikemey01 created 9 years ago

  That breaks the app service:

  private readonly IRepository<PMNotes> _notesRepository;

  with the error:

  The type ...PMNotes can not be used as a type parameter 'TEntity' in the generic type or method IRepository<TEntity>.

  what is the manual configuration look like?

  Markdown is supported

  Copy & paste or drag & drop images (max 30 MB per image)

  Save Cancel
• 

  0

  ismcagdas created 9 years ago

  Support Team

  Hi,

  Can you change your repository to

  private readonly IRepository<PMNotes,User> _notesRepository;
  

  Actually I don't know the manual configuration but you have to do it in OnModelCreating on your DbContext. You can check it on the internet since it is a common thing in EF.

  Thanks.

  Markdown is supported

  Copy & paste or drag & drop images (max 30 MB per image)

  Save Cancel
• 

  0

  mikemey01 created 9 years ago

  I got this working where I can now include the AbpUsers table for any AuditedEntity by adding a FK to either CreatorUserId, DeleterUserId, or LastModifierUserId.

  Table with CreatorUserId, note that it references Authorization.Users.User instead of subclassing the AbpUsers entity:

  [Table("PMNotes")]
      public class PMNotes : FullAuditedEntity, IMustHaveTenant
      {
          public virtual int TenantId { get; set; }
          
           ...
  
          [ForeignKey("CreatorUserId")]
          public Authorization.Users.User CreatorUser { get; set; }
      }
  

  Added the collection to the Authorization.Users.User table:

  public class User : AbpUser<User>
      {
          public ICollection<PMNotes> CreatorNotes { get; set; }
          ...
       }
  

  Then in the DBContext, add the following (although this may not actually be required with the "ForeignKey" attribute above:

  modelBuilder.Entity<PMNotes>()
                          .HasOne(m => m.CreatorUser)
                          .WithMany(t => t.CreatorNotes)
                          .HasForeignKey(m => m.CreatorUserId)
                          .OnDelete(DeleteBehavior.Restrict);
  

  Hope it helps someone.

  Markdown is supported

  Copy & paste or drag & drop images (max 30 MB per image)

  Save Cancel
• 

  0

  jdavis01 created 9 years ago

  @MikeyMey01,

  Helped a great deal. Thanks for posting..

  Markdown is supported

  Copy & paste or drag & drop images (max 30 MB per image)

  Save Cancel