public void Any_OrderingsRemoved() { CheckQuery( () => Cooks.OrderBy(c => c.FirstName).Any(), "SELECT CONVERT(BIT, CASE WHEN EXISTS((SELECT [t0].[ID] FROM [CookTable] AS [t0])) THEN 1 ELSE 0 END) AS [value]", row => (object)row.GetValue <bool> (new ColumnID("value", 0)) ); }
public void All_OrderingsRemoved() { CheckQuery( () => Cooks.OrderBy(c => c.FirstName).All(c => c.Name == "Hugo"), "SELECT CONVERT(BIT, CASE WHEN NOT EXISTS((SELECT [t0].[ID] FROM [CookTable] AS [t0] WHERE NOT ([t0].[Name] = @1))) " + "THEN 1 ELSE 0 END) AS [value]", row => (object)row.GetValue <bool> (new ColumnID("value", 0)), new CommandParameter("@1", "Hugo")); }
public void ExplicitJoinWithInto_WithOrderBy() { CheckQuery( from k in Kitchens join c in Cooks.OrderBy(c => c.FirstName).Select(c => c.ID) on k.Cook.ID equals c into gkc from kc in gkc select kc, "SELECT [q0].[Key] AS [value] " + "FROM [KitchenTable] AS [t1] " + "LEFT OUTER JOIN [CookTable] AS [t3] ON ([t1].[ID] = [t3].[KitchenID]) " + "CROSS APPLY (SELECT [t2].[ID] AS [Key],[t2].[FirstName] AS [Value] FROM [CookTable] AS [t2]) AS [q0] " + "WHERE ([t3].[ID] = [q0].[Key]) ORDER BY [q0].[Value] ASC"); }