I often want to query one azure sql db, and perhaps verify its data against another.

I cant do this as only 1 azure sql reference is allowed due to no distributed transactions in azure sql.

But how about allowing queries against > 1 db so long as they arent joined, and then it would be possible to do things like:

var idsToFind = conn2.Things.Select(t => t.Id).ToList();

var missing = Things.Where(t => !idsToFind.Contains(r.Id));

missing.Dump();