SELECT * FROM Permissions WHERE Permission_ID NOT IN ( SELECT Permission_ID FROM Page_Permissions WHERE Page_ID = 1 ) Suppose there are three associated tables. 1.Customer - master 2.Order - details table associated with Customer 3.OrderDetails - detail table assiciated with Order table So whenever i fetch customer using LINQ query, all the associated details will be fetched. but what i need is, I need to fetch a customer based on his id and fetch his orders based on some condition in OrderDetail
Read More...