Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Dec 29, 2012 08:02 PM by CPrakash82
Dec 29, 2012 07:00 PM|LINK
Hi, i have two entities "News" and "Photos"
News has a relationship with Photos, witch is 1 to many relation.
I'm trying to perform a query using linq, witch will bring a news form the db, and only the photos associated with the news, that are in a specific workflow state, for instance "published"
Here how i'm trying to do it:
return Context.News.Single(c => c.Id == Id).Photos.Where(p => p.WorkflowsId == 2);
can anyone explain to me how perform complex queries ?
Dec 29, 2012 08:02 PM|LINK
Refer LINQ 101