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

10 votes251 views1 answer
Unity c# get bool from another script
C#
1 vote253 views1 answer
How do I print something in the console every frame unity
C#Unity
2 votes234 views1 answer
C# Switch and case
C#
0 vote233 views1 answer
C# test if char is alpha
C#
1 vote229 views1 answer
Error inflating class android.support.constraint.ConstraintLayout
C#
0 vote226 views1 answer
How to run code without a gameobject unity
C#
17 votes197 views4 answers
Height of binary tree
C#
1 vote235 views1 answer
Unity detect number key
C#
0 vote226 views1 answer
Check variable is empty powershell
C#
1 vote230 views1 answer
Initialize ConsoleLoggerProvider in EF core
C#