Support for queries of the following form: Cooks.All (c => c.IsStarredCook)
The SQL generated for this query contains a NOT EXISTS clause and a WHERE clause with an inversion of the condition in the All clause. (NOT EXISTS (SELECT ... FROM ... WHERE NOT ([t0].[IsStarredCook] = 1)))
In queries such as the following, avoid creating a join if the foreign key is already available:
from k in Kitchens where k.Cook == null select k
If the KitchenTable contains the foreign key, this should avoid creating a join and yield SQL similar to the following:
SELECT [t0].* FROM [KitchenTable] [t0] WHERE [t0].[CookID] IS NULL