Where-Bedingung

Fragestellung

• Alle Bestellungen die Herr Müller getätigt hat

Abfragesyntax

var query3 = from c in customers
                         where c.Surname == "Müller"
                         from o in c.Orders
                         select new { o.OrderId, o.ProductId };

foreach (var item in query3)
    Console.WriteLine($"OrderId: {item.OrderId}, PrductId {item.ProductId}");

Erweiterungsmethodensyntax

var query4 = customers
                .Where(c => c.Surname.Equals("Müller"))
                .SelectMany(o => o.Orders)
                .Select(o => new { o.OrderId, o.ProductId });

foreach (var item in query3)
    Console.WriteLine($"OrderId: {item.OrderId}, PrductId {item.ProductId}");