I created a table with relation with
ApplicationUser and when I want to get with eager-loading, I could not get all columns from that table my search base on user authentication.
var UserSites = await _SqldbContext.Users .Where(x => x.UserName == User.Identity.Name) .Include(x => x.sites) .ToListAsync() ; return Json(UserSites);
But in return I only get one row of that table with two columns
but I have more rows with this
userId and also here I get only two columns but I have more than two columns, I am not sure what is wrong here please help me.