c# - Using Linq to get records that have specific foreign key -


i'm trying records table have specific foreign key i'm struggling linq return useful.

post model

public class post {     //... irrelevant properties     [foreignkey("category")]     public int categoryid;     public virtual category category { get; set; } } 

my dbo.posts table

enter image description here

what i've tried

i've tried several variations of following:

//id = 7  using (unitofwork uwork = new unitofwork()) {     var post = uwork.postrepository.getall().where(c => c.categoryid == id);  } 

this returns "non-public members", doesn't contain useful.

enter image description here

question

how modify linq query return posts have specific foreign key id?


updates

here's repository

it seems looking @ dbquery<t> object, implementation of iqueryable<t>. linq did not make query yet, because no 1 asked data. instead collects info query in object, execute later when needed.

to force give actual data, tolist, or iterate on posts, or anything:

var post = uwork.postrepository.getall().where(c => c.categoryid == id).tolist(); 

just make sure before expose db context object.


Comments