Hi I want to write a Correlated SubQuery in LINQ. Here is the scenario. I will Company ID as my paramater. I want to loop through each Customers for this Company ID. Then for each Customers I want to take the top 1 Product of it and manuplate the product feilds. This I want to write in a LINQ Query. Generally the LINQ Query will return the List/Collection. How to get only a single column. Bascially I want my Query should be like below var Errors = (from Proud in ctx.Products where Proud.CustomerId
Read More...