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

Recommended Answers

All 2 Replies

Additional join looks correct to me too.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.