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

1 vote180 views1 answer
How to cast list to observablecollection c#
C#
0 vote139 views1 answer
C# print expression tree
C#
0 vote188 views1 answer
Windows form Webbrowser url detection
C#
0 vote201 views1 answer
Unity collision.impulse
C#Unity
0 vote142 views2 answers
Array reduce c#
C#
0 vote127 views1 answer
Declare multiple variables in for loop c#
C#
6 votes129 views2 answers
C# const vs readonly
C#
0 vote144 views1 answer
Button next for picturebox c#
C#
3 votes95 views1 answer
Winforms textbox placeholder
C#
11 votes120 views4 answers
C# check if array contains value
C#