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

0 vote159 views1 answer
How to look around with mouse in unity
C#
0 vote150 views1 answer
Unity how to check index of enum
C#
0 vote133 views1 answer
C# get gridview DataKeyNames
C#
16 votes135 views2 answers
Unity destroy
C#
0 vote132 views1 answer
Get all images from folder asp.net
C#
0 vote140 views1 answer
List of vectors c#
C#
-1 vote128 views2 answers
Using statement c#
C#
0 vote159 views1 answer
Find label controls in c#
C#
1 vote140 views1 answer
Create a slider in the inspector C#
C#
0 vote149 views1 answer
Overridable method C#
C#