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");
}
