public void SetOperation_WithDifferentColumnLists() { CheckQuery( () => Cooks.Union(Chefs.Select(c => c)), "SELECT [t0].[ID],[t0].[FirstName],[t0].[Name],[t0].[IsStarredCook],[t0].[IsFullTimeCook],[t0].[SubstitutedID],[t0].[KitchenID]," + "[t0].[KnifeID],[t0].[KnifeClassID] " + "FROM [CookTable] AS [t0] " + "UNION (SELECT [t1].[ID],[t1].[FirstName],[t1].[Name],[t1].[IsStarredCook],[t1].[IsFullTimeCook],[t1].[SubstitutedID],[t1].[KitchenID]," + "[t1].[KnifeID],[t1].[KnifeClassID],[t1].[LetterOfRecommendation] " + "FROM [dbo].[ChefTable] AS [t1])"); }