Linq - What is the best way to get the latest record in the Reports joined to the record in the SiteList table?
What I am trying to achieve is this. Each record in the "SiteList" table joined with the most current record by "ReportCreateDate" in the Reports table. This should be straight forward but I keep drawing a blank. How do I do this?