Add relation between AbpUser to My Table in 5.0 #2151

9 Answer(s)

• 

  0

  liangshiwei created 4 years ago

  Fullstack Developer

  Hi,

  It is now easier to create the relationship between the entity and the user, you just need to use IdentityUser as the navigation property.

  Example:

  public class MyEntity : ...
  {
    public Guid IdentityUserId {get;set;}
    public IdentityUser IdentityUser {get;set;}
  }
  

  Markdown supported.

  Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post)

  Save Cancel

  1
• 

  0

  jhsanc created 4 years ago

  Everything founds good but I have only this issue using abp suite code generator, made this method:

  But AppUser not exists in current db context, how can I do to replace this context for Identity Context.

  Thank you,

  Markdown supported.

  Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post)

  Save Cancel
• 

  0

  liangshiwei created 4 years ago

  Fullstack Developer

  Hi,

  You can try:

  (await GetDbContextAsync()).Users
  

  Markdown supported.

  Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post)

  Save Cancel
• 

  0

  liangshiwei created 4 years ago

  Fullstack Developer

  Also , can you share the steps? it may a problem, we should fix it if so.

  Markdown supported.

  Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post)

  Save Cancel
• 

  0

  jhsanc created 4 years ago

  Hi,

  You can try:

  (await GetDbContextAsync()).Users 
  

  This not found because users not exists in DbContext: See the DbSets:

  Markdown supported.

  Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post)

  Save Cancel
• 

  0

  jhsanc created 4 years ago

  Also , can you share the steps? it may a problem, we should fix it if so.

  Sure, I'm using abp suite to generate the code, then I create new entity called Person and define a navigation property in abp suite: This create a repository with this method, but this method not found because Users not exists en current db context. Users is not defined in DbSets

  Markdown supported.

  Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post)

  Save Cancel
• 

  1

  liangshiwei created 4 years ago

  Fullstack Developer

  Hi,

  You can try use ReplaceDbContext.

  See, you should use IIdentityProDbContext:

  https://github.com/abpframework/abp/blob/dev/templates/app/aspnet-core/src/MyCompanyName.MyProjectName.EntityFrameworkCore/EntityFrameworkCore/MyProjectNameDbContext.cs

  

  Markdown supported.

  Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post)

  Save Cancel
• 

  0

  jhsanc created 4 years ago

  Hi,

  It is now easier to create the relationship between the entity and the user, you just need to use IdentityUser as the navigation property.

  Example:

  public class MyEntity : ... 
  { 
    public Guid IdentityUserId {get;set;} 
    public IdentityUser IdentityUser {get;set;} 
  } 
  

  Hello this relationship definition create the next warning:

  The foreign key property 'Person.IdentityUserId1' was created in shadow state because a conflicting property with the simple name 'IdentityUserId' exists in the entity type, but is either not mapped, is already used for another relationship, or is incompatible with the associated primary key type. See https://aka.ms/efcore-relationships for information on mapping relationships in EF Core.

  Markdown supported.

  Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post)

  Save Cancel
• 

  0

  liangshiwei created 4 years ago

  Fullstack Developer

  Hi,

  You can configure foreign keys manually: https://docs.microsoft.com/en-us/ef/core/modeling/relationships?tabs=fluent-api,fluent-api-simple-key,simple-key#foreign-key

  Markdown supported.

  Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post)

  Save Cancel