Using entity framework to get info from three connected tables

I got products table

->productID - primary

->price

->Quantity

---

productCategory -table

->prodcatID- primary

->prodId - foreign key

->catID - foreign key

---

productlanguages - table

->prodID - foreign key

->langID - forein key

->Title

So I use Entity framework and I shoud somehow get all products WITH THEIR TITLE,QUANTITYI PRICE From GIVEN CATEGORY AND FROM GIVEN LANGUAGE. SO i should somehow combine info from all these three table

so i made my first function to get all products from given category

public List<ProductCategories> GetAllProductsForCategory(int catID)
{
   using (OnlineStoreDBContext db = new OnlineStoreDBContext())
   {
       List<ProductCategories> lst = db.ProuctCategories.Where(x => (x.CategoryID == catID)).ToList();
   }
}

So now I have a list with all productID that match this category. But now how to get the data from the other two.

---

请参阅加载相关实体：http://msdn.microsoft.com/zh-cn/data/jj574232.aspx

链接地址: http://www.djcxy.com/p/37492.html

上一篇: 我应该如何编写这个实体框架查询？

下一篇: 使用实体框架从三个连接的表中获取信息