Cross Join - XXXX

Query

public void Linq102()
{
  
    string[] categories = new string[]{ 
        "Beverages",  
        "Condiments",  
        "Vegetables",  
        "Dairy Products",  
        "Seafood" }; 
  
    List products = GetProductList();
  
    var q =
        from c in categories
        join p in products on c equals p.Category
        select new { Category = c, p.ProductName };
 
    foreach (var v in q)
    {
        Console.WriteLine(v.ProductName + ": " + v.Category); 
    }
}

Lambda Expression

public void Linq102()
{
 
    List customers = GetCustomerList();
    List suppliers = GetSupplierList();
 
    var custSupJoin = suppliers.Join(customers, sup => sup.Country, cust => cust.Country, (sup, cust) => new {
                            Country = sup.Country,
                            SupplierName = sup.SupplierName,
                            CustomerName = cust.CompanyName});
 
    foreach (var item in custSupJoin)
    {
        Console.WriteLine("Country = {0}, Supplier = {1}, Customer = {2}", item.Country, item.SupplierName, item.CustomerName);
    }
}

Output

Chai: Beverages Chang: Beverages GuaranÃ¡ FantÃ¡stica: Beverages Sasquatch Ale: Beverages Steeleye Stout: Beverages CÃ´te de Blaye: Beverages Chartreuse verte: Beverages Ipoh Coffee: Beverages Laughing Lumberjack Lager: Beverages Outback Lager: Beverages RhÃ¶nbrÃ¤u Klosterbier: Beverages LakkalikÃ¶Ã¶ri: Beverages Aniseed Syrup: Condiments Chef Anton's Cajun Seasoning: Condiments Chef Anton's Gumbo Mix: Condiments Grandma's Boysenberry Spread: Condiments Northwoods Cranberry Sauce: Condiments Genen Shouyu: Condiments Gula Malacca: Condiments Sirop d'Ã©rable: Condiments Vegie-spread: Condiments Louisiana Fiery Hot Pepper Sauce: Condiments Louisiana Hot Spiced Okra: Condiments Original Frankfurter grÃ¼ne SoÃŸe: Condiments Queso Cabrales: Dairy Products Queso Manchego La Pastora: Dairy Products Gorgonzola Telino: Dairy Products Mascarpone Fabioli: Dairy Products Geitost: Dairy Products Raclette Courdavault: Dairy Products Camembert Pierrot: Dairy Products Gudbrandsdalsost: Dairy Products Flotemysost: Dairy Products Mozzarella di Giovanni: Dairy Products Ikura: Seafood Konbu: Seafood Carnarvon Tigers: Seafood Nord-Ost Matjeshering: Seafood Inlagd Sill: Seafood Gravad lax: Seafood Boston Crab Meat: Seafood Jack's New England Clam Chowder: Seafood Rogede sild: Seafood Spegesild: Seafood Escargots de Bourgogne: Seafood RÃ¶d Kaviar: Seafood