var query= from x in db.a
           join y in db.b
           on x.bid equals b.id
           group x by x.name into g
           select g.OrderByDescending(z=z.time).First();