Ejemplo n.º 1
0
 public void GroupBy_AfterDistinct()
 {
     CheckQuery(
         Cooks.Distinct().GroupBy(c => c.Kitchen.ID).Select(g => g.Key),
         "SELECT [q1].[key] AS [value] "
         + "FROM (SELECT [q0].[KitchenID] AS [key] "
         + "FROM (SELECT DISTINCT [t2].[ID],[t2].[FirstName],[t2].[Name],[t2].[IsStarredCook],[t2].[IsFullTimeCook],[t2].[SubstitutedID],"
         + "[t2].[KitchenID],"
         + "[t2].[KnifeID],[t2].[KnifeClassID] "
         + "FROM [CookTable] AS [t2]) AS [q0] "
         + "GROUP BY [q0].[KitchenID]) AS [q1]");
 }