Query associative table ef6

var cat_id=1; // Change this variable for your real cat_id

var query= from article in db.Articles
           where article.Categories.Any(c=>c.Category_ID==cat_id)
           select article;

Source: stackoverflow.com

Similar codes

3 votes225 views1 answer
Linq include
C#
3 votes226 views1 answer
What is the namespace for textmesh pro
C#
0 vote205 views1 answer
Winforms C# code cross thread operation is not valid
C#
3 votes214 views1 answer
C# read text file to list string
C#
5 votes172 views1 answer
Know to which direction Vector.MoveTowards is moving unity 2D
C#
1 vote213 views1 answer
Remove last instance of string c#
C#
1 vote205 views1 answer
C# unity get lines
C#Unity
0 vote208 views1 answer
Mvc remote validation additional table
C#
0 vote214 views2 answers
Html.Beginform
C#
1 vote221 views1 answer
How check if variable is send to page or not in laravwel
C#