Hi i am using views in order to join 3 tables
return (from p
in this.Entities.priceTypes
join userType in this.Entities.userTypes on p.userType equals userType.userTypeID
// join product in this.Entities.products on p.product equals product.productID
select new CommonDB.Views.PriceTypeView()
{
ProductName = p.product,
Price=p.price,
});
I managed to join two tables but i got confused on how to joing the third table (commented one) help please