How to get username from CreatorId column value ? #2704

3 Answer(s)

• 

  0

  liangshiwei created 4 years ago

  Fullstack Developer

  Hi,

  if I understand correctly, are you looking for something like this?

  private readonly IRepository<IdentityUser, Guid> _identityUserRepository;
  
  public async Task GetUserNamesByCreatorId()
  {
      var userNames= (await _identityUserRepository.GetListAsync(x => x.CreatorId == ...)).Select(x => x.UserName);
  }
  

  Markdown supported.

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

  Save Cancel
• 

  -1

  sateesh@g1.com.my created 4 years ago

  Hi,

  if I understand correctly, are you looking for something like this?

  private readonly IRepository<IdentityUser, Guid> _identityUserRepository; 
   
  public async Task GetUserNamesByCreatorId() 
  { 
      var userNames= (await _identityUserRepository.GetListAsync(x => x.CreatorId == ...)).Select(x => x.UserName); 
  } 
  

  Yes, but i need to get all records Creator name with single query execution

  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

  You need to custom a repository.

  public class MyIdentityUserRepository : EfCoreRepository<IIdentityDbContext, IdentityUser, Guid>, IMyIdentityUserRepository
  {
      //.....
  
      public async Task GetCreatorNamesAsync(Guid creatorId)
      {
          var dbContext = await GetDbContextAsync();
      
          var creatorNames = await (from creator in dbContext.Set<IdentityUser>()
              join user in dbContext.Set<IdentityUser>() on creator.Id equals user.CreatorId
              where user.CreatorId == creatorId
              select creator.Name).ToListAsync();
      }
  }
  

  Markdown supported.

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

  Save Cancel