[POSSIBLE BUG] ABP suite navigation properties with many to many relation returning empty result #3635

shonimav created 2 years ago

If you're creating a bug/problem report, please include followings:

ABP Framework version: v6.0.0.rc.2 (Commercial)
UI type: Angular
DB provider: EF Core
Tiered (MVC) or Identity Server Separated (Angular): no

I have an entity called Stories and it has 2 navigation properties created through ABP Suite. 1 is one to many relationship with Categories and other is many to many relationship with Tags. When I'm making a call to get a list of stories, it returns all values except for Tags and within the repository I found that it assigns empty tag list without any query generated to get tags. What needs to be changed in ABP suite to generate query for tags in below method?

 protected virtual async Task<IQueryable<StoriesWithNavigationProperties>> GetQueryForNavigationPropertiesAsync()
        {
            return from stories in (await GetDbSetAsync())
                   join category in (await GetDbContextAsync()).Categories on stories.CategoryId equals category.Id into categories
                   from category in categories.DefaultIfEmpty()

                   select new StoriesWithNavigationProperties
                   {
                       Stories = stories,
                       Category = category,
                       Tags = new List<Tag>()  // Instead of new List it should have loaded   with tags
                   };
        }

Go to accepted answer

1 Answer(s)