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