linuxbender

// 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