How to compare values from different tables with a single query on Linq-to-SQL?

Question

The code, with two Linq-to-SQL queries, that I am trying to optimize is below:

        var maxAInstant =
            (
                from a in db.As
                select a.Instant
            )
            .Max();
        var maxBInstant =
            (
                from b in db.Bs
                select b.instant
            )
            .Max();
        var interval = maxAInstant - maxBInstant;
        bool result = interval > new TimeSpan(0, 0, 1);

Can I obtain the result with a single Linq-to-SQL query?

Answer 1

Try this:

bool result = (db.As.Max(a => a.Instant) - db.Bs.Max(b => b.instant)) > new TimeSpan(0,0,1);