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

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.

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
Post a Comment