ARK
ARK
PostsComments
CC#
Created by ARK on 2/7/2024 in #help
Display many-to-many table data using view model in controller in ASP.NET Core MVC
Thank you
11 replies
CC#
Created by ARK on 2/7/2024 in #help
Display many-to-many table data using view model in controller in ASP.NET Core MVC
I apologize, but I don't know to use try catch block. The exceptions only appear when I try to open the specific page. Here are the exceptions: When using .ThenInclude().ThenInclude().ToListAsync():
InvalidOperationException: An error was generated for warning 'Microsoft.EntityFrameworkCore.Query.NavigationBaseIncludeIgnored': The navigation 'PostTagModel.Post' was ignored from 'Include' in the query since the fix-up will automatically populate it. If any further navigations are specified in 'Include' afterwards then they will be ignored. Walking back include tree is not allowed. This exception can be suppressed or logged by passing event ID 'CoreEventId.NavigationBaseIncludeIgnored' to the 'ConfigureWarnings' method in 'DbContext.OnConfiguring' or 'AddDbContext'.
When using .ThenInclude().Where().ToListAsync():
InvalidOperationException: An error was generated for warning 'Microsoft.EntityFrameworkCore.Query.NavigationBaseIncludeIgnored': The navigation 'PostTagModel.Post' was ignored from 'Include' in the query since the fix-up will automatically populate it. If any further navigations are specified in 'Include' afterwards then they will be ignored. Walking back include tree is not allowed. This exception can be suppressed or logged by passing event ID 'CoreEventId.NavigationBaseIncludeIgnored' to the 'ConfigureWarnings' method in 'DbContext.OnConfiguring' or 'AddDbContext'.
11 replies
CC#
Created by ARK on 2/7/2024 in #help
Display many-to-many table data using view model in controller in ASP.NET Core MVC
@z0mb I tried using .ToListAsync() method but the code gives error regardless. Here is what I tried: 
c#
var TaggedPostVM = new CardsViewModel
{
    PostCard = await _context.Posts.Include(t => t.PostTags)
                                .ThenInclude(p => p.Post)
                                .ThenInclude(t => t.Id == id)
                                .ToListAsync()
};
c#
var TaggedPostVM = new CardsViewModel
{
    PostCard = await _context.Posts.Include(t => t.PostTags)
                                .ThenInclude(p => p.Post)
                                .ThenInclude(t => t.Id == id)
                                .ToListAsync()
};
or 
c#
var TaggedPostVM = new CardsViewModel
{
    PostCard = await _context.Posts.Include(t => t.PostTags)
                                .ThenInclude(p => p.Post)
                                .Where(t => t.Id == id)
                                .ToListAsync()
};
c#
var TaggedPostVM = new CardsViewModel
{
    PostCard = await _context.Posts.Include(t => t.PostTags)
                                .ThenInclude(p => p.Post)
                                .Where(t => t.Id == id)
                                .ToListAsync()
};
They give server errors!
11 replies