如何使用聚合SQL作为LINQ查询最优雅地表达左连接

SQL:

SQL：

SELECT
   u.id,
   u.name,
   isnull(MAX(h.dateCol), '1900-01-01') dateColWithDefault
FROM universe u
LEFT JOIN history h 
   ON u.id=h.id 
   AND h.dateCol<GETDATE()-1
GROUP BY u.Id, u.name
SELECT
   u.id,
   u.name,
   isn