There is no entity [EntityName] with id ... #1903

15 Answer(s)

• 

  0

  maliming created 3 years ago

  Support Team Fullstack Developer

  hi Neozzz

  Can you share a simple project to reproduce? liming.ma@volosoft.com

  Save Cancel
• 

  0

  Neozzz created 3 years ago

  Hi maliming,

  I've sent you a request to the repo on github.

  Thank you

  Save Cancel
• 

  0

  maliming created 3 years ago

  Support Team Fullstack Developer

  hi

  Can you check the tenantid of you entity and tenant of current context?

  

  Save Cancel
• 

  0

  Neozzz created 3 years ago

  Hi maliming,

  thank you for the help. We're able to retrieve the record now, the issue with tenant id was causing the problem. But there are 3 ICollections of 3 entities inside the entity type we're retrieving. We're able to POST the data and data is written into respective tables however when we use the below code to retrieve the record using GET:

  public async Task<EntityNameDto> GetAsync(Guid id) { var entityName = await _entityNameRepository.GetAsync(id); return ObjectMapper.Map<EntityName, EntityNameDto>(entityName); }

  The collections are shown empty as below:

  "contacts": [], "addresses": [], "roles": [],

  I can show it with sample data if you could remote?

  Thanks a lot.

  Save Cancel
• 

  0

  maliming created 3 years ago

  Support Team Fullstack Developer

  Hi

  You should configure the Include of your EF Core Repository.

  https://docs.abp.io/en/abp/4.4/Entity-Framework-Core#eager-loading-load-with-details

  https://github.com/abpframework/abp/blob/dev/modules/identity/src/Volo.Abp.Identity.EntityFrameworkCore/Volo/Abp/Identity/EntityFrameworkCore/IdentityEfCoreQueryableExtensions.cs#L8

  https://github.com/abpframework/abp/blob/dev/modules/identity/src/Volo.Abp.Identity.EntityFrameworkCore/Volo/Abp/Identity/EntityFrameworkCore/EfCoreIdentityUserRepository.cs#L273

  Save Cancel

  1
• 

  0

  Neozzz created 3 years ago

  Hi maliming,

  Thank you for the reply. I was able to obtain 1 level of relationship using the following code:

  public async Task<EntityTypeDto> GetExtendedAsync(Guid id)
          {
              //eager loading
              var queryable = await _entityTypeRepository.WithDetailsAsync(x => x.Contacts,               
                                                                          x => x.Addresses,
                                                                          x => x.Roles);
  
              var query = queryable.Where(x => x.Id == id);            
  
              var entityType = await AsyncExecuter.FirstOrDefaultAsync(query);
              return ObjectMapper.Map<EntityType, EntityTypeDto>(entityType);
          }
  

  How to drill down into another level of relationships within Contacts to obtain collection of PhoneNumbers like below:

  var entityName = context.EntityNames
          .Include(entityName => entityName.Contacts)
          .ThenInclude(contact => contact.PhoneNumbers)        
          .ToList();
  

  Save Cancel
• 

  0

  maliming created 3 years ago

  Support Team Fullstack Developer

  hi Neozzz

  Did you add the IncludeDetails extension method?

  Save Cancel
• 

  0

  Neozzz created 3 years ago

  Hi maliming,

  Should I use WithDetailsAsync as well along with it or this is separate?

  TY

  Save Cancel
• 

  0

  maliming created 3 years ago

  Support Team Fullstack Developer

  hi

  You should add the IncludeDetails and use it in includeDetails .

  Save Cancel
• 

  0

  Neozzz created 3 years ago

  Hi, I did the following:

  created EfCoreEntityTypeQueryableExtension with the following code:

  public static IQueryable<EntityType> IncludeDetails(this IQueryable<EntityType> queryable, bool include = true)
          {
              if (!include)
              {
                  return queryable;
              }
  
              return queryable.Include(et => et.Contacts)
                              .ThenInclude(ec => ec.PhoneNumbers)
                              .Include(et => et.Contacts)
                              .ThenInclude(ec => ec.FaxNumbers);                            
          }
  

  Then wrote the following in EfCoreEntityTypeRepository:

  public override async Task<IQueryable<EntityType>> WithDetailsAsync()
          {
              return (await GetQueryableAsync()).IncludeDetails();
          }
  

  This still doesn't populate the data retrieved. Is there anywhere else I have to check?

  Thank you :)

  Save Cancel
• 

  0

  maliming created 3 years ago

  Support Team Fullstack Developer

  hi Are you call the GetAsync?

  var entity = await _entityNameRepository.GetAsync(id)
  

  Can you share a simple project with me ?

  Save Cancel
• 

  0

  Neozzz created 3 years ago

  Hi,

  I have updated the code with the changes in the repo that I shared with you earlier. Please let me know.

  Thank you

  Save Cancel
• 

  0

  Neozzz created 3 years ago

  hi maliming,

  the getasync works but it doesnt show the other 2 collections, but when using getextendedasync it shows all 3 collections except the 2 subcollections.

  Which shall we use?

  The queryable extension was for withdetailsasync right? Is it enough to add the relationships for those 2 collections in the queryableextension?

  Thank you :)

  Save Cancel
• 

  0

  Neozzz created 3 years ago

  Maliming,

  Meanwhile could you please remove the screenshot of the debugging screen?

  Thank you

  Save Cancel
• 

  0

  maliming created 3 years ago

  Support Team Fullstack Developer

  Deleted. : )

  Save Cancel

  2