Linq and SQL - group max date - show latest entry - example

Linq - C

// http://creativecommons.org/licenses/by-nc-sa/3.0/

var foo = from p in _db.tblFactories
                        group p by p.tblFactoryName into grp
                        let tblFactoryExportDate = grp.Max(p => p.tblFactoryExportDate)
                        let tblFactoryName = grp.Key

                        from p in grp
                        where p.tblFactoryName == tblFactoryName && 
                        p.tblFactoryExportDate == tblFactoryExportDate
                        select p;

SQL

-- http://creativecommons.org/licenses/by-nc-sa/3.0/

select f.[tblFactoryName],f.tblFactoryExportDate, f.tblFactoryID,f.tblFactoryUnitCount   from tblfactory as  f join
(
  select [tblFactoryName], max(tblFactoryExportDate)as tblFactoryExportDate from tblFactory
  group by [tblFactoryName]
) lastEntry on f.[tblFactoryName] = lastEntry.[tblFactoryName] AND f.tblFactoryExportDate = lastEntry.tblFactoryExportDate