I was trying to get Suggested Product. My SQL query is :
select o.ProductID OwnerPrdID, o.ProductName OwnerProductName, s.ProductID, s.ProductName SuggestedProductName, s.URLName,s.ShortDescription,
s.TeaserPrice from Products o,Products s,ProductSuggest ps Where o.ProductID=ps.OwnerProductID and s.ProductID=ps.SuggestProductID and o.SiteID = 'D8841E18-E3CB-4E02-A963-6B79C97E979B'
and o.ProductID='C28C62DA-E459-4137-9196-520F9F8E8789'
Can anyone help me to convert the same in Linq
Go to the complete details ...