101 LINQ Samples: Projection Operators
Select - Simple 1
This sample uses select to produce a sequence of ints one higher than those in an existing array of ints.
public void Linq6()
{
int[] numbers = { 5, 4, 1, 3, 9, 8, 6, 7, 2, 0 };
var numsPlusOne =
from n in numbers
select n + 1;
Console.WriteLine("Numbers + 1:");
foreach (var i in numsPlusOne)
{
Console.WriteLine(i);
}
}
Result
Numbers + 1:
6
5
2
4
10
9
7
8
3
1
Select - Simple 2
This sample uses select to return a sequence of just the names of a list of products.
public void Linq7()
{
List<Product> products = GetProductList();
var productNames =
from p in products
select p.ProductName;
Console.WriteLine("Product Names:");
foreach (var productName in productNames)
{
Console.WriteLine(productName);
}
}
Result
Product Names:
Chai
Chang
Aniseed Syrup
Chef Anton's Cajun Seasoning
Chef Anton's Gumbo Mix
Grandma's Boysenberry Spread
Uncle Bob's Organic Dried Pears
Northwoods Cranberry Sauce
Mishi Kobe Niku
Ikura
Queso Cabrales
Queso Manchego La Pastora
Konbu
Tofu
Genen Shouyu
Pavlova
Alice Mutton
Carnarvon Tigers
Teatime Chocolate Biscuits
Sir Rodney's Marmalade
Sir Rodney's Scones
Gustaf's Knäckebröd
Tunnbröd
Guaraná Fantástica
NuNuCa Nuß-Nougat-Creme
Gumbär Gummibärchen
Schoggi Schokolade
Rössle Sauerkraut
Thüringer Rostbratwurst
Nord-Ost Matjeshering
Gorgonzola Telino
Mascarpone Fabioli
Geitost
Sasquatch Ale
Steeleye Stout
Inlagd Sill
Gravad lax
Côte de Blaye
Chartreuse verte
Boston Crab Meat
Jack's New England Clam Chowder
Singaporean Hokkien Fried Mee
Ipoh Coffee
Gula Malacca
Rogede sild
Spegesild
Zaanse koeken
Chocolade
Maxilaku
Valkoinen suklaa
Manjimup Dried Apples
Filo Mix
Perth Pasties
Tourtière
Pâté chinois
Gnocchi di nonna Alice
Ravioli Angelo
Escargots de Bourgogne
Raclette Courdavault
Camembert Pierrot
Sirop d'érable
Tarte au sucre
Vegie-spread
Wimmers gute Semmelknödel
Louisiana Fiery Hot Pepper Sauce
Louisiana Hot Spiced Okra
Laughing Lumberjack Lager
Scottish Longbreads
Gudbrandsdalsost
Outback Lager
Flotemysost
Mozzarella di Giovanni
Röd Kaviar
Longlife Tofu
Rhönbräu Klosterbier
Lakkalikööri
Original Frankfurter grüne Soße
This sample uses select to produce a sequence of strings representing the text version of a sequence of ints.
public void Linq8()
{
int[] numbers = { 5, 4, 1, 3, 9, 8, 6, 7, 2, 0 };
string[] strings = { "zero", "one", "two", "three", "four", "five", "six", "seven", "eight", "nine" };
var textNums =
from n in numbers
select strings[n];
Console.WriteLine("Number strings:");
foreach (var s in textNums)
{
Console.WriteLine(s);
}
}
Result
Number strings:
five
four
one
three
nine
eight
six
seven
two
zero
Select - Anonymous Types 1
This sample uses select to produce a sequence of the uppercase and lowercase versions of each word in the original array.
public void Linq9()
{
string[] words = { "aPPLE", "BlUeBeRrY", "cHeRry" };
var upperLowerWords =
from w in words
select new { Upper = w.ToUpper(), Lower = w.ToLower() };
foreach (var ul in upperLowerWords)
{
Console.WriteLine("Uppercase: {0}, Lowercase: {1}", ul.Upper, ul.Lower);
}
}
Result
Uppercase: APPLE, Lowercase: apple
Uppercase: BLUEBERRY, Lowercase: blueberry
Uppercase: CHERRY, Lowercase: cherry
Select - Anonymous Types 2
This sample uses select to produce a sequence containing text representations of digits and whether their length is even or odd.
public void Linq10()
{
int[] numbers = { 5, 4, 1, 3, 9, 8, 6, 7, 2, 0 };
string[] strings = { "zero", "one", "two", "three", "four", "five", "six", "seven", "eight", "nine" };
var digitOddEvens =
from n in numbers
select new { Digit = strings[n], Even = (n % 2 == 0) };
foreach (var d in digitOddEvens)
{
Console.WriteLine("The digit {0} is {1}.", d.Digit, d.Even ? "even" : "odd");
}
}
Result
The digit five is odd.
The digit four is even.
The digit one is odd.
The digit three is odd.
The digit nine is odd.
The digit eight is even.
The digit six is even.
The digit seven is odd.
The digit two is even.
The digit zero is even.
Select - Anonymous Types 3
This sample uses select to produce a sequence containing some properties of Products, including UnitPrice which is renamed to Price in the resulting type.
public void Linq11()
{
List<Product> products = GetProductList();
var productInfos =
from p in products
select new { p.ProductName, p.Category, Price = p.UnitPrice };
Console.WriteLine("Product Info:");
foreach (var productInfo in productInfos)
{
Console.WriteLine("{0} is in the category {1} and costs {2} per unit.", productInfo.ProductName, productInfo.Category, productInfo.Price);
}
}
Result
Product Info:
Chai is in the category Beverages and costs 18.0000 per unit.
Chang is in the category Beverages and costs 19.0000 per unit.
Aniseed Syrup is in the category Condiments and costs 10.0000 per unit.
Chef Anton's Cajun Seasoning is in the category Condiments and costs 22.0000 per unit.
Chef Anton's Gumbo Mix is in the category Condiments and costs 21.3500 per unit.
Grandma's Boysenberry Spread is in the category Condiments and costs 25.0000 per unit.
Uncle Bob's Organic Dried Pears is in the category Produce and costs 30.0000 per unit.
Northwoods Cranberry Sauce is in the category Condiments and costs 40.0000 per unit.
Mishi Kobe Niku is in the category Meat/Poultry and costs 97.0000 per unit.
Ikura is in the category Seafood and costs 31.0000 per unit.
Queso Cabrales is in the category Dairy Products and costs 21.0000 per unit.
Queso Manchego La Pastora is in the category Dairy Products and costs 38.0000 per unit.
Konbu is in the category Seafood and costs 6.0000 per unit.
Tofu is in the category Produce and costs 23.2500 per unit.
Genen Shouyu is in the category Condiments and costs 15.5000 per unit.
Pavlova is in the category Confections and costs 17.4500 per unit.
Alice Mutton is in the category Meat/Poultry and costs 39.0000 per unit.
Carnarvon Tigers is in the category Seafood and costs 62.5000 per unit.
Teatime Chocolate Biscuits is in the category Confections and costs 9.2000 per unit.
Sir Rodney's Marmalade is in the category Confections and costs 81.0000 per unit.
Sir Rodney's Scones is in the category Confections and costs 10.0000 per unit.
Gustaf's Knäckebröd is in the category Grains/Cereals and costs 21.0000 per unit.
Tunnbröd is in the category Grains/Cereals and costs 9.0000 per unit.
Guaraná Fantástica is in the category Beverages and costs 4.5000 per unit.
NuNuCa Nuß-Nougat-Creme is in the category Confections and costs 14.0000 per unit.
Gumbär Gummibärchen is in the category Confections and costs 31.2300 per unit.
Schoggi Schokolade is in the category Confections and costs 43.9000 per unit.
Rössle Sauerkraut is in the category Produce and costs 45.6000 per unit.
Thüringer Rostbratwurst is in the category Meat/Poultry and costs 123.7900 per unit.
Nord-Ost Matjeshering is in the category Seafood and costs 25.8900 per unit.
Gorgonzola Telino is in the category Dairy Products and costs 12.5000 per unit.
Mascarpone Fabioli is in the category Dairy Products and costs 32.0000 per unit.
Geitost is in the category Dairy Products and costs 2.5000 per unit.
Sasquatch Ale is in the category Beverages and costs 14.0000 per unit.
Steeleye Stout is in the category Beverages and costs 18.0000 per unit.
Inlagd Sill is in the category Seafood and costs 19.0000 per unit.
Gravad lax is in the category Seafood and costs 26.0000 per unit.
Côte de Blaye is in the category Beverages and costs 263.5000 per unit.
Chartreuse verte is in the category Beverages and costs 18.0000 per unit.
Boston Crab Meat is in the category Seafood and costs 18.4000 per unit.
Jack's New England Clam Chowder is in the category Seafood and costs 9.6500 per unit.
Singaporean Hokkien Fried Mee is in the category Grains/Cereals and costs 14.0000 per unit.
Ipoh Coffee is in the category Beverages and costs 46.0000 per unit.
Gula Malacca is in the category Condiments and costs 19.4500 per unit.
Rogede sild is in the category Seafood and costs 9.5000 per unit.
Spegesild is in the category Seafood and costs 12.0000 per unit.
Zaanse koeken is in the category Confections and costs 9.5000 per unit.
Chocolade is in the category Confections and costs 12.7500 per unit.
Maxilaku is in the category Confections and costs 20.0000 per unit.
Valkoinen suklaa is in the category Confections and costs 16.2500 per unit.
Manjimup Dried Apples is in the category Produce and costs 53.0000 per unit.
Filo Mix is in the category Grains/Cereals and costs 7.0000 per unit.
Perth Pasties is in the category Meat/Poultry and costs 32.8000 per unit.
Tourtière is in the category Meat/Poultry and costs 7.4500 per unit.
Pâté chinois is in the category Meat/Poultry and costs 24.0000 per unit.
Gnocchi di nonna Alice is in the category Grains/Cereals and costs 38.0000 per unit.
Ravioli Angelo is in the category Grains/Cereals and costs 19.5000 per unit.
Escargots de Bourgogne is in the category Seafood and costs 13.2500 per unit.
Raclette Courdavault is in the category Dairy Products and costs 55.0000 per unit.
Camembert Pierrot is in the category Dairy Products and costs 34.0000 per unit.
Sirop d'érable is in the category Condiments and costs 28.5000 per unit.
Tarte au sucre is in the category Confections and costs 49.3000 per unit.
Vegie-spread is in the category Condiments and costs 43.9000 per unit.
Wimmers gute Semmelknödel is in the category Grains/Cereals and costs 33.2500 per unit.
Louisiana Fiery Hot Pepper Sauce is in the category Condiments and costs 21.0500 per unit.
Louisiana Hot Spiced Okra is in the category Condiments and costs 17.0000 per unit.
Laughing Lumberjack Lager is in the category Beverages and costs 14.0000 per unit.
Scottish Longbreads is in the category Confections and costs 12.5000 per unit.
Gudbrandsdalsost is in the category Dairy Products and costs 36.0000 per unit.
Outback Lager is in the category Beverages and costs 15.0000 per unit.
Flotemysost is in the category Dairy Products and costs 21.5000 per unit.
Mozzarella di Giovanni is in the category Dairy Products and costs 34.8000 per unit.
Röd Kaviar is in the category Seafood and costs 15.0000 per unit.
Longlife Tofu is in the category Produce and costs 10.0000 per unit.
Rhönbräu Klosterbier is in the category Beverages and costs 7.7500 per unit.
Lakkalikööri is in the category Beverages and costs 18.0000 per unit.
Original Frankfurter grüne Soße is in the category Condiments and costs 13.0000 per unit.
Select - Indexed
This sample uses an indexed Select clause to determine if the value of ints in an array match their position in the array.
public void Linq12()
{
int[] numbers = { 5, 4, 1, 3, 9, 8, 6, 7, 2, 0 };
var numsInPlace = numbers.Select((num, index) => new { Num = num, InPlace = (num == index) });
Console.WriteLine("Number: In-place?");
foreach (var n in numsInPlace)
{
Console.WriteLine("{0}: {1}", n.Num, n.InPlace);
}
}
Result
Number: In-place?
5: False
4: False
1: False
3: True
9: False
8: False
6: True
7: True
2: False
0: False
Select - Filtered
This sample combines select and where to make a simple query that returns the text form of each digit less than 5.
public void Linq13()
{
int[] numbers = { 5, 4, 1, 3, 9, 8, 6, 7, 2, 0 };
string[] digits = { "zero", "one", "two", "three", "four", "five", "six", "seven", "eight", "nine" };
var lowNums =
from n in numbers
where n < 5
select digits[n];
Console.WriteLine("Numbers < 5:");
foreach (var num in lowNums)
{
Console.WriteLine(num);
}
}
Result
Numbers < 5:
four
one
three
two
zero
SelectMany - Compound from 1
This sample uses a compound from clause to make a query that returns all pairs of numbers from both arrays such that the number from numbersA is less than the number from numbersB.
public void Linq14()
{
int[] numbersA = { 0, 2, 4, 5, 6, 8, 9 };
int[] numbersB = { 1, 3, 5, 7, 8 };
var pairs =
from a in numbersA
from b in numbersB
where a < b
select new { a, b };
Console.WriteLine("Pairs where a < b:");
foreach (var pair in pairs)
{
Console.WriteLine("{0} is less than {1}", pair.a, pair.b);
}
}
Result
Pairs where a < b:
0 is less than 1
0 is less than 3
0 is less than 5
0 is less than 7
0 is less than 8
2 is less than 3
2 is less than 5
2 is less than 7
2 is less than 8
4 is less than 5
4 is less than 7
4 is less than 8
5 is less than 7
5 is less than 8
6 is less than 7
6 is less than 8
SelectMany - Compound from 2
This sample uses a compound from clause to select all orders where the order total is less than 500.00.
public void Linq15()
{
List<Customer> customers = GetCustomerList();
var orders =
from c in customers
from o in c.Orders
where o.Total < 500.00M
select new { c.CustomerID, o.OrderID, o.Total };
ObjectDumper.Write(orders);
}
Result
CustomerID=ALFKI OrderID=10702 Total=330.00
CustomerID=ALFKI OrderID=10952 Total=471.20
CustomerID=ANATR OrderID=10308 Total=88.80
CustomerID=ANATR OrderID=10625 Total=479.75
CustomerID=ANATR OrderID=10759 Total=320.00
CustomerID=ANTON OrderID=10365 Total=403.20
CustomerID=ANTON OrderID=10682 Total=375.50
CustomerID=AROUT OrderID=10355 Total=480.00
CustomerID=AROUT OrderID=10453 Total=407.70
CustomerID=AROUT OrderID=10741 Total=228.00
CustomerID=AROUT OrderID=10743 Total=319.20
CustomerID=AROUT OrderID=10793 Total=191.10
CustomerID=AROUT OrderID=10864 Total=282.00
CustomerID=AROUT OrderID=10920 Total=390.00
CustomerID=AROUT OrderID=11016 Total=491.50
CustomerID=BERGS OrderID=10445 Total=174.90
CustomerID=BERGS OrderID=10689 Total=472.50
CustomerID=BERGS OrderID=10778 Total=96.50
CustomerID=BLAUS OrderID=10501 Total=149.00
CustomerID=BLAUS OrderID=10509 Total=136.80
CustomerID=BLAUS OrderID=10582 Total=330.00
CustomerID=BLAUS OrderID=10614 Total=464.00
CustomerID=BLONP OrderID=10628 Total=450.00
CustomerID=BOLID OrderID=10970 Total=224.00
CustomerID=BONAP OrderID=10331 Total=88.50
CustomerID=BONAP OrderID=10730 Total=484.26
CustomerID=BONAP OrderID=10732 Total=360.00
CustomerID=BONAP OrderID=10940 Total=360.00
CustomerID=BSBEV OrderID=10289 Total=479.40
CustomerID=BSBEV OrderID=10484 Total=386.20
CustomerID=BSBEV OrderID=10538 Total=139.80
CustomerID=BSBEV OrderID=10539 Total=355.50
CustomerID=BSBEV OrderID=10578 Total=477.00
CustomerID=BSBEV OrderID=10599 Total=493.00
CustomerID=BSBEV OrderID=10947 Total=220.00
CustomerID=CACTU OrderID=10521 Total=225.50
CustomerID=CACTU OrderID=10782 Total=12.50
CustomerID=CACTU OrderID=10819 Total=477.00
CustomerID=CACTU OrderID=10881 Total=150.00
CustomerID=CACTU OrderID=11054 Total=305.00
CustomerID=CENTC OrderID=10259 Total=100.80
CustomerID=COMMI OrderID=10466 Total=216.00
CustomerID=COMMI OrderID=10969 Total=108.00
CustomerID=COMMI OrderID=11042 Total=405.75
CustomerID=CONSH OrderID=10462 Total=156.00
CustomerID=DRACD OrderID=10363 Total=447.20
CustomerID=DRACD OrderID=10391 Total=86.40
CustomerID=DRACD OrderID=10797 Total=420.00
CustomerID=DRACD OrderID=11067 Total=86.85
CustomerID=DUMON OrderID=10311 Total=268.80
CustomerID=DUMON OrderID=10609 Total=424.00
CustomerID=DUMON OrderID=10683 Total=63.00
CustomerID=ERNSH OrderID=10771 Total=344.00
CustomerID=FAMIA OrderID=10386 Total=166.00
CustomerID=FAMIA OrderID=10414 Total=224.83
CustomerID=FAMIA OrderID=10581 Total=310.00
CustomerID=FAMIA OrderID=10725 Total=287.80
CustomerID=FOLKO OrderID=10378 Total=103.20
CustomerID=FOLKO OrderID=10434 Total=321.12
CustomerID=FOLKO OrderID=10460 Total=176.10
CustomerID=FOLKO OrderID=10824 Total=250.80
CustomerID=FOLKO OrderID=10955 Total=74.40
CustomerID=FOLKO OrderID=10980 Total=248.00
CustomerID=FRANS OrderID=10422 Total=49.80
CustomerID=FRANS OrderID=10710 Total=93.50
CustomerID=FRANS OrderID=10753 Total=88.00
CustomerID=FRANS OrderID=10807 Total=18.40
CustomerID=FRANS OrderID=11060 Total=266.00
CustomerID=FURIB OrderID=10352 Total=136.30
CustomerID=FURIB OrderID=10491 Total=259.50
CustomerID=FURIB OrderID=10604 Total=230.85
CustomerID=FURIB OrderID=10963 Total=57.80
CustomerID=GALED OrderID=10366 Total=136.00
CustomerID=GALED OrderID=10426 Total=338.20
CustomerID=GALED OrderID=10568 Total=155.00
CustomerID=GALED OrderID=10887 Total=70.00
CustomerID=GALED OrderID=10928 Total=137.50
CustomerID=GODOS OrderID=10874 Total=310.00
CustomerID=GODOS OrderID=11037 Total=60.00
CustomerID=GOURL OrderID=10652 Total=318.84
CustomerID=GOURL OrderID=10777 Total=224.00
CustomerID=GOURL OrderID=10959 Total=131.75
CustomerID=GOURL OrderID=11049 Total=273.60
CustomerID=GREAL OrderID=10528 Total=392.20
CustomerID=GREAL OrderID=10589 Total=72.00
CustomerID=GREAL OrderID=10936 Total=456.00
CustomerID=GREAL OrderID=11006 Total=329.68
CustomerID=GREAL OrderID=11040 Total=200.00
CustomerID=GROSR OrderID=10785 Total=387.50
CustomerID=HANAR OrderID=10770 Total=236.25
CustomerID=HANAR OrderID=10925 Total=475.15
CustomerID=HILAA OrderID=10476 Total=180.48
CustomerID=HILAA OrderID=10613 Total=353.20
CustomerID=HILAA OrderID=10705 Total=378.00
CustomerID=HILAA OrderID=10863 Total=441.15
CustomerID=HILAA OrderID=10960 Total=265.35
CustomerID=HUNGC OrderID=10375 Total=338.00
CustomerID=HUNGC OrderID=10394 Total=442.00
CustomerID=HUNGC OrderID=10415 Total=102.40
CustomerID=HUNGC OrderID=10600 Total=479.80
CustomerID=ISLAT OrderID=10318 Total=240.40
CustomerID=ISLAT OrderID=10321 Total=144.00
CustomerID=ISLAT OrderID=10473 Total=230.40
CustomerID=ISLAT OrderID=10674 Total=45.00
CustomerID=ISLAT OrderID=10798 Total=446.60
CustomerID=KOENE OrderID=10323 Total=164.40
CustomerID=KOENE OrderID=10506 Total=415.80
CustomerID=KOENE OrderID=10542 Total=469.11
CustomerID=LACOR OrderID=10972 Total=251.50
CustomerID=LACOR OrderID=10973 Total=291.55
CustomerID=LAMAI OrderID=10358 Total=429.40
CustomerID=LAMAI OrderID=10371 Total=72.96
CustomerID=LAMAI OrderID=10425 Total=360.00
CustomerID=LAMAI OrderID=10454 Total=331.20
CustomerID=LAMAI OrderID=10610 Total=299.25
CustomerID=LAMAI OrderID=10631 Total=55.80
CustomerID=LAMAI OrderID=10832 Total=475.11
CustomerID=LAMAI OrderID=11051 Total=36.00
CustomerID=LAUGB OrderID=10495 Total=278.00
CustomerID=LAUGB OrderID=10620 Total=57.50
CustomerID=LAUGB OrderID=10810 Total=187.00
CustomerID=LAZYK OrderID=10482 Total=147.00
CustomerID=LAZYK OrderID=10545 Total=210.00
CustomerID=LEHMS OrderID=10279 Total=351.00
CustomerID=LEHMS OrderID=10534 Total=465.70
CustomerID=LEHMS OrderID=10891 Total=368.93
CustomerID=LETSS OrderID=10579 Total=317.75
CustomerID=LILAS OrderID=10381 Total=112.00
CustomerID=LILAS OrderID=10899 Total=122.40
CustomerID=LILAS OrderID=11065 Total=189.42
CustomerID=LILAS OrderID=11071 Total=484.50
CustomerID=LINOD OrderID=10405 Total=400.00
CustomerID=LINOD OrderID=10840 Total=211.20
CustomerID=LINOD OrderID=11014 Total=243.18
CustomerID=LONEP OrderID=10307 Total=424.00
CustomerID=LONEP OrderID=10317 Total=288.00
CustomerID=LONEP OrderID=10544 Total=417.20
CustomerID=LONEP OrderID=10662 Total=125.00
CustomerID=LONEP OrderID=10867 Total=98.40
CustomerID=LONEP OrderID=10883 Total=36.00
CustomerID=MAGAA OrderID=10275 Total=291.84
CustomerID=MAGAA OrderID=10467 Total=235.20
CustomerID=MAGAA OrderID=10754 Total=55.20
CustomerID=MAGAA OrderID=10950 Total=110.00
CustomerID=MAISD OrderID=11004 Total=295.38
CustomerID=MEREP OrderID=10376 Total=399.00
CustomerID=MEREP OrderID=10505 Total=147.90
CustomerID=MORGK OrderID=10699 Total=114.00
CustomerID=MORGK OrderID=10945 Total=245.00
CustomerID=NORTS OrderID=10517 Total=352.00
CustomerID=NORTS OrderID=10752 Total=252.00
CustomerID=NORTS OrderID=11057 Total=45.00
CustomerID=OCEAN OrderID=10409 Total=319.20
CustomerID=OCEAN OrderID=10531 Total=110.00
CustomerID=OCEAN OrderID=10898 Total=30.00
CustomerID=OTTIK OrderID=10508 Total=240.00
CustomerID=PERIC OrderID=10322 Total=112.00
CustomerID=PERIC OrderID=11073 Total=300.00
CustomerID=PICCO OrderID=10489 Total=439.20
CustomerID=PRINI OrderID=10336 Total=285.12
CustomerID=QUEDE OrderID=10261 Total=448.00
CustomerID=QUEDE OrderID=10291 Total=497.52
CustomerID=QUEDE OrderID=10794 Total=314.76
CustomerID=QUICK OrderID=10313 Total=182.40
CustomerID=RANCH OrderID=10448 Total=443.40
CustomerID=RANCH OrderID=11019 Total=76.00
CustomerID=REGGC OrderID=10288 Total=80.10
CustomerID=REGGC OrderID=10428 Total=192.00
CustomerID=REGGC OrderID=10562 Total=488.70
CustomerID=REGGC OrderID=10586 Total=23.80
CustomerID=REGGC OrderID=10655 Total=154.40
CustomerID=REGGC OrderID=11062 Total=406.40
CustomerID=RICAR OrderID=10299 Total=349.50
CustomerID=RICAR OrderID=10648 Total=372.38
CustomerID=RICSU OrderID=10951 Total=458.76
CustomerID=RICSU OrderID=11075 Total=498.10
CustomerID=ROMEY OrderID=10281 Total=86.50
CustomerID=ROMEY OrderID=10282 Total=155.40
CustomerID=ROMEY OrderID=10306 Total=498.50
CustomerID=ROMEY OrderID=10917 Total=365.89
CustomerID=ROMEY OrderID=11013 Total=361.00
CustomerID=SANTG OrderID=10520 Total=200.00
CustomerID=SAVEA OrderID=10815 Total=40.00
CustomerID=SIMOB OrderID=10341 Total=352.60
CustomerID=SIMOB OrderID=11074 Total=232.08
CustomerID=SPECD OrderID=10738 Total=52.35
CustomerID=SPECD OrderID=10907 Total=108.50
CustomerID=SPECD OrderID=11043 Total=210.00
CustomerID=SPLIR OrderID=10271 Total=48.00
CustomerID=SPLIR OrderID=10349 Total=141.60
CustomerID=SPLIR OrderID=10432 Total=485.00
CustomerID=SPLIR OrderID=10974 Total=439.00
CustomerID=SUPRD OrderID=10767 Total=28.00
CustomerID=THEBI OrderID=10310 Total=336.00
CustomerID=THEBI OrderID=10708 Total=180.40
CustomerID=THEBI OrderID=10992 Total=69.60
CustomerID=THECR OrderID=10775 Total=228.00
CustomerID=THECR OrderID=11003 Total=326.00
CustomerID=TOMSP OrderID=10438 Total=454.00
CustomerID=TOMSP OrderID=10446 Total=246.24
CustomerID=TOMSP OrderID=10548 Total=240.10
CustomerID=TORTU OrderID=10276 Total=420.00
CustomerID=TORTU OrderID=11069 Total=360.00
CustomerID=TRADH OrderID=10496 Total=190.00
CustomerID=TRAIH OrderID=10822 Total=237.90
CustomerID=VAFFE OrderID=10602 Total=48.75
CustomerID=VICTE OrderID=10334 Total=144.80
CustomerID=VICTE OrderID=10450 Total=425.12
CustomerID=VICTE OrderID=10478 Total=471.20
CustomerID=VICTE OrderID=10806 Total=439.60
CustomerID=VICTE OrderID=10843 Total=159.00
CustomerID=VINET OrderID=10295 Total=121.60
CustomerID=VINET OrderID=10737 Total=139.80
CustomerID=VINET OrderID=10739 Total=240.00
CustomerID=WANDK OrderID=10348 Total=363.60
CustomerID=WANDK OrderID=10651 Total=397.80
CustomerID=WARTH OrderID=10266 Total=346.56
CustomerID=WARTH OrderID=10412 Total=334.80
CustomerID=WARTH OrderID=10437 Total=393.00
CustomerID=WARTH OrderID=11025 Total=270.00
CustomerID=WELLI OrderID=10585 Total=142.50
CustomerID=WELLI OrderID=10809 Total=140.00
CustomerID=WELLI OrderID=10900 Total=33.75
CustomerID=WELLI OrderID=10905 Total=342.00
CustomerID=WHITC OrderID=10723 Total=468.45
CustomerID=WILMK OrderID=10248 Total=440.00
CustomerID=WILMK OrderID=10615 Total=120.00
CustomerID=WILMK OrderID=10673 Total=412.35
CustomerID=WILMK OrderID=10873 Total=336.80
CustomerID=WILMK OrderID=10910 Total=452.90
CustomerID=WOLZA OrderID=10374 Total=459.00
CustomerID=WOLZA OrderID=10792 Total=399.85
CustomerID=WOLZA OrderID=10870 Total=160.00
CustomerID=WOLZA OrderID=10906 Total=427.50
SelectMany - Compound from 3
This sample uses a compound from clause to select all orders where the order was made in 1998 or later.
public void Linq16()
{
List<Customer> customers = GetCustomerList();
var orders =
from c in customers
from o in c.Orders
where o.OrderDate >= new DateTime(1998, 1, 1)
select new { c.CustomerID, o.OrderID, o.OrderDate };
ObjectDumper.Write(orders);
}
Result
CustomerID=ALFKI OrderID=10835 OrderDate=1/15/1998
CustomerID=ALFKI OrderID=10952 OrderDate=3/16/1998
CustomerID=ALFKI OrderID=11011 OrderDate=4/9/1998
CustomerID=ANATR OrderID=10926 OrderDate=3/4/1998
CustomerID=ANTON OrderID=10856 OrderDate=1/28/1998
CustomerID=AROUT OrderID=10864 OrderDate=2/2/1998
CustomerID=AROUT OrderID=10920 OrderDate=3/3/1998
CustomerID=AROUT OrderID=10953 OrderDate=3/16/1998
CustomerID=AROUT OrderID=11016 OrderDate=4/10/1998
CustomerID=BERGS OrderID=10837 OrderDate=1/16/1998
CustomerID=BERGS OrderID=10857 OrderDate=1/28/1998
CustomerID=BERGS OrderID=10866 OrderDate=2/3/1998
CustomerID=BERGS OrderID=10875 OrderDate=2/6/1998
CustomerID=BERGS OrderID=10924 OrderDate=3/4/1998
CustomerID=BLAUS OrderID=10853 OrderDate=1/27/1998
CustomerID=BLAUS OrderID=10956 OrderDate=3/17/1998
CustomerID=BLAUS OrderID=11058 OrderDate=4/29/1998
CustomerID=BLONP OrderID=10826 OrderDate=1/12/1998
CustomerID=BOLID OrderID=10970 OrderDate=3/24/1998
CustomerID=BONAP OrderID=10827 OrderDate=1/12/1998
CustomerID=BONAP OrderID=10871 OrderDate=2/5/1998
CustomerID=BONAP OrderID=10876 OrderDate=2/9/1998
CustomerID=BONAP OrderID=10932 OrderDate=3/6/1998
CustomerID=BONAP OrderID=10940 OrderDate=3/11/1998
CustomerID=BONAP OrderID=11076 OrderDate=5/6/1998
CustomerID=BOTTM OrderID=10918 OrderDate=3/2/1998
CustomerID=BOTTM OrderID=10944 OrderDate=3/12/1998
CustomerID=BOTTM OrderID=10949 OrderDate=3/13/1998
CustomerID=BOTTM OrderID=10975 OrderDate=3/25/1998
CustomerID=BOTTM OrderID=10982 OrderDate=3/27/1998
CustomerID=BOTTM OrderID=11027 OrderDate=4/16/1998
CustomerID=BOTTM OrderID=11045 OrderDate=4/23/1998
CustomerID=BOTTM OrderID=11048 OrderDate=4/24/1998
CustomerID=BSBEV OrderID=10943 OrderDate=3/11/1998
CustomerID=BSBEV OrderID=10947 OrderDate=3/13/1998
CustomerID=BSBEV OrderID=11023 OrderDate=4/14/1998
CustomerID=CACTU OrderID=10819 OrderDate=1/7/1998
CustomerID=CACTU OrderID=10881 OrderDate=2/11/1998
CustomerID=CACTU OrderID=10937 OrderDate=3/10/1998
CustomerID=CACTU OrderID=11054 OrderDate=4/28/1998
CustomerID=CHOPS OrderID=10966 OrderDate=3/20/1998
CustomerID=CHOPS OrderID=11029 OrderDate=4/16/1998
CustomerID=CHOPS OrderID=11041 OrderDate=4/22/1998
CustomerID=COMMI OrderID=10969 OrderDate=3/23/1998
CustomerID=COMMI OrderID=11042 OrderDate=4/22/1998
CustomerID=CONSH OrderID=10848 OrderDate=1/23/1998
CustomerID=DRACD OrderID=10825 OrderDate=1/9/1998
CustomerID=DRACD OrderID=11036 OrderDate=4/20/1998
CustomerID=DRACD OrderID=11067 OrderDate=5/4/1998
CustomerID=DUMON OrderID=10890 OrderDate=2/16/1998
CustomerID=EASTC OrderID=10987 OrderDate=3/31/1998
CustomerID=EASTC OrderID=11024 OrderDate=4/15/1998
CustomerID=EASTC OrderID=11047 OrderDate=4/24/1998
CustomerID=EASTC OrderID=11056 OrderDate=4/28/1998
CustomerID=ERNSH OrderID=10836 OrderDate=1/16/1998
CustomerID=ERNSH OrderID=10854 OrderDate=1/27/1998
CustomerID=ERNSH OrderID=10895 OrderDate=2/18/1998
CustomerID=ERNSH OrderID=10968 OrderDate=3/23/1998
CustomerID=ERNSH OrderID=10979 OrderDate=3/26/1998
CustomerID=ERNSH OrderID=10990 OrderDate=4/1/1998
CustomerID=ERNSH OrderID=11008 OrderDate=4/8/1998
CustomerID=ERNSH OrderID=11017 OrderDate=4/13/1998
CustomerID=ERNSH OrderID=11072 OrderDate=5/5/1998
CustomerID=FOLKO OrderID=10824 OrderDate=1/9/1998
CustomerID=FOLKO OrderID=10880 OrderDate=2/10/1998
CustomerID=FOLKO OrderID=10902 OrderDate=2/23/1998
CustomerID=FOLKO OrderID=10955 OrderDate=3/17/1998
CustomerID=FOLKO OrderID=10977 OrderDate=3/26/1998
CustomerID=FOLKO OrderID=10980 OrderDate=3/27/1998
CustomerID=FOLKO OrderID=10993 OrderDate=4/1/1998
CustomerID=FOLKO OrderID=11001 OrderDate=4/6/1998
CustomerID=FOLKO OrderID=11050 OrderDate=4/27/1998
CustomerID=FRANK OrderID=10859 OrderDate=1/29/1998
CustomerID=FRANK OrderID=10929 OrderDate=3/5/1998
CustomerID=FRANK OrderID=11012 OrderDate=4/9/1998
CustomerID=FRANR OrderID=10860 OrderDate=1/29/1998
CustomerID=FRANR OrderID=10971 OrderDate=3/24/1998
CustomerID=FRANS OrderID=11026 OrderDate=4/15/1998
CustomerID=FRANS OrderID=11060 OrderDate=4/30/1998
CustomerID=FURIB OrderID=10963 OrderDate=3/19/1998
CustomerID=GALED OrderID=10887 OrderDate=2/13/1998
CustomerID=GALED OrderID=10928 OrderDate=3/5/1998
CustomerID=GODOS OrderID=10872 OrderDate=2/5/1998
CustomerID=GODOS OrderID=10874 OrderDate=2/6/1998
CustomerID=GODOS OrderID=10888 OrderDate=2/16/1998
CustomerID=GODOS OrderID=10911 OrderDate=2/26/1998
CustomerID=GODOS OrderID=10948 OrderDate=3/13/1998
CustomerID=GODOS OrderID=11009 OrderDate=4/8/1998
CustomerID=GODOS OrderID=11037 OrderDate=4/21/1998
CustomerID=GOURL OrderID=10959 OrderDate=3/18/1998
CustomerID=GOURL OrderID=11049 OrderDate=4/24/1998
CustomerID=GREAL OrderID=10816 OrderDate=1/6/1998
CustomerID=GREAL OrderID=10936 OrderDate=3/9/1998
CustomerID=GREAL OrderID=11006 OrderDate=4/7/1998
CustomerID=GREAL OrderID=11040 OrderDate=4/22/1998
CustomerID=GREAL OrderID=11061 OrderDate=4/30/1998
CustomerID=HANAR OrderID=10886 OrderDate=2/13/1998
CustomerID=HANAR OrderID=10903 OrderDate=2/24/1998
CustomerID=HANAR OrderID=10922 OrderDate=3/3/1998
CustomerID=HANAR OrderID=10925 OrderDate=3/4/1998
CustomerID=HANAR OrderID=10981 OrderDate=3/27/1998
CustomerID=HANAR OrderID=11022 OrderDate=4/14/1998
CustomerID=HANAR OrderID=11052 OrderDate=4/27/1998
CustomerID=HILAA OrderID=10863 OrderDate=2/2/1998
CustomerID=HILAA OrderID=10901 OrderDate=2/23/1998
CustomerID=HILAA OrderID=10957 OrderDate=3/18/1998
CustomerID=HILAA OrderID=10960 OrderDate=3/19/1998
CustomerID=HILAA OrderID=10976 OrderDate=3/25/1998
CustomerID=HILAA OrderID=11055 OrderDate=4/28/1998
CustomerID=HUNGO OrderID=10897 OrderDate=2/19/1998
CustomerID=HUNGO OrderID=10912 OrderDate=2/26/1998
CustomerID=HUNGO OrderID=10985 OrderDate=3/30/1998
CustomerID=HUNGO OrderID=11063 OrderDate=4/30/1998
CustomerID=ISLAT OrderID=10829 OrderDate=1/13/1998
CustomerID=ISLAT OrderID=10933 OrderDate=3/6/1998
CustomerID=KOENE OrderID=10817 OrderDate=1/6/1998
CustomerID=KOENE OrderID=10849 OrderDate=1/23/1998
CustomerID=KOENE OrderID=10893 OrderDate=2/18/1998
CustomerID=KOENE OrderID=11028 OrderDate=4/16/1998
CustomerID=LACOR OrderID=10858 OrderDate=1/29/1998
CustomerID=LACOR OrderID=10927 OrderDate=3/5/1998
CustomerID=LACOR OrderID=10972 OrderDate=3/24/1998
CustomerID=LACOR OrderID=10973 OrderDate=3/24/1998
CustomerID=LAMAI OrderID=10832 OrderDate=1/14/1998
CustomerID=LAMAI OrderID=10923 OrderDate=3/3/1998
CustomerID=LAMAI OrderID=11051 OrderDate=4/27/1998
CustomerID=LAUGB OrderID=10810 OrderDate=1/1/1998
CustomerID=LEHMS OrderID=10862 OrderDate=1/30/1998
CustomerID=LEHMS OrderID=10891 OrderDate=2/17/1998
CustomerID=LEHMS OrderID=10934 OrderDate=3/9/1998
CustomerID=LEHMS OrderID=11070 OrderDate=5/5/1998
CustomerID=LETSS OrderID=10884 OrderDate=2/12/1998
CustomerID=LILAS OrderID=10823 OrderDate=1/9/1998
CustomerID=LILAS OrderID=10899 OrderDate=2/20/1998
CustomerID=LILAS OrderID=10997 OrderDate=4/3/1998
CustomerID=LILAS OrderID=11065 OrderDate=5/1/1998
CustomerID=LILAS OrderID=11071 OrderDate=5/5/1998
CustomerID=LINOD OrderID=10811 OrderDate=1/2/1998
CustomerID=LINOD OrderID=10838 OrderDate=1/19/1998
CustomerID=LINOD OrderID=10840 OrderDate=1/19/1998
CustomerID=LINOD OrderID=10919 OrderDate=3/2/1998
CustomerID=LINOD OrderID=10954 OrderDate=3/17/1998
CustomerID=LINOD OrderID=11014 OrderDate=4/10/1998
CustomerID=LINOD OrderID=11039 OrderDate=4/21/1998
CustomerID=LONEP OrderID=10867 OrderDate=2/3/1998
CustomerID=LONEP OrderID=10883 OrderDate=2/12/1998
CustomerID=LONEP OrderID=11018 OrderDate=4/13/1998
CustomerID=MAGAA OrderID=10818 OrderDate=1/7/1998
CustomerID=MAGAA OrderID=10939 OrderDate=3/10/1998
CustomerID=MAGAA OrderID=10950 OrderDate=3/16/1998
CustomerID=MAISD OrderID=10892 OrderDate=2/17/1998
CustomerID=MAISD OrderID=10896 OrderDate=2/19/1998
CustomerID=MAISD OrderID=10978 OrderDate=3/26/1998
CustomerID=MAISD OrderID=11004 OrderDate=4/7/1998
CustomerID=MORGK OrderID=10945 OrderDate=3/12/1998
CustomerID=NORTS OrderID=11057 OrderDate=4/29/1998
CustomerID=OCEAN OrderID=10898 OrderDate=2/20/1998
CustomerID=OCEAN OrderID=10958 OrderDate=3/18/1998
CustomerID=OCEAN OrderID=10986 OrderDate=3/30/1998
CustomerID=OLDWO OrderID=10855 OrderDate=1/27/1998
CustomerID=OLDWO OrderID=10965 OrderDate=3/20/1998
CustomerID=OLDWO OrderID=11034 OrderDate=4/20/1998
CustomerID=OTTIK OrderID=10833 OrderDate=1/15/1998
CustomerID=OTTIK OrderID=10999 OrderDate=4/3/1998
CustomerID=OTTIK OrderID=11020 OrderDate=4/14/1998
CustomerID=PERIC OrderID=10995 OrderDate=4/2/1998
CustomerID=PERIC OrderID=11073 OrderDate=5/5/1998
CustomerID=PICCO OrderID=10844 OrderDate=1/21/1998
CustomerID=PICCO OrderID=11053 OrderDate=4/27/1998
CustomerID=PRINI OrderID=10808 OrderDate=1/1/1998
CustomerID=PRINI OrderID=11007 OrderDate=4/8/1998
CustomerID=QUEDE OrderID=10989 OrderDate=3/31/1998
CustomerID=QUEEN OrderID=10868 OrderDate=2/4/1998
CustomerID=QUEEN OrderID=10913 OrderDate=2/26/1998
CustomerID=QUEEN OrderID=10914 OrderDate=2/27/1998
CustomerID=QUEEN OrderID=10961 OrderDate=3/19/1998
CustomerID=QUEEN OrderID=11068 OrderDate=5/4/1998
CustomerID=QUICK OrderID=10845 OrderDate=1/21/1998
CustomerID=QUICK OrderID=10865 OrderDate=2/2/1998
CustomerID=QUICK OrderID=10878 OrderDate=2/10/1998
CustomerID=QUICK OrderID=10938 OrderDate=3/10/1998
CustomerID=QUICK OrderID=10962 OrderDate=3/19/1998
CustomerID=QUICK OrderID=10991 OrderDate=4/1/1998
CustomerID=QUICK OrderID=10996 OrderDate=4/2/1998
CustomerID=QUICK OrderID=11021 OrderDate=4/14/1998
CustomerID=RANCH OrderID=10828 OrderDate=1/13/1998
CustomerID=RANCH OrderID=10916 OrderDate=2/27/1998
CustomerID=RANCH OrderID=11019 OrderDate=4/13/1998
CustomerID=RATTC OrderID=10820 OrderDate=1/7/1998
CustomerID=RATTC OrderID=10852 OrderDate=1/26/1998
CustomerID=RATTC OrderID=10889 OrderDate=2/16/1998
CustomerID=RATTC OrderID=10988 OrderDate=3/31/1998
CustomerID=RATTC OrderID=11000 OrderDate=4/6/1998
CustomerID=RATTC OrderID=11077 OrderDate=5/6/1998
CustomerID=REGGC OrderID=10812 OrderDate=1/2/1998
CustomerID=REGGC OrderID=10908 OrderDate=2/26/1998
CustomerID=REGGC OrderID=10942 OrderDate=3/11/1998
CustomerID=REGGC OrderID=11010 OrderDate=4/9/1998
CustomerID=REGGC OrderID=11062 OrderDate=4/30/1998
CustomerID=RICAR OrderID=10813 OrderDate=1/5/1998
CustomerID=RICAR OrderID=10851 OrderDate=1/26/1998
CustomerID=RICAR OrderID=10877 OrderDate=2/9/1998
CustomerID=RICAR OrderID=11059 OrderDate=4/29/1998
CustomerID=RICSU OrderID=10931 OrderDate=3/6/1998
CustomerID=RICSU OrderID=10951 OrderDate=3/16/1998
CustomerID=RICSU OrderID=11033 OrderDate=4/17/1998
CustomerID=RICSU OrderID=11075 OrderDate=5/6/1998
CustomerID=ROMEY OrderID=10917 OrderDate=3/2/1998
CustomerID=ROMEY OrderID=11013 OrderDate=4/9/1998
CustomerID=SANTG OrderID=10831 OrderDate=1/14/1998
CustomerID=SANTG OrderID=10909 OrderDate=2/26/1998
CustomerID=SANTG OrderID=11015 OrderDate=4/10/1998
CustomerID=SAVEA OrderID=10815 OrderDate=1/5/1998
CustomerID=SAVEA OrderID=10847 OrderDate=1/22/1998
CustomerID=SAVEA OrderID=10882 OrderDate=2/11/1998
CustomerID=SAVEA OrderID=10894 OrderDate=2/18/1998
CustomerID=SAVEA OrderID=10941 OrderDate=3/11/1998
CustomerID=SAVEA OrderID=10983 OrderDate=3/27/1998
CustomerID=SAVEA OrderID=10984 OrderDate=3/30/1998
CustomerID=SAVEA OrderID=11002 OrderDate=4/6/1998
CustomerID=SAVEA OrderID=11030 OrderDate=4/17/1998
CustomerID=SAVEA OrderID=11031 OrderDate=4/17/1998
CustomerID=SAVEA OrderID=11064 OrderDate=5/1/1998
CustomerID=SEVES OrderID=10869 OrderDate=2/4/1998
CustomerID=SIMOB OrderID=11074 OrderDate=5/6/1998
CustomerID=SPECD OrderID=10907 OrderDate=2/25/1998
CustomerID=SPECD OrderID=10964 OrderDate=3/20/1998
CustomerID=SPECD OrderID=11043 OrderDate=4/22/1998
CustomerID=SPLIR OrderID=10821 OrderDate=1/8/1998
CustomerID=SPLIR OrderID=10974 OrderDate=3/25/1998
CustomerID=SUPRD OrderID=10841 OrderDate=1/20/1998
CustomerID=SUPRD OrderID=10846 OrderDate=1/22/1998
CustomerID=SUPRD OrderID=10885 OrderDate=2/12/1998
CustomerID=SUPRD OrderID=10930 OrderDate=3/6/1998
CustomerID=SUPRD OrderID=11035 OrderDate=4/20/1998
CustomerID=SUPRD OrderID=11038 OrderDate=4/21/1998
CustomerID=THEBI OrderID=10992 OrderDate=4/1/1998
CustomerID=THECR OrderID=11003 OrderDate=4/6/1998
CustomerID=TOMSP OrderID=10967 OrderDate=3/23/1998
CustomerID=TORTU OrderID=10842 OrderDate=1/20/1998
CustomerID=TORTU OrderID=10915 OrderDate=2/27/1998
CustomerID=TORTU OrderID=11069 OrderDate=5/4/1998
CustomerID=TRADH OrderID=10830 OrderDate=1/13/1998
CustomerID=TRADH OrderID=10834 OrderDate=1/15/1998
CustomerID=TRADH OrderID=10839 OrderDate=1/19/1998
CustomerID=TRAIH OrderID=10822 OrderDate=1/8/1998
CustomerID=VAFFE OrderID=10921 OrderDate=3/3/1998
CustomerID=VAFFE OrderID=10946 OrderDate=3/12/1998
CustomerID=VAFFE OrderID=10994 OrderDate=4/2/1998
CustomerID=VICTE OrderID=10814 OrderDate=1/5/1998
CustomerID=VICTE OrderID=10843 OrderDate=1/21/1998
CustomerID=VICTE OrderID=10850 OrderDate=1/23/1998
CustomerID=WANDK OrderID=11046 OrderDate=4/23/1998
CustomerID=WARTH OrderID=11025 OrderDate=4/15/1998
CustomerID=WELLI OrderID=10809 OrderDate=1/1/1998
CustomerID=WELLI OrderID=10900 OrderDate=2/20/1998
CustomerID=WELLI OrderID=10905 OrderDate=2/24/1998
CustomerID=WELLI OrderID=10935 OrderDate=3/9/1998
CustomerID=WHITC OrderID=10861 OrderDate=1/30/1998
CustomerID=WHITC OrderID=10904 OrderDate=2/24/1998
CustomerID=WHITC OrderID=11032 OrderDate=4/17/1998
CustomerID=WHITC OrderID=11066 OrderDate=5/1/1998
CustomerID=WILMK OrderID=10873 OrderDate=2/6/1998
CustomerID=WILMK OrderID=10879 OrderDate=2/10/1998
CustomerID=WILMK OrderID=10910 OrderDate=2/26/1998
CustomerID=WILMK OrderID=11005 OrderDate=4/7/1998
CustomerID=WOLZA OrderID=10870 OrderDate=2/4/1998
CustomerID=WOLZA OrderID=10906 OrderDate=2/25/1998
CustomerID=WOLZA OrderID=10998 OrderDate=4/3/1998
CustomerID=WOLZA OrderID=11044 OrderDate=4/23/1998
SelectMany - from Assignment
This sample uses a compound from clause to select all orders where the order total is greater than 2000.00 and uses from assignment to avoid requesting the total twice.
public void Linq17()
{
List<Customer> customers = GetCustomerList();
var orders =
from c in customers
from o in c.Orders
where o.Total >= 2000.0M
select new { c.CustomerID, o.OrderID, o.Total };
ObjectDumper.Write(orders);
}
Result
CustomerID=ANTON OrderID=10573 Total=2082.00
CustomerID=AROUT OrderID=10558 Total=2142.90
CustomerID=AROUT OrderID=10953 Total=4441.25
CustomerID=BERGS OrderID=10384 Total=2222.40
CustomerID=BERGS OrderID=10524 Total=3192.65
CustomerID=BERGS OrderID=10672 Total=3815.25
CustomerID=BERGS OrderID=10857 Total=2048.21
CustomerID=BLONP OrderID=10360 Total=7390.20
CustomerID=BOLID OrderID=10801 Total=3026.85
CustomerID=BONAP OrderID=10340 Total=2436.18
CustomerID=BONAP OrderID=10511 Total=2550.00
CustomerID=BOTTM OrderID=10742 Total=3118.00
CustomerID=BOTTM OrderID=10949 Total=4422.00
CustomerID=CHOPS OrderID=10519 Total=2314.20
CustomerID=CHOPS OrderID=10746 Total=2311.70
CustomerID=COMMI OrderID=10290 Total=2169.00
CustomerID=EASTC OrderID=10400 Total=3063.00
CustomerID=EASTC OrderID=10987 Total=2772.00
CustomerID=EASTC OrderID=11056 Total=3740.00
CustomerID=ERNSH OrderID=10351 Total=5398.72
CustomerID=ERNSH OrderID=10382 Total=2900.00
CustomerID=ERNSH OrderID=10390 Total=2090.88
CustomerID=ERNSH OrderID=10402 Total=2713.50
CustomerID=ERNSH OrderID=10430 Total=4899.20
CustomerID=ERNSH OrderID=10514 Total=8623.45
CustomerID=ERNSH OrderID=10595 Total=4725.00
CustomerID=ERNSH OrderID=10633 Total=5510.59
CustomerID=ERNSH OrderID=10698 Total=3436.44
CustomerID=ERNSH OrderID=10764 Total=2286.00
CustomerID=ERNSH OrderID=10773 Total=2030.40
CustomerID=ERNSH OrderID=10776 Total=6635.28
CustomerID=ERNSH OrderID=10795 Total=2158.00
CustomerID=ERNSH OrderID=10836 Total=4705.50
CustomerID=ERNSH OrderID=10854 Total=2966.50
CustomerID=ERNSH OrderID=10895 Total=6379.40
CustomerID=ERNSH OrderID=10979 Total=4813.50
CustomerID=ERNSH OrderID=10990 Total=4288.85
CustomerID=ERNSH OrderID=11008 Total=4680.90
CustomerID=ERNSH OrderID=11017 Total=6750.00
CustomerID=ERNSH OrderID=11072 Total=5218.00
CustomerID=FOLIG OrderID=10634 Total=4985.50
CustomerID=FOLIG OrderID=10789 Total=3687.00
CustomerID=FOLKO OrderID=10533 Total=2222.20
CustomerID=FOLKO OrderID=10561 Total=2844.50
CustomerID=FOLKO OrderID=10703 Total=2545.00
CustomerID=FOLKO OrderID=10762 Total=4337.00
CustomerID=FOLKO OrderID=10977 Total=2233.00
CustomerID=FOLKO OrderID=10993 Total=4895.44
CustomerID=FOLKO OrderID=11001 Total=2769.00
CustomerID=FRANK OrderID=10267 Total=3536.60
CustomerID=FRANK OrderID=10337 Total=2467.00
CustomerID=FRANK OrderID=10670 Total=2301.75
CustomerID=FRANK OrderID=11012 Total=2825.30
CustomerID=GODOS OrderID=10629 Total=2775.05
CustomerID=GODOS OrderID=10872 Total=2058.46
CustomerID=GODOS OrderID=10948 Total=2362.25
CustomerID=GOURL OrderID=10709 Total=3424.00
CustomerID=GREAL OrderID=10616 Total=4807.00
CustomerID=GREAL OrderID=10816 Total=8446.45
CustomerID=HANAR OrderID=10886 Total=3127.50
CustomerID=HANAR OrderID=10981 Total=15810.00
CustomerID=HILAA OrderID=10395 Total=2122.92
CustomerID=HILAA OrderID=10490 Total=3163.20
CustomerID=HILAA OrderID=10601 Total=2285.00
CustomerID=HILAA OrderID=10641 Total=2054.00
CustomerID=HILAA OrderID=10796 Total=2341.36
CustomerID=HUNGO OrderID=10298 Total=2645.00
CustomerID=HUNGO OrderID=10335 Total=2036.16
CustomerID=HUNGO OrderID=10503 Total=2048.50
CustomerID=HUNGO OrderID=10516 Total=2381.05
CustomerID=HUNGO OrderID=10567 Total=2519.00
CustomerID=HUNGO OrderID=10687 Total=4960.90
CustomerID=HUNGO OrderID=10701 Total=2864.50
CustomerID=HUNGO OrderID=10897 Total=10835.24
CustomerID=HUNGO OrderID=10912 Total=6200.55
CustomerID=HUNGO OrderID=10985 Total=2023.38
CustomerID=KOENE OrderID=10718 Total=3463.00
CustomerID=KOENE OrderID=10817 Total=10952.84
CustomerID=KOENE OrderID=10893 Total=5502.11
CustomerID=KOENE OrderID=11028 Total=2160.00
CustomerID=LAMAI OrderID=10413 Total=2123.20
CustomerID=LAMAI OrderID=10787 Total=2622.76
CustomerID=LEHMS OrderID=10522 Total=2318.24
CustomerID=LEHMS OrderID=10772 Total=3603.22
CustomerID=LILAS OrderID=10823 Total=2826.00
CustomerID=LINOD OrderID=10638 Total=2720.05
CustomerID=LINOD OrderID=11039 Total=3090.00
CustomerID=MAISD OrderID=10760 Total=2917.00
CustomerID=MAISD OrderID=10892 Total=2090.00
CustomerID=MEREP OrderID=10339 Total=3354.00
CustomerID=MEREP OrderID=10424 Total=9194.56
CustomerID=MEREP OrderID=10570 Total=2465.25
CustomerID=MEREP OrderID=10605 Total=4109.70
CustomerID=MEREP OrderID=10618 Total=2697.50
CustomerID=MORGK OrderID=10575 Total=2147.40
CustomerID=OCEAN OrderID=10986 Total=2220.00
CustomerID=OLDWO OrderID=10305 Total=3741.30
CustomerID=OLDWO OrderID=10855 Total=2227.89
CustomerID=OTTIK OrderID=10766 Total=2310.00
CustomerID=PICCO OrderID=10353 Total=8593.28
CustomerID=PICCO OrderID=10530 Total=4180.00
CustomerID=PICCO OrderID=11053 Total=3055.00
CustomerID=PRINI OrderID=11007 Total=2633.90
CustomerID=QUEEN OrderID=10372 Total=9210.90
CustomerID=QUEEN OrderID=10637 Total=2761.94
CustomerID=QUEEN OrderID=11068 Total=2027.08
CustomerID=QUICK OrderID=10273 Total=2037.28
CustomerID=QUICK OrderID=10286 Total=3016.00
CustomerID=QUICK OrderID=10345 Total=2924.80
CustomerID=QUICK OrderID=10361 Total=2046.24
CustomerID=QUICK OrderID=10451 Total=3849.66
CustomerID=QUICK OrderID=10515 Total=9921.30
CustomerID=QUICK OrderID=10540 Total=10191.70
CustomerID=QUICK OrderID=10549 Total=3554.28
CustomerID=QUICK OrderID=10588 Total=3120.00
CustomerID=QUICK OrderID=10658 Total=4464.60
CustomerID=QUICK OrderID=10691 Total=10164.80
CustomerID=QUICK OrderID=10694 Total=4825.00
CustomerID=QUICK OrderID=10745 Total=4529.80
CustomerID=QUICK OrderID=10845 Total=3812.70
CustomerID=QUICK OrderID=10865 Total=16387.50
CustomerID=QUICK OrderID=10938 Total=2731.88
CustomerID=QUICK OrderID=10962 Total=3584.00
CustomerID=QUICK OrderID=10991 Total=2296.00
CustomerID=QUICK OrderID=11021 Total=6306.24
CustomerID=RATTC OrderID=10314 Total=2094.30
CustomerID=RATTC OrderID=10316 Total=2835.00
CustomerID=RATTC OrderID=10401 Total=3868.60
CustomerID=RATTC OrderID=10479 Total=10495.60
CustomerID=RATTC OrderID=10598 Total=2388.50
CustomerID=RATTC OrderID=10852 Total=2984.00
CustomerID=RATTC OrderID=10889 Total=11380.00
CustomerID=RATTC OrderID=10988 Total=3574.80
CustomerID=RICAR OrderID=10851 Total=2603.00
CustomerID=RICSU OrderID=10255 Total=2490.50
CustomerID=RICSU OrderID=10419 Total=2097.60
CustomerID=RICSU OrderID=10666 Total=4666.94
CustomerID=RICSU OrderID=11033 Total=3232.80
CustomerID=SANTG OrderID=10831 Total=2684.40
CustomerID=SAVEA OrderID=10324 Total=5275.72
CustomerID=SAVEA OrderID=10393 Total=2556.95
CustomerID=SAVEA OrderID=10398 Total=2505.60
CustomerID=SAVEA OrderID=10440 Total=4924.14
CustomerID=SAVEA OrderID=10452 Total=2018.50
CustomerID=SAVEA OrderID=10510 Total=4707.54
CustomerID=SAVEA OrderID=10555 Total=2944.40
CustomerID=SAVEA OrderID=10607 Total=6475.40
CustomerID=SAVEA OrderID=10612 Total=6375.00
CustomerID=SAVEA OrderID=10657 Total=4371.60
CustomerID=SAVEA OrderID=10678 Total=5256.50
CustomerID=SAVEA OrderID=10711 Total=4451.70
CustomerID=SAVEA OrderID=10713 Total=2827.90
CustomerID=SAVEA OrderID=10714 Total=2205.75
CustomerID=SAVEA OrderID=10748 Total=2196.00
CustomerID=SAVEA OrderID=10757 Total=3082.00
CustomerID=SAVEA OrderID=10847 Total=4931.92
CustomerID=SAVEA OrderID=10894 Total=2753.10
CustomerID=SAVEA OrderID=10941 Total=4011.75
CustomerID=SAVEA OrderID=11030 Total=12615.05
CustomerID=SAVEA OrderID=11031 Total=2393.50
CustomerID=SAVEA OrderID=11064 Total=4330.40
CustomerID=SEVES OrderID=10359 Total=3471.68
CustomerID=SEVES OrderID=10523 Total=2444.31
CustomerID=SEVES OrderID=10804 Total=2278.40
CustomerID=SIMOB OrderID=10417 Total=11188.40
CustomerID=SIMOB OrderID=10802 Total=2942.81
CustomerID=SPECD OrderID=10964 Total=2052.50
CustomerID=SPLIR OrderID=10329 Total=4578.43
CustomerID=SPLIR OrderID=10369 Total=2390.40
CustomerID=SUPRD OrderID=10252 Total=3597.90
CustomerID=SUPRD OrderID=10302 Total=2708.80
CustomerID=SUPRD OrderID=10458 Total=3891.00
CustomerID=SUPRD OrderID=10841 Total=4581.00
CustomerID=SUPRD OrderID=10930 Total=2255.50
CustomerID=THEBI OrderID=10805 Total=2775.00
CustomerID=TORTU OrderID=10518 Total=4150.05
CustomerID=VAFFE OrderID=10465 Total=2518.00
CustomerID=VAFFE OrderID=10688 Total=3160.60
CustomerID=VICTE OrderID=10546 Total=2812.00
CustomerID=WARTH OrderID=10455 Total=2684.00
CustomerID=WARTH OrderID=10583 Total=2237.50
CustomerID=WHITC OrderID=10344 Total=2296.00
CustomerID=WHITC OrderID=10693 Total=2071.20
CustomerID=WHITC OrderID=10861 Total=3523.40
CustomerID=WHITC OrderID=11032 Total=8902.50
SelectMany - Multiple from
This sample uses multiple from clauses so that filtering on customers can be done before selecting their orders. This makes the query more efficient by not selecting and then discarding orders for customers outside of Washington.
public void Linq18()
{
List<Customer> customers = GetCustomerList();
DateTime cutoffDate = new DateTime(1997, 1, 1);
var orders =
from c in customers
where c.Region == "WA"
from o in c.Orders
where o.OrderDate >= cutoffDate
select new { c.CustomerID, o.OrderID };
ObjectDumper.Write(orders);
}
Result
CustomerID=LAZYK OrderID=10482
CustomerID=LAZYK OrderID=10545
CustomerID=TRAIH OrderID=10574
CustomerID=TRAIH OrderID=10577
CustomerID=TRAIH OrderID=10822
CustomerID=WHITC OrderID=10469
CustomerID=WHITC OrderID=10483
CustomerID=WHITC OrderID=10504
CustomerID=WHITC OrderID=10596
CustomerID=WHITC OrderID=10693
CustomerID=WHITC OrderID=10696
CustomerID=WHITC OrderID=10723
CustomerID=WHITC OrderID=10740
CustomerID=WHITC OrderID=10861
CustomerID=WHITC OrderID=10904
CustomerID=WHITC OrderID=11032
CustomerID=WHITC OrderID=11066
SelectMany - Indexed
This sample uses an indexed SelectMany clause to select all orders, while referring to customers by the order in which they are returned from the query.
public void Linq19()
{
List<Customer> customers = GetCustomerList();
var customerOrders =
customers.SelectMany(
(cust, custIndex) =>
cust.Orders.Select(o => "Customer #" + (custIndex + 1) +
" has an order with OrderID " + o.OrderID));
ObjectDumper.Write(customerOrders);
}
Result
Customer #1 has an order with OrderID 10643
Customer #1 has an order with OrderID 10692
Customer #1 has an order with OrderID 10702
Customer #1 has an order with OrderID 10835
Customer #1 has an order with OrderID 10952
Customer #1 has an order with OrderID 11011
Customer #2 has an order with OrderID 10308
Customer #2 has an order with OrderID 10625
Customer #2 has an order with OrderID 10759
Customer #2 has an order with OrderID 10926
Customer #3 has an order with OrderID 10365
Customer #3 has an order with OrderID 10507
Customer #3 has an order with OrderID 10535
Customer #3 has an order with OrderID 10573
Customer #3 has an order with OrderID 10677
Customer #3 has an order with OrderID 10682
Customer #3 has an order with OrderID 10856
Customer #4 has an order with OrderID 10355
Customer #4 has an order with OrderID 10383
Customer #4 has an order with OrderID 10453
Customer #4 has an order with OrderID 10558
Customer #4 has an order with OrderID 10707
Customer #4 has an order with OrderID 10741
Customer #4 has an order with OrderID 10743
Customer #4 has an order with OrderID 10768
Customer #4 has an order with OrderID 10793
Customer #4 has an order with OrderID 10864
Customer #4 has an order with OrderID 10920
Customer #4 has an order with OrderID 10953
Customer #4 has an order with OrderID 11016
Customer #5 has an order with OrderID 10278
Customer #5 has an order with OrderID 10280
Customer #5 has an order with OrderID 10384
Customer #5 has an order with OrderID 10444
Customer #5 has an order with OrderID 10445
Customer #5 has an order with OrderID 10524
Customer #5 has an order with OrderID 10572
Customer #5 has an order with OrderID 10626
Customer #5 has an order with OrderID 10654
Customer #5 has an order with OrderID 10672
Customer #5 has an order with OrderID 10689
Customer #5 has an order with OrderID 10733
Customer #5 has an order with OrderID 10778
Customer #5 has an order with OrderID 10837
Customer #5 has an order with OrderID 10857
Customer #5 has an order with OrderID 10866
Customer #5 has an order with OrderID 10875
Customer #5 has an order with OrderID 10924
Customer #6 has an order with OrderID 10501
Customer #6 has an order with OrderID 10509
Customer #6 has an order with OrderID 10582
Customer #6 has an order with OrderID 10614
Customer #6 has an order with OrderID 10853
Customer #6 has an order with OrderID 10956
Customer #6 has an order with OrderID 11058
Customer #7 has an order with OrderID 10265
Customer #7 has an order with OrderID 10297
Customer #7 has an order with OrderID 10360
Customer #7 has an order with OrderID 10436
Customer #7 has an order with OrderID 10449
Customer #7 has an order with OrderID 10559
Customer #7 has an order with OrderID 10566
Customer #7 has an order with OrderID 10584
Customer #7 has an order with OrderID 10628
Customer #7 has an order with OrderID 10679
Customer #7 has an order with OrderID 10826
Customer #8 has an order with OrderID 10326
Customer #8 has an order with OrderID 10801
Customer #8 has an order with OrderID 10970
Customer #9 has an order with OrderID 10331
Customer #9 has an order with OrderID 10340
Customer #9 has an order with OrderID 10362
Customer #9 has an order with OrderID 10470
Customer #9 has an order with OrderID 10511
Customer #9 has an order with OrderID 10525
Customer #9 has an order with OrderID 10663
Customer #9 has an order with OrderID 10715
Customer #9 has an order with OrderID 10730
Customer #9 has an order with OrderID 10732
Customer #9 has an order with OrderID 10755
Customer #9 has an order with OrderID 10827
Customer #9 has an order with OrderID 10871
Customer #9 has an order with OrderID 10876
Customer #9 has an order with OrderID 10932
Customer #9 has an order with OrderID 10940
Customer #9 has an order with OrderID 11076
Customer #10 has an order with OrderID 10389
Customer #10 has an order with OrderID 10410
Customer #10 has an order with OrderID 10411
Customer #10 has an order with OrderID 10431
Customer #10 has an order with OrderID 10492
Customer #10 has an order with OrderID 10742
Customer #10 has an order with OrderID 10918
Customer #10 has an order with OrderID 10944
Customer #10 has an order with OrderID 10949
Customer #10 has an order with OrderID 10975
Customer #10 has an order with OrderID 10982
Customer #10 has an order with OrderID 11027
Customer #10 has an order with OrderID 11045
Customer #10 has an order with OrderID 11048
Customer #11 has an order with OrderID 10289
Customer #11 has an order with OrderID 10471
Customer #11 has an order with OrderID 10484
Customer #11 has an order with OrderID 10538
Customer #11 has an order with OrderID 10539
Customer #11 has an order with OrderID 10578
Customer #11 has an order with OrderID 10599
Customer #11 has an order with OrderID 10943
Customer #11 has an order with OrderID 10947
Customer #11 has an order with OrderID 11023
Customer #12 has an order with OrderID 10521
Customer #12 has an order with OrderID 10782
Customer #12 has an order with OrderID 10819
Customer #12 has an order with OrderID 10881
Customer #12 has an order with OrderID 10937
Customer #12 has an order with OrderID 11054
Customer #13 has an order with OrderID 10259
Customer #14 has an order with OrderID 10254
Customer #14 has an order with OrderID 10370
Customer #14 has an order with OrderID 10519
Customer #14 has an order with OrderID 10731
Customer #14 has an order with OrderID 10746
Customer #14 has an order with OrderID 10966
Customer #14 has an order with OrderID 11029
Customer #14 has an order with OrderID 11041
Customer #15 has an order with OrderID 10290
Customer #15 has an order with OrderID 10466
Customer #15 has an order with OrderID 10494
Customer #15 has an order with OrderID 10969
Customer #15 has an order with OrderID 11042
Customer #16 has an order with OrderID 10435
Customer #16 has an order with OrderID 10462
Customer #16 has an order with OrderID 10848
Customer #17 has an order with OrderID 10363
Customer #17 has an order with OrderID 10391
Customer #17 has an order with OrderID 10797
Customer #17 has an order with OrderID 10825
Customer #17 has an order with OrderID 11036
Customer #17 has an order with OrderID 11067
Customer #18 has an order with OrderID 10311
Customer #18 has an order with OrderID 10609
Customer #18 has an order with OrderID 10683
Customer #18 has an order with OrderID 10890
Customer #19 has an order with OrderID 10364
Customer #19 has an order with OrderID 10400
Customer #19 has an order with OrderID 10532
Customer #19 has an order with OrderID 10726
Customer #19 has an order with OrderID 10987
Customer #19 has an order with OrderID 11024
Customer #19 has an order with OrderID 11047
Customer #19 has an order with OrderID 11056
Customer #20 has an order with OrderID 10258
Customer #20 has an order with OrderID 10263
Customer #20 has an order with OrderID 10351
Customer #20 has an order with OrderID 10368
Customer #20 has an order with OrderID 10382
Customer #20 has an order with OrderID 10390
Customer #20 has an order with OrderID 10402
Customer #20 has an order with OrderID 10403
Customer #20 has an order with OrderID 10430
Customer #20 has an order with OrderID 10442
Customer #20 has an order with OrderID 10514
Customer #20 has an order with OrderID 10571
Customer #20 has an order with OrderID 10595
Customer #20 has an order with OrderID 10633
Customer #20 has an order with OrderID 10667
Customer #20 has an order with OrderID 10698
Customer #20 has an order with OrderID 10764
Customer #20 has an order with OrderID 10771
Customer #20 has an order with OrderID 10773
Customer #20 has an order with OrderID 10776
Customer #20 has an order with OrderID 10795
Customer #20 has an order with OrderID 10836
Customer #20 has an order with OrderID 10854
Customer #20 has an order with OrderID 10895
Customer #20 has an order with OrderID 10968
Customer #20 has an order with OrderID 10979
Customer #20 has an order with OrderID 10990
Customer #20 has an order with OrderID 11008
Customer #20 has an order with OrderID 11017
Customer #20 has an order with OrderID 11072
Customer #21 has an order with OrderID 10347
Customer #21 has an order with OrderID 10386
Customer #21 has an order with OrderID 10414
Customer #21 has an order with OrderID 10512
Customer #21 has an order with OrderID 10581
Customer #21 has an order with OrderID 10650
Customer #21 has an order with OrderID 10725
Customer #23 has an order with OrderID 10408
Customer #23 has an order with OrderID 10480
Customer #23 has an order with OrderID 10634
Customer #23 has an order with OrderID 10763
Customer #23 has an order with OrderID 10789
Customer #24 has an order with OrderID 10264
Customer #24 has an order with OrderID 10327
Customer #24 has an order with OrderID 10378
Customer #24 has an order with OrderID 10434
Customer #24 has an order with OrderID 10460
Customer #24 has an order with OrderID 10533
Customer #24 has an order with OrderID 10561
Customer #24 has an order with OrderID 10703
Customer #24 has an order with OrderID 10762
Customer #24 has an order with OrderID 10774
Customer #24 has an order with OrderID 10824
Customer #24 has an order with OrderID 10880
Customer #24 has an order with OrderID 10902
Customer #24 has an order with OrderID 10955
Customer #24 has an order with OrderID 10977
Customer #24 has an order with OrderID 10980
Customer #24 has an order with OrderID 10993
Customer #24 has an order with OrderID 11001
Customer #24 has an order with OrderID 11050
Customer #25 has an order with OrderID 10267
Customer #25 has an order with OrderID 10337
Customer #25 has an order with OrderID 10342
Customer #25 has an order with OrderID 10396
Customer #25 has an order with OrderID 10488
Customer #25 has an order with OrderID 10560
Customer #25 has an order with OrderID 10623
Customer #25 has an order with OrderID 10653
Customer #25 has an order with OrderID 10670
Customer #25 has an order with OrderID 10675
Customer #25 has an order with OrderID 10717
Customer #25 has an order with OrderID 10791
Customer #25 has an order with OrderID 10859
Customer #25 has an order with OrderID 10929
Customer #25 has an order with OrderID 11012
Customer #26 has an order with OrderID 10671
Customer #26 has an order with OrderID 10860
Customer #26 has an order with OrderID 10971
Customer #27 has an order with OrderID 10422
Customer #27 has an order with OrderID 10710
Customer #27 has an order with OrderID 10753
Customer #27 has an order with OrderID 10807
Customer #27 has an order with OrderID 11026
Customer #27 has an order with OrderID 11060
Customer #28 has an order with OrderID 10328
Customer #28 has an order with OrderID 10352
Customer #28 has an order with OrderID 10464
Customer #28 has an order with OrderID 10491
Customer #28 has an order with OrderID 10551
Customer #28 has an order with OrderID 10604
Customer #28 has an order with OrderID 10664
Customer #28 has an order with OrderID 10963
Customer #29 has an order with OrderID 10366
Customer #29 has an order with OrderID 10426
Customer #29 has an order with OrderID 10568
Customer #29 has an order with OrderID 10887
Customer #29 has an order with OrderID 10928
Customer #30 has an order with OrderID 10303
Customer #30 has an order with OrderID 10550
Customer #30 has an order with OrderID 10629
Customer #30 has an order with OrderID 10872
Customer #30 has an order with OrderID 10874
Customer #30 has an order with OrderID 10888
Customer #30 has an order with OrderID 10911
Customer #30 has an order with OrderID 10948
Customer #30 has an order with OrderID 11009
Customer #30 has an order with OrderID 11037
Customer #31 has an order with OrderID 10423
Customer #31 has an order with OrderID 10652
Customer #31 has an order with OrderID 10685
Customer #31 has an order with OrderID 10709
Customer #31 has an order with OrderID 10734
Customer #31 has an order with OrderID 10777
Customer #31 has an order with OrderID 10790
Customer #31 has an order with OrderID 10959
Customer #31 has an order with OrderID 11049
Customer #32 has an order with OrderID 10528
Customer #32 has an order with OrderID 10589
Customer #32 has an order with OrderID 10616
Customer #32 has an order with OrderID 10617
Customer #32 has an order with OrderID 10656
Customer #32 has an order with OrderID 10681
Customer #32 has an order with OrderID 10816
Customer #32 has an order with OrderID 10936
Customer #32 has an order with OrderID 11006
Customer #32 has an order with OrderID 11040
Customer #32 has an order with OrderID 11061
Customer #33 has an order with OrderID 10268
Customer #33 has an order with OrderID 10785
Customer #34 has an order with OrderID 10250
Customer #34 has an order with OrderID 10253
Customer #34 has an order with OrderID 10541
Customer #34 has an order with OrderID 10645
Customer #34 has an order with OrderID 10690
Customer #34 has an order with OrderID 10770
Customer #34 has an order with OrderID 10783
Customer #34 has an order with OrderID 10886
Customer #34 has an order with OrderID 10903
Customer #34 has an order with OrderID 10922
Customer #34 has an order with OrderID 10925
Customer #34 has an order with OrderID 10981
Customer #34 has an order with OrderID 11022
Customer #34 has an order with OrderID 11052
Customer #35 has an order with OrderID 10257
Customer #35 has an order with OrderID 10395
Customer #35 has an order with OrderID 10476
Customer #35 has an order with OrderID 10486
Customer #35 has an order with OrderID 10490
Customer #35 has an order with OrderID 10498
Customer #35 has an order with OrderID 10552
Customer #35 has an order with OrderID 10601
Customer #35 has an order with OrderID 10613
Customer #35 has an order with OrderID 10641
Customer #35 has an order with OrderID 10705
Customer #35 has an order with OrderID 10796
Customer #35 has an order with OrderID 10863
Customer #35 has an order with OrderID 10901
Customer #35 has an order with OrderID 10957
Customer #35 has an order with OrderID 10960
Customer #35 has an order with OrderID 10976
Customer #35 has an order with OrderID 11055
Customer #36 has an order with OrderID 10375
Customer #36 has an order with OrderID 10394
Customer #36 has an order with OrderID 10415
Customer #36 has an order with OrderID 10600
Customer #36 has an order with OrderID 10660
Customer #37 has an order with OrderID 10298
Customer #37 has an order with OrderID 10309
Customer #37 has an order with OrderID 10335
Customer #37 has an order with OrderID 10373
Customer #37 has an order with OrderID 10380
Customer #37 has an order with OrderID 10429
Customer #37 has an order with OrderID 10503
Customer #37 has an order with OrderID 10516
Customer #37 has an order with OrderID 10567
Customer #37 has an order with OrderID 10646
Customer #37 has an order with OrderID 10661
Customer #37 has an order with OrderID 10687
Customer #37 has an order with OrderID 10701
Customer #37 has an order with OrderID 10712
Customer #37 has an order with OrderID 10736
Customer #37 has an order with OrderID 10897
Customer #37 has an order with OrderID 10912
Customer #37 has an order with OrderID 10985
Customer #37 has an order with OrderID 11063
Customer #38 has an order with OrderID 10315
Customer #38 has an order with OrderID 10318
Customer #38 has an order with OrderID 10321
Customer #38 has an order with OrderID 10473
Customer #38 has an order with OrderID 10621
Customer #38 has an order with OrderID 10674
Customer #38 has an order with OrderID 10749
Customer #38 has an order with OrderID 10798
Customer #38 has an order with OrderID 10829
Customer #38 has an order with OrderID 10933
Customer #39 has an order with OrderID 10323
Customer #39 has an order with OrderID 10325
Customer #39 has an order with OrderID 10456
Customer #39 has an order with OrderID 10457
Customer #39 has an order with OrderID 10468
Customer #39 has an order with OrderID 10506
Customer #39 has an order with OrderID 10542
Customer #39 has an order with OrderID 10630
Customer #39 has an order with OrderID 10718
Customer #39 has an order with OrderID 10799
Customer #39 has an order with OrderID 10817
Customer #39 has an order with OrderID 10849
Customer #39 has an order with OrderID 10893
Customer #39 has an order with OrderID 11028
Customer #40 has an order with OrderID 10858
Customer #40 has an order with OrderID 10927
Customer #40 has an order with OrderID 10972
Customer #40 has an order with OrderID 10973
Customer #41 has an order with OrderID 10350
Customer #41 has an order with OrderID 10358
Customer #41 has an order with OrderID 10371
Customer #41 has an order with OrderID 10413
Customer #41 has an order with OrderID 10425
Customer #41 has an order with OrderID 10454
Customer #41 has an order with OrderID 10493
Customer #41 has an order with OrderID 10500
Customer #41 has an order with OrderID 10610
Customer #41 has an order with OrderID 10631
Customer #41 has an order with OrderID 10787
Customer #41 has an order with OrderID 10832
Customer #41 has an order with OrderID 10923
Customer #41 has an order with OrderID 11051
Customer #42 has an order with OrderID 10495
Customer #42 has an order with OrderID 10620
Customer #42 has an order with OrderID 10810
Customer #43 has an order with OrderID 10482
Customer #43 has an order with OrderID 10545
Customer #44 has an order with OrderID 10279
Customer #44 has an order with OrderID 10284
Customer #44 has an order with OrderID 10343
Customer #44 has an order with OrderID 10497
Customer #44 has an order with OrderID 10522
Customer #44 has an order with OrderID 10534
Customer #44 has an order with OrderID 10536
Customer #44 has an order with OrderID 10557
Customer #44 has an order with OrderID 10592
Customer #44 has an order with OrderID 10593
Customer #44 has an order with OrderID 10772
Customer #44 has an order with OrderID 10862
Customer #44 has an order with OrderID 10891
Customer #44 has an order with OrderID 10934
Customer #44 has an order with OrderID 11070
Customer #45 has an order with OrderID 10579
Customer #45 has an order with OrderID 10719
Customer #45 has an order with OrderID 10735
Customer #45 has an order with OrderID 10884
Customer #46 has an order with OrderID 10283
Customer #46 has an order with OrderID 10296
Customer #46 has an order with OrderID 10330
Customer #46 has an order with OrderID 10357
Customer #46 has an order with OrderID 10381
Customer #46 has an order with OrderID 10461
Customer #46 has an order with OrderID 10499
Customer #46 has an order with OrderID 10543
Customer #46 has an order with OrderID 10780
Customer #46 has an order with OrderID 10823
Customer #46 has an order with OrderID 10899
Customer #46 has an order with OrderID 10997
Customer #46 has an order with OrderID 11065
Customer #46 has an order with OrderID 11071
Customer #47 has an order with OrderID 10405
Customer #47 has an order with OrderID 10485
Customer #47 has an order with OrderID 10638
Customer #47 has an order with OrderID 10697
Customer #47 has an order with OrderID 10729
Customer #47 has an order with OrderID 10811
Customer #47 has an order with OrderID 10838
Customer #47 has an order with OrderID 10840
Customer #47 has an order with OrderID 10919
Customer #47 has an order with OrderID 10954
Customer #47 has an order with OrderID 11014
Customer #47 has an order with OrderID 11039
Customer #48 has an order with OrderID 10307
Customer #48 has an order with OrderID 10317
Customer #48 has an order with OrderID 10544
Customer #48 has an order with OrderID 10662
Customer #48 has an order with OrderID 10665
Customer #48 has an order with OrderID 10867
Customer #48 has an order with OrderID 10883
Customer #48 has an order with OrderID 11018
Customer #49 has an order with OrderID 10275
Customer #49 has an order with OrderID 10300
Customer #49 has an order with OrderID 10404
Customer #49 has an order with OrderID 10467
Customer #49 has an order with OrderID 10635
Customer #49 has an order with OrderID 10754
Customer #49 has an order with OrderID 10784
Customer #49 has an order with OrderID 10818
Customer #49 has an order with OrderID 10939
Customer #49 has an order with OrderID 10950
Customer #50 has an order with OrderID 10529
Customer #50 has an order with OrderID 10649
Customer #50 has an order with OrderID 10760
Customer #50 has an order with OrderID 10892
Customer #50 has an order with OrderID 10896
Customer #50 has an order with OrderID 10978
Customer #50 has an order with OrderID 11004
Customer #51 has an order with OrderID 10332
Customer #51 has an order with OrderID 10339
Customer #51 has an order with OrderID 10376
Customer #51 has an order with OrderID 10424
Customer #51 has an order with OrderID 10439
Customer #51 has an order with OrderID 10505
Customer #51 has an order with OrderID 10565
Customer #51 has an order with OrderID 10570
Customer #51 has an order with OrderID 10590
Customer #51 has an order with OrderID 10605
Customer #51 has an order with OrderID 10618
Customer #51 has an order with OrderID 10619
Customer #51 has an order with OrderID 10724
Customer #52 has an order with OrderID 10277
Customer #52 has an order with OrderID 10575
Customer #52 has an order with OrderID 10699
Customer #52 has an order with OrderID 10779
Customer #52 has an order with OrderID 10945
Customer #53 has an order with OrderID 10517
Customer #53 has an order with OrderID 10752
Customer #53 has an order with OrderID 11057
Customer #54 has an order with OrderID 10409
Customer #54 has an order with OrderID 10531
Customer #54 has an order with OrderID 10898
Customer #54 has an order with OrderID 10958
Customer #54 has an order with OrderID 10986
Customer #55 has an order with OrderID 10260
Customer #55 has an order with OrderID 10305
Customer #55 has an order with OrderID 10338
Customer #55 has an order with OrderID 10441
Customer #55 has an order with OrderID 10594
Customer #55 has an order with OrderID 10680
Customer #55 has an order with OrderID 10706
Customer #55 has an order with OrderID 10855
Customer #55 has an order with OrderID 10965
Customer #55 has an order with OrderID 11034
Customer #56 has an order with OrderID 10407
Customer #56 has an order with OrderID 10508
Customer #56 has an order with OrderID 10554
Customer #56 has an order with OrderID 10580
Customer #56 has an order with OrderID 10684
Customer #56 has an order with OrderID 10766
Customer #56 has an order with OrderID 10833
Customer #56 has an order with OrderID 10999
Customer #56 has an order with OrderID 11020
Customer #58 has an order with OrderID 10322
Customer #58 has an order with OrderID 10354
Customer #58 has an order with OrderID 10474
Customer #58 has an order with OrderID 10502
Customer #58 has an order with OrderID 10995
Customer #58 has an order with OrderID 11073
Customer #59 has an order with OrderID 10353
Customer #59 has an order with OrderID 10392
Customer #59 has an order with OrderID 10427
Customer #59 has an order with OrderID 10489
Customer #59 has an order with OrderID 10530
Customer #59 has an order with OrderID 10597
Customer #59 has an order with OrderID 10686
Customer #59 has an order with OrderID 10747
Customer #59 has an order with OrderID 10844
Customer #59 has an order with OrderID 11053
Customer #60 has an order with OrderID 10336
Customer #60 has an order with OrderID 10397
Customer #60 has an order with OrderID 10433
Customer #60 has an order with OrderID 10477
Customer #60 has an order with OrderID 10808
Customer #60 has an order with OrderID 11007
Customer #61 has an order with OrderID 10261
Customer #61 has an order with OrderID 10291
Customer #61 has an order with OrderID 10379
Customer #61 has an order with OrderID 10421
Customer #61 has an order with OrderID 10587
Customer #61 has an order with OrderID 10647
Customer #61 has an order with OrderID 10720
Customer #61 has an order with OrderID 10794
Customer #61 has an order with OrderID 10989
Customer #62 has an order with OrderID 10372
Customer #62 has an order with OrderID 10406
Customer #62 has an order with OrderID 10487
Customer #62 has an order with OrderID 10637
Customer #62 has an order with OrderID 10659
Customer #62 has an order with OrderID 10704
Customer #62 has an order with OrderID 10728
Customer #62 has an order with OrderID 10786
Customer #62 has an order with OrderID 10868
Customer #62 has an order with OrderID 10913
Customer #62 has an order with OrderID 10914
Customer #62 has an order with OrderID 10961
Customer #62 has an order with OrderID 11068
Customer #63 has an order with OrderID 10273
Customer #63 has an order with OrderID 10285
Customer #63 has an order with OrderID 10286
Customer #63 has an order with OrderID 10313
Customer #63 has an order with OrderID 10345
Customer #63 has an order with OrderID 10361
Customer #63 has an order with OrderID 10418
Customer #63 has an order with OrderID 10451
Customer #63 has an order with OrderID 10515
Customer #63 has an order with OrderID 10527
Customer #63 has an order with OrderID 10540
Customer #63 has an order with OrderID 10549
Customer #63 has an order with OrderID 10588
Customer #63 has an order with OrderID 10658
Customer #63 has an order with OrderID 10691
Customer #63 has an order with OrderID 10694
Customer #63 has an order with OrderID 10721
Customer #63 has an order with OrderID 10745
Customer #63 has an order with OrderID 10765
Customer #63 has an order with OrderID 10788
Customer #63 has an order with OrderID 10845
Customer #63 has an order with OrderID 10865
Customer #63 has an order with OrderID 10878
Customer #63 has an order with OrderID 10938
Customer #63 has an order with OrderID 10962
Customer #63 has an order with OrderID 10991
Customer #63 has an order with OrderID 10996
Customer #63 has an order with OrderID 11021
Customer #64 has an order with OrderID 10448
Customer #64 has an order with OrderID 10716
Customer #64 has an order with OrderID 10828
Customer #64 has an order with OrderID 10916
Customer #64 has an order with OrderID 11019
Customer #65 has an order with OrderID 10262
Customer #65 has an order with OrderID 10272
Customer #65 has an order with OrderID 10294
Customer #65 has an order with OrderID 10314
Customer #65 has an order with OrderID 10316
Customer #65 has an order with OrderID 10346
Customer #65 has an order with OrderID 10401
Customer #65 has an order with OrderID 10479
Customer #65 has an order with OrderID 10564
Customer #65 has an order with OrderID 10569
Customer #65 has an order with OrderID 10598
Customer #65 has an order with OrderID 10761
Customer #65 has an order with OrderID 10820
Customer #65 has an order with OrderID 10852
Customer #65 has an order with OrderID 10889
Customer #65 has an order with OrderID 10988
Customer #65 has an order with OrderID 11000
Customer #65 has an order with OrderID 11077
Customer #66 has an order with OrderID 10288
Customer #66 has an order with OrderID 10428
Customer #66 has an order with OrderID 10443
Customer #66 has an order with OrderID 10562
Customer #66 has an order with OrderID 10586
Customer #66 has an order with OrderID 10655
Customer #66 has an order with OrderID 10727
Customer #66 has an order with OrderID 10812
Customer #66 has an order with OrderID 10908
Customer #66 has an order with OrderID 10942
Customer #66 has an order with OrderID 11010
Customer #66 has an order with OrderID 11062
Customer #67 has an order with OrderID 10287
Customer #67 has an order with OrderID 10299
Customer #67 has an order with OrderID 10447
Customer #67 has an order with OrderID 10481
Customer #67 has an order with OrderID 10563
Customer #67 has an order with OrderID 10622
Customer #67 has an order with OrderID 10648
Customer #67 has an order with OrderID 10813
Customer #67 has an order with OrderID 10851
Customer #67 has an order with OrderID 10877
Customer #67 has an order with OrderID 11059
Customer #68 has an order with OrderID 10255
Customer #68 has an order with OrderID 10419
Customer #68 has an order with OrderID 10537
Customer #68 has an order with OrderID 10666
Customer #68 has an order with OrderID 10751
Customer #68 has an order with OrderID 10758
Customer #68 has an order with OrderID 10931
Customer #68 has an order with OrderID 10951
Customer #68 has an order with OrderID 11033
Customer #68 has an order with OrderID 11075
Customer #69 has an order with OrderID 10281
Customer #69 has an order with OrderID 10282
Customer #69 has an order with OrderID 10306
Customer #69 has an order with OrderID 10917
Customer #69 has an order with OrderID 11013
Customer #70 has an order with OrderID 10387
Customer #70 has an order with OrderID 10520
Customer #70 has an order with OrderID 10639
Customer #70 has an order with OrderID 10831
Customer #70 has an order with OrderID 10909
Customer #70 has an order with OrderID 11015
Customer #71 has an order with OrderID 10324
Customer #71 has an order with OrderID 10393
Customer #71 has an order with OrderID 10398
Customer #71 has an order with OrderID 10440
Customer #71 has an order with OrderID 10452
Customer #71 has an order with OrderID 10510
Customer #71 has an order with OrderID 10555
Customer #71 has an order with OrderID 10603
Customer #71 has an order with OrderID 10607
Customer #71 has an order with OrderID 10612
Customer #71 has an order with OrderID 10627
Customer #71 has an order with OrderID 10657
Customer #71 has an order with OrderID 10678
Customer #71 has an order with OrderID 10700
Customer #71 has an order with OrderID 10711
Customer #71 has an order with OrderID 10713
Customer #71 has an order with OrderID 10714
Customer #71 has an order with OrderID 10722
Customer #71 has an order with OrderID 10748
Customer #71 has an order with OrderID 10757
Customer #71 has an order with OrderID 10815
Customer #71 has an order with OrderID 10847
Customer #71 has an order with OrderID 10882
Customer #71 has an order with OrderID 10894
Customer #71 has an order with OrderID 10941
Customer #71 has an order with OrderID 10983
Customer #71 has an order with OrderID 10984
Customer #71 has an order with OrderID 11002
Customer #71 has an order with OrderID 11030
Customer #71 has an order with OrderID 11031
Customer #71 has an order with OrderID 11064
Customer #72 has an order with OrderID 10359
Customer #72 has an order with OrderID 10377
Customer #72 has an order with OrderID 10388
Customer #72 has an order with OrderID 10472
Customer #72 has an order with OrderID 10523
Customer #72 has an order with OrderID 10547
Customer #72 has an order with OrderID 10800
Customer #72 has an order with OrderID 10804
Customer #72 has an order with OrderID 10869
Customer #73 has an order with OrderID 10341
Customer #73 has an order with OrderID 10417
Customer #73 has an order with OrderID 10556
Customer #73 has an order with OrderID 10642
Customer #73 has an order with OrderID 10669
Customer #73 has an order with OrderID 10802
Customer #73 has an order with OrderID 11074
Customer #74 has an order with OrderID 10738
Customer #74 has an order with OrderID 10907
Customer #74 has an order with OrderID 10964
Customer #74 has an order with OrderID 11043
Customer #75 has an order with OrderID 10271
Customer #75 has an order with OrderID 10329
Customer #75 has an order with OrderID 10349
Customer #75 has an order with OrderID 10369
Customer #75 has an order with OrderID 10385
Customer #75 has an order with OrderID 10432
Customer #75 has an order with OrderID 10756
Customer #75 has an order with OrderID 10821
Customer #75 has an order with OrderID 10974
Customer #76 has an order with OrderID 10252
Customer #76 has an order with OrderID 10302
Customer #76 has an order with OrderID 10458
Customer #76 has an order with OrderID 10463
Customer #76 has an order with OrderID 10475
Customer #76 has an order with OrderID 10767
Customer #76 has an order with OrderID 10841
Customer #76 has an order with OrderID 10846
Customer #76 has an order with OrderID 10885
Customer #76 has an order with OrderID 10930
Customer #76 has an order with OrderID 11035
Customer #76 has an order with OrderID 11038
Customer #77 has an order with OrderID 10310
Customer #77 has an order with OrderID 10708
Customer #77 has an order with OrderID 10805
Customer #77 has an order with OrderID 10992
Customer #78 has an order with OrderID 10624
Customer #78 has an order with OrderID 10775
Customer #78 has an order with OrderID 11003
Customer #79 has an order with OrderID 10438
Customer #79 has an order with OrderID 10446
Customer #79 has an order with OrderID 10548
Customer #79 has an order with OrderID 10608
Customer #79 has an order with OrderID 10967
Customer #80 has an order with OrderID 10276
Customer #80 has an order with OrderID 10293
Customer #80 has an order with OrderID 10304
Customer #80 has an order with OrderID 10319
Customer #80 has an order with OrderID 10518
Customer #80 has an order with OrderID 10576
Customer #80 has an order with OrderID 10676
Customer #80 has an order with OrderID 10842
Customer #80 has an order with OrderID 10915
Customer #80 has an order with OrderID 11069
Customer #81 has an order with OrderID 10249
Customer #81 has an order with OrderID 10292
Customer #81 has an order with OrderID 10496
Customer #81 has an order with OrderID 10606
Customer #81 has an order with OrderID 10830
Customer #81 has an order with OrderID 10834
Customer #81 has an order with OrderID 10839
Customer #82 has an order with OrderID 10574
Customer #82 has an order with OrderID 10577
Customer #82 has an order with OrderID 10822
Customer #83 has an order with OrderID 10367
Customer #83 has an order with OrderID 10399
Customer #83 has an order with OrderID 10465
Customer #83 has an order with OrderID 10591
Customer #83 has an order with OrderID 10602
Customer #83 has an order with OrderID 10688
Customer #83 has an order with OrderID 10744
Customer #83 has an order with OrderID 10769
Customer #83 has an order with OrderID 10921
Customer #83 has an order with OrderID 10946
Customer #83 has an order with OrderID 10994
Customer #84 has an order with OrderID 10251
Customer #84 has an order with OrderID 10334
Customer #84 has an order with OrderID 10450
Customer #84 has an order with OrderID 10459
Customer #84 has an order with OrderID 10478
Customer #84 has an order with OrderID 10546
Customer #84 has an order with OrderID 10806
Customer #84 has an order with OrderID 10814
Customer #84 has an order with OrderID 10843
Customer #84 has an order with OrderID 10850
Customer #85 has an order with OrderID 10274
Customer #85 has an order with OrderID 10295
Customer #85 has an order with OrderID 10737
Customer #85 has an order with OrderID 10739
Customer #86 has an order with OrderID 10301
Customer #86 has an order with OrderID 10312
Customer #86 has an order with OrderID 10348
Customer #86 has an order with OrderID 10356
Customer #86 has an order with OrderID 10513
Customer #86 has an order with OrderID 10632
Customer #86 has an order with OrderID 10640
Customer #86 has an order with OrderID 10651
Customer #86 has an order with OrderID 10668
Customer #86 has an order with OrderID 11046
Customer #87 has an order with OrderID 10266
Customer #87 has an order with OrderID 10270
Customer #87 has an order with OrderID 10320
Customer #87 has an order with OrderID 10333
Customer #87 has an order with OrderID 10412
Customer #87 has an order with OrderID 10416
Customer #87 has an order with OrderID 10437
Customer #87 has an order with OrderID 10455
Customer #87 has an order with OrderID 10526
Customer #87 has an order with OrderID 10553
Customer #87 has an order with OrderID 10583
Customer #87 has an order with OrderID 10636
Customer #87 has an order with OrderID 10750
Customer #87 has an order with OrderID 10781
Customer #87 has an order with OrderID 11025
Customer #88 has an order with OrderID 10256
Customer #88 has an order with OrderID 10420
Customer #88 has an order with OrderID 10585
Customer #88 has an order with OrderID 10644
Customer #88 has an order with OrderID 10803
Customer #88 has an order with OrderID 10809
Customer #88 has an order with OrderID 10900
Customer #88 has an order with OrderID 10905
Customer #88 has an order with OrderID 10935
Customer #89 has an order with OrderID 10269
Customer #89 has an order with OrderID 10344
Customer #89 has an order with OrderID 10469
Customer #89 has an order with OrderID 10483
Customer #89 has an order with OrderID 10504
Customer #89 has an order with OrderID 10596
Customer #89 has an order with OrderID 10693
Customer #89 has an order with OrderID 10696
Customer #89 has an order with OrderID 10723
Customer #89 has an order with OrderID 10740
Customer #89 has an order with OrderID 10861
Customer #89 has an order with OrderID 10904
Customer #89 has an order with OrderID 11032
Customer #89 has an order with OrderID 11066
Customer #90 has an order with OrderID 10248
Customer #90 has an order with OrderID 10615
Customer #90 has an order with OrderID 10673
Customer #90 has an order with OrderID 10695
Customer #90 has an order with OrderID 10873
Customer #90 has an order with OrderID 10879
Customer #90 has an order with OrderID 10910
Customer #90 has an order with OrderID 11005
Customer #91 has an order with OrderID 10374
Customer #91 has an order with OrderID 10611
Customer #91 has an order with OrderID 10792
Customer #91 has an order with OrderID 10870
Customer #91 has an order with OrderID 10906
Customer #91 has an order with OrderID 10998
Customer #91 has an order with OrderID 11044