I am currently testing my database relations using Entity Framework. I'm having trouble returning every elements from a linq query. The idea is that I have a table Web_Profiles that has a many-to-many relation with Web_Categories and knowing that I have an ID from both tables, using the Profiles I have, I can find a Category. Since there is an ICollection of Web_Categories in Web_Profiles I can find it using:
var idCategory = context.WebProfiles
.Where(c => c.IDProfile == item)
.Select(c => c.Categories)
.ToList();
WebProfiles being a DbSet from my context and Categories is an ICollection as described above. The return type of this query is : List<ICollection<Web_Categories>>. Now when I loop through this list, if I want to retrieve the Categories associated to profiles, I only managed to retrieve one category for one profile, whereas there are many categories for many profiles. How can I do this?
This is what I have tried, making a Select of IDCategory property, but I don't know which method to use after the Select statement, to show every Category:
foreach (var id in idCategory)
{
Console.WriteLine(id.Select(c => c.IDCategorie));
}
Thanks for your help!