LINQ To SQL Samples - ORDER BY |
This sample uses orderby to sort Employees by hire date.
Public Sub LinqToSqlOrderBy01()
Dim q = From e In db.Employees _
Order By e.HireDate _
Select e
ObjectDumper.Write(q)
End Sub
Result:
EmployeeID=3 LastName=Leverling FirstName=Janet Title=Sales Representative TitleOfCourtesy=Ms. BirthDate=8/30/1963 HireDate=4/1/1992 Address=722 Moss Bay Blvd. City=Kirkland Region=WA PostalCode=98033 Country=USA HomePhone=(206) 555-3412 Extension=3355 Photo=... Notes=Janet has a BS degree in chemistry from Boston College (1984). She has also completed a certificate program in food retailing management. Janet was hired as a sales associate in 1991 and promoted to sales representative in February 1992. ReportsTo=2 PhotoPath=http://accweb/emmployees/leverling.bmp Orders=... EmployeeTerritories=... Employees=... Employee={ }
EmployeeID=1 LastName=Davolio FirstName=Nancy Title=Sales Representative TitleOfCourtesy=Ms. BirthDate=12/8/1948 HireDate=5/1/1992 Address=507 - 20th Ave. E.
Apt. 2A City=Seattle Region=WA PostalCode=98122 Country=USA HomePhone=(206) 555-9857 Extension=5467 Photo=... Notes=Education includes a BA in psychology from Colorado State University in 1970. She also completed "The Art of the Cold Call." Nancy is a member of Toastmasters International. ReportsTo=2 PhotoPath=http://accweb/emmployees/davolio.bmp Orders=... EmployeeTerritories=... Employees=... Employee={ }
EmployeeID=2 LastName=Fuller FirstName=Andrew Title=Vice President, Sales TitleOfCourtesy=Dr. BirthDate=2/19/1952 HireDate=8/14/1992 Address=908 W. Capital Way City=Tacoma Region=WA PostalCode=98401 Country=USA HomePhone=(206) 555-9482 Extension=3457 Photo=... Notes=Andrew received his BTS commercial in 1974 and a Ph.D. in international marketing from the University of Dallas in 1981. He is fluent in French and Italian and reads German. He joined the company as a sales representative, was promoted to sales manager in January 1992 and to vice president of sales in March 1993. Andrew is a member of the Sales Management Roundtable, the Seattle Chamber of Commerce, and the Pacific Rim Importers Association. ReportsTo=null PhotoPath=http://accweb/emmployees/fuller.bmp Orders=... EmployeeTerritories=... Employees=... Employee={ }
EmployeeID=4 LastName=Peacock FirstName=Margaret Title=Sales Representative TitleOfCourtesy=Mrs. BirthDate=9/19/1937 HireDate=5/3/1993 Address=4110 Old Redmond Rd. City=Redmond Region=WA PostalCode=98052 Country=USA HomePhone=(206) 555-8122 Extension=5176 Photo=... Notes=Margaret holds a BA in English literature from Concordia College (1958) and an MA from the American Institute of Culinary Arts (1966). She was assigned to the London office temporarily from July through November 1992. ReportsTo=2 PhotoPath=http://accweb/emmployees/peacock.bmp Orders=... EmployeeTerritories=... Employees=... Employee={ }
EmployeeID=5 LastName=Buchanan FirstName=Steven Title=Sales Manager TitleOfCourtesy=Mr. BirthDate=3/4/1955 HireDate=10/17/1993 Address=14 Garrett Hill City=London Region=null PostalCode=SW1 8JR Country=UK HomePhone=(71) 555-4848 Extension=3453 Photo=... Notes=Steven Buchanan graduated from St. Andrews University, Scotland, with a BSC degree in 1976. Upon joining the company as a sales representative in 1992, he spent 6 months in an orientation program at the Seattle office and then returned to his permanent post in London. He was promoted to sales manager in March 1993. Mr. Buchanan has completed the courses "Successful Telemarketing" and "International Sales Management." He is fluent in French. ReportsTo=2 PhotoPath=http://accweb/emmployees/buchanan.bmp Orders=... EmployeeTerritories=... Employees=... Employee={ }
EmployeeID=6 LastName=Suyama FirstName=Michael Title=Sales Representative TitleOfCourtesy=Mr. BirthDate=7/2/1963 HireDate=10/17/1993 Address=Coventry House
Miner Rd. City=London Region=null PostalCode=EC2 7JR Country=UK HomePhone=(71) 555-7773 Extension=428 Photo=... Notes=Michael is a graduate of Sussex University (MA, economics, 1983) and the University of California at Los Angeles (MBA, marketing, 1986). He has also taken the courses "Multi-Cultural Selling" and "Time Management for the Sales Professional." He is fluent in Japanese and can read and write French, Portuguese, and Spanish. ReportsTo=5 PhotoPath=http://accweb/emmployees/davolio.bmp Orders=... EmployeeTerritories=... Employees=... Employee={ }
EmployeeID=7 LastName=King FirstName=Robert Title=Sales Representative TitleOfCourtesy=Mr. BirthDate=5/29/1960 HireDate=1/2/1994 Address=Edgeham Hollow
Winchester Way City=London Region=null PostalCode=RG1 9SP Country=UK HomePhone=(71) 555-5598 Extension=465 Photo=... Notes=Robert King served in the Peace Corps and traveled extensively before completing his degree in English at the University of Michigan in 1992, the year he joined the company. After completing a course entitled "Selling in Europe," he was transferred to the London office in March 1993. ReportsTo=5 PhotoPath=http://accweb/emmployees/davolio.bmp Orders=... EmployeeTerritories=... Employees=... Employee={ }
EmployeeID=8 LastName=Callahan FirstName=Laura Title=Inside Sales Coordinator TitleOfCourtesy=Ms. BirthDate=1/9/1958 HireDate=3/5/1994 Address=4726 - 11th Ave. N.E. City=Seattle Region=WA PostalCode=98105 Country=USA HomePhone=(206) 555-1189 Extension=2344 Photo=... Notes=Laura received a BA in psychology from the University of Washington. She has also completed a course in business French. She reads and writes French. ReportsTo=2 PhotoPath=http://accweb/emmployees/davolio.bmp Orders=... EmployeeTerritories=... Employees=... Employee={ }
EmployeeID=9 LastName=Dodsworth FirstName=Anne Title=Sales Representative TitleOfCourtesy=Ms. BirthDate=1/27/1966 HireDate=11/15/1994 Address=7 Houndstooth Rd. City=London Region=null PostalCode=WG2 7LT Country=UK HomePhone=(71) 555-4444 Extension=452 Photo=... Notes=Anne has a BA degree in English from St. Lawrence College. She is fluent in French and German. ReportsTo=5 PhotoPath=http://accweb/emmployees/davolio.bmp Orders=... EmployeeTerritories=... Employees=... Employee={ }
This sample uses where and orderby to sort Orders shipped to London by freight.
Public Sub LinqToSqlOrderBy02()
Dim q = From o In db.Orders _
Where o.ShipCity = "London" _
Order By o.Freight
ObjectDumper.Write(q)
End Sub
Result:
OrderID=10752 CustomerID=NORTS EmployeeID=2 OrderDate=11/24/1997 RequiredDate=12/22/1997 ShippedDate=11/28/1997 ShipVia=3 Freight=1.3900 ShipName=North/South ShipAddress=South House 300 Queensbridge ShipCity=London ShipRegion=null ShipPostalCode=SW7 1RZ ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10943 CustomerID=BSBEV EmployeeID=4 OrderDate=3/11/1998 RequiredDate=4/8/1998 ShippedDate=3/19/1998 ShipVia=2 Freight=2.1700 ShipName=B's Beverages ShipAddress=Fauntleroy Circus ShipCity=London ShipRegion=null ShipPostalCode=EC2 5NT ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10947 CustomerID=BSBEV EmployeeID=3 OrderDate=3/13/1998 RequiredDate=4/10/1998 ShippedDate=3/16/1998 ShipVia=2 Freight=3.2600 ShipName=B's Beverages ShipAddress=Fauntleroy Circus ShipCity=London ShipRegion=null ShipPostalCode=EC2 5NT ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=11057 CustomerID=NORTS EmployeeID=3 OrderDate=4/29/1998 RequiredDate=5/27/1998 ShippedDate=5/1/1998 ShipVia=3 Freight=4.1300 ShipName=North/South ShipAddress=South House 300 Queensbridge ShipCity=London ShipRegion=null ShipPostalCode=SW7 1RZ ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10472 CustomerID=SEVES EmployeeID=8 OrderDate=3/12/1997 RequiredDate=4/9/1997 ShippedDate=3/19/1997 ShipVia=1 Freight=4.2000 ShipName=Seven Seas Imports ShipAddress=90 Wadhurst Rd. ShipCity=London ShipRegion=null ShipPostalCode=OX15 4NB ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10538 CustomerID=BSBEV EmployeeID=9 OrderDate=5/15/1997 RequiredDate=6/12/1997 ShippedDate=5/16/1997 ShipVia=3 Freight=4.8700 ShipName=B's Beverages ShipAddress=Fauntleroy Circus ShipCity=London ShipRegion=null ShipPostalCode=EC2 5NT ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10462 CustomerID=CONSH EmployeeID=2 OrderDate=3/3/1997 RequiredDate=3/31/1997 ShippedDate=3/18/1997 ShipVia=1 Freight=6.1700 ShipName=Consolidated Holdings ShipAddress=Berkeley Gardens 12 Brewery ShipCity=London ShipRegion=null ShipPostalCode=WX1 6LT ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10484 CustomerID=BSBEV EmployeeID=3 OrderDate=3/24/1997 RequiredDate=4/21/1997 ShippedDate=4/1/1997 ShipVia=3 Freight=6.8800 ShipName=B's Beverages ShipAddress=Fauntleroy Circus ShipCity=London ShipRegion=null ShipPostalCode=EC2 5NT ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10435 CustomerID=CONSH EmployeeID=8 OrderDate=2/4/1997 RequiredDate=3/18/1997 ShippedDate=2/7/1997 ShipVia=2 Freight=9.2100 ShipName=Consolidated Holdings ShipAddress=Berkeley Gardens 12 Brewery ShipCity=London ShipRegion=null ShipPostalCode=WX1 6LT ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10539 CustomerID=BSBEV EmployeeID=6 OrderDate=5/16/1997 RequiredDate=6/13/1997 ShippedDate=5/23/1997 ShipVia=3 Freight=12.3600 ShipName=B's Beverages ShipAddress=Fauntleroy Circus ShipCity=London ShipRegion=null ShipPostalCode=EC2 5NT ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10726 CustomerID=EASTC EmployeeID=4 OrderDate=11/3/1997 RequiredDate=11/17/1997 ShippedDate=12/5/1997 ShipVia=1 Freight=16.5600 ShipName=Eastern Connection ShipAddress=35 King George ShipCity=London ShipRegion=null ShipPostalCode=WX3 6FW ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10377 CustomerID=SEVES EmployeeID=1 OrderDate=12/9/1996 RequiredDate=1/6/1997 ShippedDate=12/13/1996 ShipVia=3 Freight=22.2100 ShipName=Seven Seas Imports ShipAddress=90 Wadhurst Rd. ShipCity=London ShipRegion=null ShipPostalCode=OX15 4NB ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10289 CustomerID=BSBEV EmployeeID=7 OrderDate=8/26/1996 RequiredDate=9/23/1996 ShippedDate=8/28/1996 ShipVia=3 Freight=22.7700 ShipName=B's Beverages ShipAddress=Fauntleroy Circus ShipCity=London ShipRegion=null ShipPostalCode=EC2 5NT ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10804 CustomerID=SEVES EmployeeID=6 OrderDate=12/30/1997 RequiredDate=1/27/1998 ShippedDate=1/7/1998 ShipVia=2 Freight=27.3300 ShipName=Seven Seas Imports ShipAddress=90 Wadhurst Rd. ShipCity=London ShipRegion=null ShipPostalCode=OX15 4NB ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10578 CustomerID=BSBEV EmployeeID=4 OrderDate=6/24/1997 RequiredDate=7/22/1997 ShippedDate=7/25/1997 ShipVia=3 Freight=29.6000 ShipName=B's Beverages ShipAddress=Fauntleroy Circus ShipCity=London ShipRegion=null ShipPostalCode=EC2 5NT ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10599 CustomerID=BSBEV EmployeeID=6 OrderDate=7/15/1997 RequiredDate=8/26/1997 ShippedDate=7/21/1997 ShipVia=3 Freight=29.9800 ShipName=B's Beverages ShipAddress=Fauntleroy Circus ShipCity=London ShipRegion=null ShipPostalCode=EC2 5NT ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10517 CustomerID=NORTS EmployeeID=3 OrderDate=4/24/1997 RequiredDate=5/22/1997 ShippedDate=4/29/1997 ShipVia=3 Freight=32.0700 ShipName=North/South ShipAddress=South House 300 Queensbridge ShipCity=London ShipRegion=null ShipPostalCode=SW7 1RZ ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10388 CustomerID=SEVES EmployeeID=2 OrderDate=12/19/1996 RequiredDate=1/16/1997 ShippedDate=12/20/1996 ShipVia=1 Freight=34.8600 ShipName=Seven Seas Imports ShipAddress=90 Wadhurst Rd. ShipCity=London ShipRegion=null ShipPostalCode=OX15 4NB ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10848 CustomerID=CONSH EmployeeID=7 OrderDate=1/23/1998 RequiredDate=2/20/1998 ShippedDate=1/29/1998 ShipVia=2 Freight=38.2400 ShipName=Consolidated Holdings ShipAddress=Berkeley Gardens 12 Brewery ShipCity=London ShipRegion=null ShipPostalCode=WX1 6LT ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10471 CustomerID=BSBEV EmployeeID=2 OrderDate=3/11/1997 RequiredDate=4/8/1997 ShippedDate=3/18/1997 ShipVia=3 Freight=45.5900 ShipName=B's Beverages ShipAddress=Fauntleroy Circus ShipCity=London ShipRegion=null ShipPostalCode=EC2 5NT ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=11047 CustomerID=EASTC EmployeeID=7 OrderDate=4/24/1998 RequiredDate=5/22/1998 ShippedDate=5/1/1998 ShipVia=3 Freight=46.6200 ShipName=Eastern Connection ShipAddress=35 King George ShipCity=London ShipRegion=null ShipPostalCode=WX3 6FW ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10364 CustomerID=EASTC EmployeeID=1 OrderDate=11/26/1996 RequiredDate=1/7/1997 ShippedDate=12/4/1996 ShipVia=1 Freight=71.9700 ShipName=Eastern Connection ShipAddress=35 King George ShipCity=London ShipRegion=null ShipPostalCode=WX3 6FW ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=11024 CustomerID=EASTC EmployeeID=4 OrderDate=4/15/1998 RequiredDate=5/13/1998 ShippedDate=4/20/1998 ShipVia=1 Freight=74.3600 ShipName=Eastern Connection ShipAddress=35 King George ShipCity=London ShipRegion=null ShipPostalCode=WX3 6FW ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10532 CustomerID=EASTC EmployeeID=7 OrderDate=5/9/1997 RequiredDate=6/6/1997 ShippedDate=5/12/1997 ShipVia=3 Freight=74.4600 ShipName=Eastern Connection ShipAddress=35 King George ShipCity=London ShipRegion=null ShipPostalCode=WX3 6FW ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10523 CustomerID=SEVES EmployeeID=7 OrderDate=5/1/1997 RequiredDate=5/29/1997 ShippedDate=5/30/1997 ShipVia=2 Freight=77.6300 ShipName=Seven Seas Imports ShipAddress=90 Wadhurst Rd. ShipCity=London ShipRegion=null ShipPostalCode=OX15 4NB ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10400 CustomerID=EASTC EmployeeID=1 OrderDate=1/1/1997 RequiredDate=1/29/1997 ShippedDate=1/16/1997 ShipVia=3 Freight=83.9300 ShipName=Eastern Connection ShipAddress=35 King George ShipCity=London ShipRegion=null ShipPostalCode=WX3 6FW ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=11023 CustomerID=BSBEV EmployeeID=1 OrderDate=4/14/1998 RequiredDate=4/28/1998 ShippedDate=4/24/1998 ShipVia=2 Freight=123.8300 ShipName=B's Beverages ShipAddress=Fauntleroy Circus ShipCity=London ShipRegion=null ShipPostalCode=EC2 5NT ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10800 CustomerID=SEVES EmployeeID=1 OrderDate=12/26/1997 RequiredDate=1/23/1998 ShippedDate=1/5/1998 ShipVia=3 Freight=137.4400 ShipName=Seven Seas Imports ShipAddress=90 Wadhurst Rd. ShipCity=London ShipRegion=null ShipPostalCode=OX15 4NB ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10869 CustomerID=SEVES EmployeeID=5 OrderDate=2/4/1998 RequiredDate=3/4/1998 ShippedDate=2/9/1998 ShipVia=1 Freight=143.2800 ShipName=Seven Seas Imports ShipAddress=90 Wadhurst Rd. ShipCity=London ShipRegion=null ShipPostalCode=OX15 4NB ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10547 CustomerID=SEVES EmployeeID=3 OrderDate=5/23/1997 RequiredDate=6/20/1997 ShippedDate=6/2/1997 ShipVia=2 Freight=178.4300 ShipName=Seven Seas Imports ShipAddress=90 Wadhurst Rd. ShipCity=London ShipRegion=null ShipPostalCode=OX15 4NB ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10987 CustomerID=EASTC EmployeeID=8 OrderDate=3/31/1998 RequiredDate=4/28/1998 ShippedDate=4/6/1998 ShipVia=1 Freight=185.4800 ShipName=Eastern Connection ShipAddress=35 King George ShipCity=London ShipRegion=null ShipPostalCode=WX3 6FW ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=11056 CustomerID=EASTC EmployeeID=8 OrderDate=4/28/1998 RequiredDate=5/12/1998 ShippedDate=5/1/1998 ShipVia=2 Freight=278.9600 ShipName=Eastern Connection ShipAddress=35 King George ShipCity=London ShipRegion=null ShipPostalCode=WX3 6FW ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10359 CustomerID=SEVES EmployeeID=5 OrderDate=11/21/1996 RequiredDate=12/19/1996 ShippedDate=11/26/1996 ShipVia=3 Freight=288.4300 ShipName=Seven Seas Imports ShipAddress=90 Wadhurst Rd. ShipCity=London ShipRegion=null ShipPostalCode=OX15 4NB ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
b
This sample uses orderby to sort Products by unit price from highest to lowest.
Public Sub LinqToSqlOrderBy03()
Dim q = From p In db.Products _
Order By p.UnitPrice Descending _
Select p
ObjectDumper.Write(q)
End Sub
Result:
ProductID=38 ProductName=Côte de Blaye SupplierID=18 CategoryID=1 QuantityPerUnit=12 - 75 cl bottles UnitPrice=264.5000 UnitsInStock=17 UnitsOnOrder=0 ReorderLevel=15 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=29 ProductName=Thüringer Rostbratwurst SupplierID=12 CategoryID=6 QuantityPerUnit=50 bags x 30 sausgs. UnitPrice=124.7900 UnitsInStock=0 UnitsOnOrder=0 ReorderLevel=0 Discontinued=True Order_Details=... Category={ } Supplier={ }
ProductID=9 ProductName=Mishi Kobe Niku SupplierID=4 CategoryID=6 QuantityPerUnit=18 - 500 g pkgs. UnitPrice=98.0000 UnitsInStock=29 UnitsOnOrder=0 ReorderLevel=0 Discontinued=True Order_Details=... Category={ } Supplier={ }
ProductID=20 ProductName=Sir Rodney's Marmalade SupplierID=8 CategoryID=3 QuantityPerUnit=30 gift boxes UnitPrice=82.0000 UnitsInStock=40 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=18 ProductName=Carnarvon Tigers SupplierID=7 CategoryID=8 QuantityPerUnit=16 kg pkg. UnitPrice=63.5000 UnitsInStock=42 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=59 ProductName=Raclette Courdavault SupplierID=28 CategoryID=4 QuantityPerUnit=5 kg pkg. UnitPrice=56.0000 UnitsInStock=79 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=51 ProductName=Manjimup Dried Apples SupplierID=24 CategoryID=7 QuantityPerUnit=50 - 300 g pkgs. UnitPrice=54.0000 UnitsInStock=20 UnitsOnOrder=0 ReorderLevel=10 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=62 ProductName=Tarte au sucre SupplierID=29 CategoryID=3 QuantityPerUnit=48 pies UnitPrice=50.3000 UnitsInStock=17 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=43 ProductName=Ipoh Coffee SupplierID=20 CategoryID=1 QuantityPerUnit=16 - 500 g tins UnitPrice=47.0000 UnitsInStock=17 UnitsOnOrder=10 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=28 ProductName=Rössle Sauerkraut SupplierID=12 CategoryID=7 QuantityPerUnit=25 - 825 g cans UnitPrice=46.6000 UnitsInStock=26 UnitsOnOrder=0 ReorderLevel=0 Discontinued=True Order_Details=... Category={ } Supplier={ }
ProductID=27 ProductName=Schoggi Schokolade SupplierID=11 CategoryID=3 QuantityPerUnit=100 - 100 g pieces UnitPrice=44.9000 UnitsInStock=49 UnitsOnOrder=0 ReorderLevel=30 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=63 ProductName=Vegie-spread SupplierID=7 CategoryID=2 QuantityPerUnit=15 - 625 g jars UnitPrice=44.9000 UnitsInStock=24 UnitsOnOrder=0 ReorderLevel=5 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=8 ProductName=Northwoods Cranberry Sauce SupplierID=3 CategoryID=2 QuantityPerUnit=12 - 12 oz jars UnitPrice=41.0000 UnitsInStock=6 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=17 ProductName=Alice Mutton SupplierID=7 CategoryID=6 QuantityPerUnit=20 - 1 kg tins UnitPrice=40.0000 UnitsInStock=0 UnitsOnOrder=0 ReorderLevel=0 Discontinued=True Order_Details=... Category={ } Supplier={ }
ProductID=12 ProductName=Queso Manchego La Pastora SupplierID=5 CategoryID=4 QuantityPerUnit=10 - 500 g pkgs. UnitPrice=39.0000 UnitsInStock=86 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=56 ProductName=Gnocchi di nonna Alice SupplierID=26 CategoryID=5 QuantityPerUnit=24 - 250 g pkgs. UnitPrice=39.0000 UnitsInStock=21 UnitsOnOrder=10 ReorderLevel=30 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=69 ProductName=Gudbrandsdalsost SupplierID=15 CategoryID=4 QuantityPerUnit=10 kg pkg. UnitPrice=37.0000 UnitsInStock=26 UnitsOnOrder=0 ReorderLevel=15 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=72 ProductName=Mozzarella di Giovanni SupplierID=14 CategoryID=4 QuantityPerUnit=24 - 200 g pkgs. UnitPrice=35.8000 UnitsInStock=14 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=60 ProductName=Camembert Pierrot SupplierID=28 CategoryID=4 QuantityPerUnit=15 - 300 g rounds UnitPrice=35.0000 UnitsInStock=19 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=64 ProductName=Wimmers gute Semmelknödel SupplierID=12 CategoryID=5 QuantityPerUnit=20 bags x 4 pieces UnitPrice=34.2500 UnitsInStock=22 UnitsOnOrder=80 ReorderLevel=30 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=53 ProductName=Perth Pasties SupplierID=24 CategoryID=6 QuantityPerUnit=48 pieces UnitPrice=33.8000 UnitsInStock=0 UnitsOnOrder=0 ReorderLevel=0 Discontinued=True Order_Details=... Category={ } Supplier={ }
ProductID=32 ProductName=Mascarpone Fabioli SupplierID=14 CategoryID=4 QuantityPerUnit=24 - 200 g pkgs. UnitPrice=33.0000 UnitsInStock=9 UnitsOnOrder=40 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=26 ProductName=Gumbär Gummibärchen SupplierID=11 CategoryID=3 QuantityPerUnit=100 - 250 g bags UnitPrice=32.2300 UnitsInStock=15 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=10 ProductName=Ikura SupplierID=4 CategoryID=8 QuantityPerUnit=12 - 200 ml jars UnitPrice=32.0000 UnitsInStock=31 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=7 ProductName=Uncle Bob's Organic Dried Pears SupplierID=3 CategoryID=7 QuantityPerUnit=12 - 1 lb pkgs. UnitPrice=31.0000 UnitsInStock=15 UnitsOnOrder=0 ReorderLevel=10 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=61 ProductName=Sirop d'érable SupplierID=29 CategoryID=2 QuantityPerUnit=24 - 500 ml bottles UnitPrice=29.5000 UnitsInStock=113 UnitsOnOrder=0 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=37 ProductName=Gravad lax SupplierID=17 CategoryID=8 QuantityPerUnit=12 - 500 g pkgs. UnitPrice=27.0000 UnitsInStock=11 UnitsOnOrder=50 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=30 ProductName=Nord-Ost Matjeshering SupplierID=13 CategoryID=8 QuantityPerUnit=10 - 200 g glasses UnitPrice=26.8900 UnitsInStock=10 UnitsOnOrder=0 ReorderLevel=15 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=6 ProductName=Grandma's Boysenberry Spread SupplierID=3 CategoryID=2 QuantityPerUnit=12 - 8 oz jars UnitPrice=26.0000 UnitsInStock=120 UnitsOnOrder=0 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=55 ProductName=Pâté chinois SupplierID=25 CategoryID=6 QuantityPerUnit=24 boxes x 2 pies UnitPrice=25.0000 UnitsInStock=115 UnitsOnOrder=0 ReorderLevel=20 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=14 ProductName=Tofu SupplierID=6 CategoryID=7 QuantityPerUnit=40 - 100 g pkgs. UnitPrice=24.2500 UnitsInStock=35 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=71 ProductName=Flotemysost SupplierID=15 CategoryID=4 QuantityPerUnit=10 - 500 g pkgs. UnitPrice=22.5000 UnitsInStock=26 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=5 ProductName=Chef Anton's Gumbo Mix SupplierID=2 CategoryID=2 QuantityPerUnit=36 boxes UnitPrice=22.3500 UnitsInStock=0 UnitsOnOrder=0 ReorderLevel=0 Discontinued=True Order_Details=... Category={ } Supplier={ }
ProductID=65 ProductName=Louisiana Fiery Hot Pepper Sauce SupplierID=2 CategoryID=2 QuantityPerUnit=32 - 8 oz bottles UnitPrice=22.0500 UnitsInStock=76 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=4 ProductName=Chef Anton's Cajun Seasoning SupplierID=2 CategoryID=2 QuantityPerUnit=48 - 6 oz jars UnitPrice=22.0000 UnitsInStock=53 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=11 ProductName=Queso Cabrales SupplierID=5 CategoryID=4 QuantityPerUnit=1 kg pkg. UnitPrice=22.0000 UnitsInStock=22 UnitsOnOrder=30 ReorderLevel=30 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=22 ProductName=Gustaf's Knäckebröd SupplierID=9 CategoryID=5 QuantityPerUnit=24 - 500 g pkgs. UnitPrice=22.0000 UnitsInStock=104 UnitsOnOrder=0 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=49 ProductName=Maxilaku SupplierID=23 CategoryID=3 QuantityPerUnit=24 - 50 g pkgs. UnitPrice=21.0000 UnitsInStock=10 UnitsOnOrder=60 ReorderLevel=15 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=57 ProductName=Ravioli Angelo SupplierID=26 CategoryID=5 QuantityPerUnit=24 - 250 g pkgs. UnitPrice=20.5000 UnitsInStock=36 UnitsOnOrder=0 ReorderLevel=20 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=44 ProductName=Gula Malacca SupplierID=20 CategoryID=2 QuantityPerUnit=20 - 2 kg bags UnitPrice=20.4500 UnitsInStock=27 UnitsOnOrder=0 ReorderLevel=15 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=36 ProductName=Inlagd Sill SupplierID=17 CategoryID=8 QuantityPerUnit=24 - 250 g jars UnitPrice=20.0000 UnitsInStock=112 UnitsOnOrder=0 ReorderLevel=20 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=40 ProductName=Boston Crab Meat SupplierID=19 CategoryID=8 QuantityPerUnit=24 - 4 oz tins UnitPrice=19.4000 UnitsInStock=123 UnitsOnOrder=0 ReorderLevel=30 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=39 ProductName=Chartreuse verte SupplierID=18 CategoryID=1 QuantityPerUnit=750 cc per bottle UnitPrice=19.0000 UnitsInStock=69 UnitsOnOrder=0 ReorderLevel=5 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=35 ProductName=Steeleye Stout SupplierID=16 CategoryID=1 QuantityPerUnit=24 - 12 oz bottles UnitPrice=19.0000 UnitsInStock=20 UnitsOnOrder=0 ReorderLevel=15 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=2 ProductName=Chang SupplierID=1 CategoryID=1 QuantityPerUnit=24 - 12 oz bottles UnitPrice=19.0000 UnitsInStock=17 UnitsOnOrder=40 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=76 ProductName=Lakkalikööri SupplierID=23 CategoryID=1 QuantityPerUnit=500 ml UnitPrice=19.0000 UnitsInStock=57 UnitsOnOrder=0 ReorderLevel=20 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=16 ProductName=Pavlova SupplierID=7 CategoryID=3 QuantityPerUnit=32 - 500 g boxes UnitPrice=18.4500 UnitsInStock=29 UnitsOnOrder=0 ReorderLevel=10 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=1 ProductName=Chai SupplierID=1 CategoryID=1 QuantityPerUnit=10 boxes x 20 bags UnitPrice=18.0000 UnitsInStock=39 UnitsOnOrder=0 ReorderLevel=10 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=66 ProductName=Louisiana Hot Spiced Okra SupplierID=2 CategoryID=2 QuantityPerUnit=24 - 8 oz jars UnitPrice=18.0000 UnitsInStock=4 UnitsOnOrder=100 ReorderLevel=20 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=50 ProductName=Valkoinen suklaa SupplierID=23 CategoryID=3 QuantityPerUnit=12 - 100 g bars UnitPrice=17.2500 UnitsInStock=65 UnitsOnOrder=0 ReorderLevel=30 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=15 ProductName=Genen Shouyu SupplierID=6 CategoryID=2 QuantityPerUnit=24 - 250 ml bottles UnitPrice=16.5000 UnitsInStock=39 UnitsOnOrder=0 ReorderLevel=5 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=70 ProductName=Outback Lager SupplierID=7 CategoryID=1 QuantityPerUnit=24 - 355 ml bottles UnitPrice=16.0000 UnitsInStock=15 UnitsOnOrder=10 ReorderLevel=30 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=73 ProductName=Röd Kaviar SupplierID=17 CategoryID=8 QuantityPerUnit=24 - 150 g jars UnitPrice=16.0000 UnitsInStock=101 UnitsOnOrder=0 ReorderLevel=5 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=67 ProductName=Laughing Lumberjack Lager SupplierID=16 CategoryID=1 QuantityPerUnit=24 - 12 oz bottles UnitPrice=15.0000 UnitsInStock=52 UnitsOnOrder=0 ReorderLevel=10 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=42 ProductName=Singaporean Hokkien Fried Mee SupplierID=20 CategoryID=5 QuantityPerUnit=32 - 1 kg pkgs. UnitPrice=15.0000 UnitsInStock=26 UnitsOnOrder=0 ReorderLevel=0 Discontinued=True Order_Details=... Category={ } Supplier={ }
ProductID=34 ProductName=Sasquatch Ale SupplierID=16 CategoryID=1 QuantityPerUnit=24 - 12 oz bottles UnitPrice=15.0000 UnitsInStock=111 UnitsOnOrder=0 ReorderLevel=15 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=25 ProductName=NuNuCa Nuß-Nougat-Creme SupplierID=11 CategoryID=3 QuantityPerUnit=20 - 450 g glasses UnitPrice=15.0000 UnitsInStock=76 UnitsOnOrder=0 ReorderLevel=30 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=58 ProductName=Escargots de Bourgogne SupplierID=27 CategoryID=8 QuantityPerUnit=24 pieces UnitPrice=14.2500 UnitsInStock=62 UnitsOnOrder=0 ReorderLevel=20 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=77 ProductName=Original Frankfurter grüne Soße SupplierID=12 CategoryID=2 QuantityPerUnit=12 boxes UnitPrice=14.0000 UnitsInStock=32 UnitsOnOrder=0 ReorderLevel=15 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=48 ProductName=Chocolade SupplierID=22 CategoryID=3 QuantityPerUnit=10 pkgs. UnitPrice=13.7500 UnitsInStock=15 UnitsOnOrder=70 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=68 ProductName=Scottish Longbreads SupplierID=8 CategoryID=3 QuantityPerUnit=10 boxes x 8 pieces UnitPrice=13.5000 UnitsInStock=6 UnitsOnOrder=10 ReorderLevel=15 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=31 ProductName=Gorgonzola Telino SupplierID=14 CategoryID=4 QuantityPerUnit=12 - 100 g pkgs UnitPrice=13.5000 UnitsInStock=0 UnitsOnOrder=70 ReorderLevel=20 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=46 ProductName=Spegesild SupplierID=21 CategoryID=8 QuantityPerUnit=4 - 450 g glasses UnitPrice=13.0000 UnitsInStock=95 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=74 ProductName=Longlife Tofu SupplierID=4 CategoryID=7 QuantityPerUnit=5 kg pkg. UnitPrice=11.0000 UnitsInStock=4 UnitsOnOrder=20 ReorderLevel=5 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=21 ProductName=Sir Rodney's Scones SupplierID=8 CategoryID=3 QuantityPerUnit=24 pkgs. x 4 pieces UnitPrice=11.0000 UnitsInStock=3 UnitsOnOrder=40 ReorderLevel=5 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=41 ProductName=Jack's New England Clam Chowder SupplierID=19 CategoryID=8 QuantityPerUnit=12 - 12 oz cans UnitPrice=10.6500 UnitsInStock=85 UnitsOnOrder=0 ReorderLevel=10 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=45 ProductName=Rogede sild SupplierID=21 CategoryID=8 QuantityPerUnit=1k pkg. UnitPrice=10.5000 UnitsInStock=5 UnitsOnOrder=70 ReorderLevel=15 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=47 ProductName=Zaanse koeken SupplierID=22 CategoryID=3 QuantityPerUnit=10 - 4 oz boxes UnitPrice=10.5000 UnitsInStock=36 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=19 ProductName=Teatime Chocolate Biscuits SupplierID=8 CategoryID=3 QuantityPerUnit=10 boxes x 12 pieces UnitPrice=10.2000 UnitsInStock=25 UnitsOnOrder=0 ReorderLevel=5 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=23 ProductName=Tunnbröd SupplierID=9 CategoryID=5 QuantityPerUnit=12 - 250 g pkgs. UnitPrice=10.0000 UnitsInStock=61 UnitsOnOrder=0 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=3 ProductName=Aniseed Syrup SupplierID=1 CategoryID=2 QuantityPerUnit=12 - 550 ml bottles UnitPrice=10.0000 UnitsInStock=13 UnitsOnOrder=70 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=75 ProductName=Rhönbräu Klosterbier SupplierID=12 CategoryID=1 QuantityPerUnit=24 - 0.5 l bottles UnitPrice=8.7500 UnitsInStock=125 UnitsOnOrder=0 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=54 ProductName=Tourtière SupplierID=25 CategoryID=6 QuantityPerUnit=16 pies UnitPrice=8.4500 UnitsInStock=21 UnitsOnOrder=0 ReorderLevel=10 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=52 ProductName=Filo Mix SupplierID=24 CategoryID=5 QuantityPerUnit=16 - 2 kg boxes UnitPrice=8.0000 UnitsInStock=38 UnitsOnOrder=0 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=13 ProductName=Konbu SupplierID=6 CategoryID=8 QuantityPerUnit=2 kg box UnitPrice=7.0000 UnitsInStock=24 UnitsOnOrder=0 ReorderLevel=5 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=24 ProductName=Guaraná Fantástica SupplierID=10 CategoryID=1 QuantityPerUnit=12 - 355 ml cans UnitPrice=5.5000 UnitsInStock=20 UnitsOnOrder=0 ReorderLevel=0 Discontinued=True Order_Details=... Category={ } Supplier={ }
ProductID=33 ProductName=Geitost SupplierID=15 CategoryID=4 QuantityPerUnit=500 g UnitPrice=3.5000 UnitsInStock=112 UnitsOnOrder=0 ReorderLevel=20 Discontinued=False Order_Details=... Category={ } Supplier={ }
This sample uses a compound orderby to sort Customers by city and then contact name.
Public Sub LinqToSqlOrderBy04()
Dim q = From c In db.Customers _
Select c _
Order By c.City, c.ContactName
ObjectDumper.Write(q)
End Sub
Result:
CustomerID=DRACD CompanyName=Drachenblut Delikatessen ContactName=Sven Ottlieb ContactTitle=Order Administrator Address=Walserweg 21 City=Aachen Region=null PostalCode=52066 Country=Germany Phone=0241-039123 Fax=0241-059428 Orders=... CustomerCustomerDemos=...
CustomerID=RATTC CompanyName=Rattlesnake Canyon Grocery ContactName=Paula Wilson ContactTitle=Assistant Sales Representative Address=2817 Milton Dr. City=Albuquerque Region=NM PostalCode=87110 Country=USA Phone=(505) 555-5939 Fax=(505) 555-3620 Orders=... CustomerCustomerDemos=...
CustomerID=OLDWO CompanyName=Old World Delicatessen ContactName=Rene Phillips ContactTitle=Sales Representative Address=2743 Bering St. City=Anchorage Region=AK PostalCode=99508 Country=USA Phone=(907) 555-7584 Fax=(907) 555-2880 Orders=... CustomerCustomerDemos=...
CustomerID=VAFFE CompanyName=Vaffeljernet ContactName=Palle Ibsen ContactTitle=Sales Manager Address=Smagsloget 45 City=Århus Region=null PostalCode=8200 Country=Denmark Phone=86 21 32 43 Fax=86 22 33 44 Orders=... CustomerCustomerDemos=...
CustomerID=GALED CompanyName=Galería del gastrónomo ContactName=Eduardo Saavedra ContactTitle=Marketing Manager Address=Rambla de Cataluña, 23 City=Barcelona Region=null PostalCode=08022 Country=Spain Phone=(93) 203 4560 Fax=(93) 203 4561 Orders=... CustomerCustomerDemos=...
CustomerID=LILAS CompanyName=LILA-Supermercado ContactName=Carlos González ContactTitle=Accounting Manager Address=Carrera 52 con Ave. Bolívar #65-98 Llano Largo City=Barquisimeto Region=Lara PostalCode=3508 Country=Venezuela Phone=(9) 331-6954 Fax=(9) 331-7256 Orders=... CustomerCustomerDemos=...
CustomerID=MAGAA CompanyName=Magazzini Alimentari Riuniti ContactName=Giovanni Rovelli ContactTitle=Marketing Manager Address=Via Ludovico il Moro 22 City=Bergamo Region=null PostalCode=24100 Country=Italy Phone=035-640230 Fax=035-640231 Orders=... CustomerCustomerDemos=...
CustomerID=ALFKI CompanyName=Alfreds Futterkiste ContactName=Maria Anders ContactTitle=Sales Representative Address=Obere Str. 57 City=Berlin Region=null PostalCode=12209 Country=Germany Phone=030-0074321 Fax=030-0076545 Orders=... CustomerCustomerDemos=...
CustomerID=CHOPS CompanyName=Chop-suey Chinese ContactName=Yang Wang ContactTitle=Owner Address=Hauptstr. 29 City=Bern Region=null PostalCode=3012 Country=Switzerland Phone=0452-076545 Fax=null Orders=... CustomerCustomerDemos=...
CustomerID=SAVEA CompanyName=Save-a-lot Markets ContactName=Jose Pavarotti ContactTitle=Sales Representative Address=187 Suffolk Ln. City=Boise Region=ID PostalCode=83720 Country=USA Phone=(208) 555-8097 Fax=null Orders=... CustomerCustomerDemos=...
CustomerID=FOLKO CompanyName=Folk och fä HB ContactName=Maria Larsson ContactTitle=Owner Address=Åkergatan 24 City=Bräcke Region=null PostalCode=S-844 67 Country=Sweden Phone=0695-34 67 21 Fax=null Orders=... CustomerCustomerDemos=...
CustomerID=KOENE CompanyName=Königlich Essen ContactName=Philip Cramer ContactTitle=Sales Associate Address=Maubelstr. 90 City=Brandenburg Region=null PostalCode=14776 Country=Germany Phone=0555-09876 Fax=null Orders=... CustomerCustomerDemos=...
CustomerID=MAISD CompanyName=Maison Dewey ContactName=Catherine Dewey ContactTitle=Sales Agent Address=Rue Joseph-Bens 532 City=Bruxelles Region=null PostalCode=B-1180 Country=Belgium Phone=(02) 201 24 67 Fax=(02) 201 24 68 Orders=... CustomerCustomerDemos=...
CustomerID=CACTU CompanyName=Cactus Comidas para llevar ContactName=Patricio Simpson ContactTitle=Sales Agent Address=Cerrito 333 City=Buenos Aires Region=null PostalCode=1010 Country=Argentina Phone=(1) 135-5555 Fax=(1) 135-4892 Orders=... CustomerCustomerDemos=...
CustomerID=RANCH CompanyName=Rancho grande ContactName=Sergio Gutiérrez ContactTitle=Sales Representative Address=Av. del Libertador 900 City=Buenos Aires Region=null PostalCode=1010 Country=Argentina Phone=(1) 123-5555 Fax=(1) 123-5556 Orders=... CustomerCustomerDemos=...
CustomerID=OCEAN CompanyName=Océano Atlántico Ltda. ContactName=Yvonne Moncada ContactTitle=Sales Agent Address=Ing. Gustavo Moncada 8585 Piso 20-A City=Buenos Aires Region=null PostalCode=1010 Country=Argentina Phone=(1) 135-5333 Fax=(1) 135-5535 Orders=... CustomerCustomerDemos=...
CustomerID=THECR CompanyName=The Cracker Box ContactName=Liu Wong ContactTitle=Marketing Assistant Address=55 Grizzly Peak Rd. City=Butte Region=MT PostalCode=59801 Country=USA Phone=(406) 555-5834 Fax=(406) 555-8083 Orders=... CustomerCustomerDemos=...
CustomerID=GOURL CompanyName=Gourmet Lanchonetes ContactName=André Fonseca ContactTitle=Sales Associate Address=Av. Brasil, 442 City=Campinas Region=SP PostalCode=04876-786 Country=Brazil Phone=(11) 555-9482 Fax=null Orders=... CustomerCustomerDemos=...
CustomerID=GROSR CompanyName=GROSELLA-Restaurante ContactName=Manuel Pereira ContactTitle=Owner Address=5ª Ave. Los Palos Grandes City=Caracas Region=DF PostalCode=1081 Country=Venezuela Phone=(2) 283-2951 Fax=(2) 283-3397 Orders=... CustomerCustomerDemos=...
CustomerID=SUPRD CompanyName=Suprêmes délices ContactName=Pascale Cartrain ContactTitle=Accounting Manager Address=Boulevard Tirou, 255 City=Charleroi Region=null PostalCode=B-6000 Country=Belgium Phone=(071) 23 67 22 20 Fax=(071) 23 67 22 21 Orders=... CustomerCustomerDemos=...
CustomerID=HUNGO CompanyName=Hungry Owl All-Night Grocers ContactName=Patricia McKenna ContactTitle=Sales Associate Address=8 Johnstown Road City=Cork Region=Co. Cork PostalCode=null Country=Ireland Phone=2967 542 Fax=2967 3333 Orders=... CustomerCustomerDemos=...
CustomerID=ISLAT CompanyName=Island Trading ContactName=Helen Bennett ContactTitle=Marketing Manager Address=Garden House Crowther Way City=Cowes Region=Isle of Wight PostalCode=PO31 7PJ Country=UK Phone=(198) 555-8888 Fax=null Orders=... CustomerCustomerDemos=...
CustomerID=QUICK CompanyName=QUICK-Stop ContactName=Horst Kloss ContactTitle=Accounting Manager Address=Taucherstraße 10 City=Cunewalde Region=null PostalCode=01307 Country=Germany Phone=0372-035188 Fax=null Orders=... CustomerCustomerDemos=...
CustomerID=HUNGC CompanyName=Hungry Coyote Import Store ContactName=Yoshi Latimer ContactTitle=Sales Representative Address=City Center Plaza 516 Main St. City=Elgin Region=OR PostalCode=97827 Country=USA Phone=(503) 555-6874 Fax=(503) 555-2376 Orders=... CustomerCustomerDemos=...
CustomerID=GREAL CompanyName=Great Lakes Food Market ContactName=Howard Snyder ContactTitle=Marketing Manager Address=2732 Baker Blvd. City=Eugene Region=OR PostalCode=97403 Country=USA Phone=(503) 555-7555 Fax=null Orders=... CustomerCustomerDemos=...
CustomerID=LEHMS CompanyName=Lehmanns Marktstand ContactName=Renate Messner ContactTitle=Sales Representative Address=Magazinweg 7 City=Frankfurt a.M. Region=null PostalCode=60528 Country=Germany Phone=069-0245984 Fax=069-0245874 Orders=... CustomerCustomerDemos=...
CustomerID=RICSU CompanyName=Richter Supermarkt ContactName=Michael Holz ContactTitle=Sales Manager Address=Grenzacherweg 237 City=Genève Region=null PostalCode=1203 Country=Switzerland Phone=0897-034214 Fax=null Orders=... CustomerCustomerDemos=...
CustomerID=ERNSH CompanyName=Ernst Handel ContactName=Roland Mendel ContactTitle=Sales Manager Address=Kirchgasse 6 City=Graz Region=null PostalCode=8010 Country=Austria Phone=7675-3425 Fax=7675-3426 Orders=... CustomerCustomerDemos=...
CustomerID=WILMK CompanyName=Wilman Kala ContactName=Matti Karttunen ContactTitle=Owner/Marketing Assistant Address=Keskuskatu 45 City=Helsinki Region=null PostalCode=21240 Country=Finland Phone=90-224 8858 Fax=90-224 8858 Orders=... CustomerCustomerDemos=...
CustomerID=LINOD CompanyName=LINO-Delicateses ContactName=Felipe Izquierdo ContactTitle=Owner Address=Ave. 5 de Mayo Porlamar City=I. de Margarita Region=Nueva Esparta PostalCode=4980 Country=Venezuela Phone=(8) 34-56-12 Fax=(8) 34-93-93 Orders=... CustomerCustomerDemos=...
CustomerID=TRAIH CompanyName=Trail's Head Gourmet Provisioners ContactName=Helvetius Nagy ContactTitle=Sales Associate Address=722 DaVinci Blvd. City=Kirkland Region=WA PostalCode=98034 Country=USA Phone=(206) 555-8257 Fax=(206) 555-2174 Orders=... CustomerCustomerDemos=...
CustomerID=SIMOB CompanyName=Simons bistro ContactName=Jytte Petersen ContactTitle=Owner Address=Vinbæltet 34 City=Kobenhavn Region=null PostalCode=1734 Country=Denmark Phone=31 12 34 56 Fax=31 13 35 57 Orders=... CustomerCustomerDemos=...
CustomerID=OTTIK CompanyName=Ottilies Käseladen ContactName=Henriette Pfalzheim ContactTitle=Owner Address=Mehrheimerstr. 369 City=Köln Region=null PostalCode=50739 Country=Germany Phone=0221-0644327 Fax=0221-0765721 Orders=... CustomerCustomerDemos=...
CustomerID=SPLIR CompanyName=Split Rail Beer & Ale ContactName=Art Braunschweiger ContactTitle=Sales Manager Address=P.O. Box 555 City=Lander Region=WY PostalCode=82520 Country=USA Phone=(307) 555-4680 Fax=(307) 555-6525 Orders=... CustomerCustomerDemos=...
CustomerID=MORGK CompanyName=Morgenstern Gesundkost ContactName=Alexander Feuer ContactTitle=Marketing Assistant Address=Heerstr. 22 City=Leipzig Region=null PostalCode=04179 Country=Germany Phone=0342-023176 Fax=null Orders=... CustomerCustomerDemos=...
CustomerID=FOLIG CompanyName=Folies gourmandes ContactName=Martine Rancé ContactTitle=Assistant Sales Agent Address=184, chaussée de Tournai City=Lille Region=null PostalCode=59000 Country=France Phone=20.16.10.16 Fax=20.16.10.17 Orders=... CustomerCustomerDemos=...
CustomerID=PRINI CompanyName=Princesa Isabel Vinhos ContactName=Isabel de Castro ContactTitle=Sales Representative Address=Estrada da saúde n. 58 City=Lisboa Region=null PostalCode=1756 Country=Portugal Phone=(1) 356-5634 Fax=null Orders=... CustomerCustomerDemos=...
CustomerID=FURIB CompanyName=Furia Bacalhau e Frutos do Mar ContactName=Lino Rodriguez ContactTitle=Sales Manager Address=Jardim das rosas n. 32 City=Lisboa Region=null PostalCode=1675 Country=Portugal Phone=(1) 354-2534 Fax=(1) 354-2535 Orders=... CustomerCustomerDemos=...
CustomerID=EASTC CompanyName=Eastern Connection ContactName=Ann Devon ContactTitle=Sales Agent Address=35 King George City=London Region=null PostalCode=WX3 6FW Country=UK Phone=(171) 555-0297 Fax=(171) 555-3373 Orders=... CustomerCustomerDemos=...
CustomerID=CONSH CompanyName=Consolidated Holdings ContactName=Elizabeth Brown ContactTitle=Sales Representative Address=Berkeley Gardens 12 Brewery City=London Region=null PostalCode=WX1 6LT Country=UK Phone=(171) 555-2282 Fax=(171) 555-9199 Orders=... CustomerCustomerDemos=...
CustomerID=SEVES CompanyName=Seven Seas Imports ContactName=Hari Kumar ContactTitle=Sales Manager Address=90 Wadhurst Rd. City=London Region=null PostalCode=OX15 4NB Country=UK Phone=(171) 555-1717 Fax=(171) 555-5646 Orders=... CustomerCustomerDemos=...
CustomerID=NORTS CompanyName=North/South ContactName=Simon Crowther ContactTitle=Sales Associate Address=South House 300 Queensbridge City=London Region=null PostalCode=SW7 1RZ Country=UK Phone=(171) 555-7733 Fax=(171) 555-2530 Orders=... CustomerCustomerDemos=...
CustomerID=AROUT CompanyName=Around the Horn ContactName=Thomas Hardy ContactTitle=Sales Representative Address=120 Hanover Sq. City=London Region=null PostalCode=WA1 1DP Country=UK Phone=(171) 555-7788 Fax=(171) 555-6750 Orders=... CustomerCustomerDemos=...
CustomerID=BSBEV CompanyName=B's Beverages ContactName=Victoria Ashworth ContactTitle=Sales Representative Address=Fauntleroy Circus City=London Region=null PostalCode=EC2 5NT Country=UK Phone=(171) 555-1212 Fax=null Orders=... CustomerCustomerDemos=...
CustomerID=BERGS CompanyName=Berglunds snabbköp ContactName=Christina Berglund ContactTitle=Order Administrator Address=Berguvsvägen 8 City=Luleå Region=null PostalCode=S-958 22 Country=Sweden Phone=0921-12 34 65 Fax=0921-12 34 67 Orders=... CustomerCustomerDemos=...
CustomerID=VICTE CompanyName=Victuailles en stock ContactName=Mary Saveley ContactTitle=Sales Agent Address=2, rue du Commerce City=Lyon Region=null PostalCode=69004 Country=France Phone=78.32.54.86 Fax=78.32.54.87 Orders=... CustomerCustomerDemos=...
CustomerID=ROMEY CompanyName=Romero y tomillo ContactName=Alejandra Camino ContactTitle=Accounting Manager Address=Gran Vía, 1 City=Madrid Region=null PostalCode=28001 Country=Spain Phone=(91) 745 6200 Fax=(91) 745 6210 Orders=... CustomerCustomerDemos=...
CustomerID=FISSA CompanyName=FISSA Fabrica Inter. Salchichas S.A. ContactName=Diego Roel ContactTitle=Accounting Manager Address=C/ Moralzarzal, 86 City=Madrid Region=null PostalCode=28034 Country=Spain Phone=(91) 555 94 44 Fax=(91) 555 55 93 Orders=... CustomerCustomerDemos=...
CustomerID=BOLID CompanyName=Bólido Comidas preparadas ContactName=Martín Sommer ContactTitle=Owner Address=C/ Araquil, 67 City=Madrid Region=null PostalCode=28023 Country=Spain Phone=(91) 555 22 82 Fax=(91) 555 91 99 Orders=... CustomerCustomerDemos=...
CustomerID=BLAUS CompanyName=Blauer See Delikatessen ContactName=Hanna Moos ContactTitle=Sales Representative Address=Forsterstr. 57 City=Mannheim Region=null PostalCode=68306 Country=Germany Phone=0621-08460 Fax=0621-08924 Orders=... CustomerCustomerDemos=...
CustomerID=BONAP CompanyName=Bon app' ContactName=Laurence Lebihan ContactTitle=Owner Address=12, rue des Bouchers City=Marseille Region=null PostalCode=13008 Country=France Phone=91.24.45.40 Fax=91.24.45.41 Orders=... CustomerCustomerDemos=...
CustomerID=ANATR CompanyName=Ana Trujillo Emparedados y helados ContactName=Ana Trujillo ContactTitle=Owner Address=Avda. de la Constitución 2222 City=México D.F. Region=null PostalCode=05021 Country=Mexico Phone=(5) 555-4729 Fax=(5) 555-3745 Orders=... CustomerCustomerDemos=...
CustomerID=ANTON CompanyName=Antonio Moreno Taquería ContactName=Antonio Moreno ContactTitle=Owner Address=Mataderos 2312 City=México D.F. Region=null PostalCode=05023 Country=Mexico Phone=(5) 555-3932 Fax=null Orders=... CustomerCustomerDemos=...
CustomerID=CENTC CompanyName=Centro comercial Moctezuma ContactName=Francisco Chang ContactTitle=Marketing Manager Address=Sierras de Granada 9993 City=México D.F. Region=null PostalCode=05022 Country=Mexico Phone=(5) 555-3392 Fax=(5) 555-7293 Orders=... CustomerCustomerDemos=...
CustomerID=PERIC CompanyName=Pericles Comidas clásicas ContactName=Guillermo Fernández ContactTitle=Sales Representative Address=Calle Dr. Jorge Cash 321 City=México D.F. Region=null PostalCode=05033 Country=Mexico Phone=(5) 552-3745 Fax=(5) 545-3745 Orders=... CustomerCustomerDemos=...
CustomerID=TORTU CompanyName=Tortuga Restaurante ContactName=Miguel Angel Paolino ContactTitle=Owner Address=Avda. Azteca 123 City=México D.F. Region=null PostalCode=05033 Country=Mexico Phone=(5) 555-2933 Fax=null Orders=... CustomerCustomerDemos=...
CustomerID=MEREP CompanyName=Mère Paillarde ContactName=Jean Fresnière ContactTitle=Marketing Assistant Address=43 rue St. Laurent City=Montréal Region=Québec PostalCode=H1J 1C3 Country=Canada Phone=(514) 555-8054 Fax=(514) 555-8055 Orders=... CustomerCustomerDemos=...
CustomerID=FRANK CompanyName=Frankenversand ContactName=Peter Franken ContactTitle=Marketing Manager Address=Berliner Platz 43 City=München Region=null PostalCode=80805 Country=Germany Phone=089-0877310 Fax=089-0877451 Orders=... CustomerCustomerDemos=...
CustomerID=TOMSP CompanyName=Toms Spezialitäten ContactName=Karin Josephs ContactTitle=Marketing Manager Address=Luisenstr. 48 City=Münster Region=null PostalCode=44087 Country=Germany Phone=0251-031259 Fax=0251-035695 Orders=... CustomerCustomerDemos=...
CustomerID=FRANR CompanyName=France restauration ContactName=Carine Schmitt ContactTitle=Marketing Manager Address=54, rue Royale City=Nantes Region=null PostalCode=44000 Country=France Phone=40.32.21.21 Fax=40.32.21.20 Orders=... CustomerCustomerDemos=...
CustomerID=DUMON CompanyName=Du monde entier ContactName=Janine Labrune ContactTitle=Owner Address=67, rue des Cinquante Otages City=Nantes Region=null PostalCode=44000 Country=France Phone=40.67.88.88 Fax=40.67.89.89 Orders=... CustomerCustomerDemos=...
CustomerID=WARTH CompanyName=Wartian Herkku ContactName=Pirkko Koskitalo ContactTitle=Accounting Manager Address=Torikatu 38 City=Oulu Region=null PostalCode=90110 Country=Finland Phone=981-443655 Fax=981-443655 Orders=... CustomerCustomerDemos=...
CustomerID=SPECD CompanyName=Spécialités du monde ContactName=Dominique Perrier ContactTitle=Marketing Manager Address=25, rue Lauriston City=Paris Region=null PostalCode=75016 Country=France Phone=(1) 47.55.60.10 Fax=(1) 47.55.60.20 Orders=... CustomerCustomerDemos=...
CustomerID=PARIS CompanyName=Paris spécialités ContactName=Marie Bertrand ContactTitle=Owner Address=265, boulevard Charonne City=Paris Region=null PostalCode=75012 Country=France Phone=(1) 42.34.22.66 Fax=(1) 42.34.22.77 Orders=... CustomerCustomerDemos=...
CustomerID=LONEP CompanyName=Lonesome Pine Restaurant ContactName=Fran Wilson ContactTitle=Sales Manager Address=89 Chiaroscuro Rd. City=Portland Region=OR PostalCode=97219 Country=USA Phone=(503) 555-9573 Fax=(503) 555-9646 Orders=... CustomerCustomerDemos=...
CustomerID=THEBI CompanyName=The Big Cheese ContactName=Liz Nixon ContactTitle=Marketing Manager Address=89 Jefferson Way Suite 2 City=Portland Region=OR PostalCode=97201 Country=USA Phone=(503) 555-3612 Fax=null Orders=... CustomerCustomerDemos=...
CustomerID=REGGC CompanyName=Reggiani Caseifici ContactName=Maurizio Moroni ContactTitle=Sales Associate Address=Strada Provinciale 124 City=Reggio Emilia Region=null PostalCode=42100 Country=Italy Phone=0522-556721 Fax=0522-556722 Orders=... CustomerCustomerDemos=...
CustomerID=VINET CompanyName=Vins et alcools Chevalier ContactName=Paul Henriot ContactTitle=Accounting Manager Address=59 rue de l'Abbaye City=Reims Region=null PostalCode=51100 Country=France Phone=26.47.15.10 Fax=26.47.15.11 Orders=... CustomerCustomerDemos=...
CustomerID=WELLI CompanyName=Wellington Importadora ContactName=Paula Parente ContactTitle=Sales Manager Address=Rua do Mercado, 12 City=Resende Region=SP PostalCode=08737-363 Country=Brazil Phone=(14) 555-8122 Fax=null Orders=... CustomerCustomerDemos=...
CustomerID=QUEDE CompanyName=Que Delícia ContactName=Bernardo Batista ContactTitle=Accounting Manager Address=Rua da Panificadora, 12 City=Rio de Janeiro Region=RJ PostalCode=02389-673 Country=Brazil Phone=(21) 555-4252 Fax=(21) 555-4545 Orders=... CustomerCustomerDemos=...
CustomerID=RICAR CompanyName=Ricardo Adocicados ContactName=Janete Limeira ContactTitle=Assistant Sales Agent Address=Av. Copacabana, 267 City=Rio de Janeiro Region=RJ PostalCode=02389-890 Country=Brazil Phone=(21) 555-3412 Fax=null Orders=... CustomerCustomerDemos=...
CustomerID=HANAR CompanyName=Hanari Carnes ContactName=Mario Pontes ContactTitle=Accounting Manager Address=Rua do Paço, 67 City=Rio de Janeiro Region=RJ PostalCode=05454-876 Country=Brazil Phone=(21) 555-0091 Fax=(21) 555-8765 Orders=... CustomerCustomerDemos=...
CustomerID=PICCO CompanyName=Piccolo und mehr ContactName=Georg Pipps ContactTitle=Sales Manager Address=Geislweg 14 City=Salzburg Region=null PostalCode=5020 Country=Austria Phone=6562-9722 Fax=6562-9723 Orders=... CustomerCustomerDemos=...
CustomerID=HILAA CompanyName=HILARION-Abastos ContactName=Carlos Hernández ContactTitle=Sales Representative Address=Carrera 22 con Ave. Carlos Soublette #8-35 City=San Cristóbal Region=Táchira PostalCode=5022 Country=Venezuela Phone=(5) 555-1340 Fax=(5) 555-1948 Orders=... CustomerCustomerDemos=...
CustomerID=LETSS CompanyName=Let's Stop N Shop ContactName=Jaime Yorres ContactTitle=Owner Address=87 Polk St. Suite 5 City=San Francisco Region=CA PostalCode=94117 Country=USA Phone=(415) 555-5938 Fax=null Orders=... CustomerCustomerDemos=...
CustomerID=TRADH CompanyName=Tradição Hipermercados ContactName=Anabela Domingues ContactTitle=Sales Representative Address=Av. Inês de Castro, 414 City=Sao Paulo Region=SP PostalCode=05634-030 Country=Brazil Phone=(11) 555-2167 Fax=(11) 555-2168 Orders=... CustomerCustomerDemos=...
CustomerID=FAMIA CompanyName=Familia Arquibaldo ContactName=Aria Cruz ContactTitle=Marketing Assistant Address=Rua Orós, 92 City=Sao Paulo Region=SP PostalCode=05442-030 Country=Brazil Phone=(11) 555-9857 Fax=null Orders=... CustomerCustomerDemos=...
CustomerID=QUEEN CompanyName=Queen Cozinha ContactName=Lúcia Carvalho ContactTitle=Marketing Assistant Address=Alameda dos Canàrios, 891 City=Sao Paulo Region=SP PostalCode=05487-020 Country=Brazil Phone=(11) 555-1189 Fax=null Orders=... CustomerCustomerDemos=...
CustomerID=COMMI CompanyName=Comércio Mineiro ContactName=Pedro Afonso ContactTitle=Sales Associate Address=Av. dos Lusíadas, 23 City=Sao Paulo Region=SP PostalCode=05432-043 Country=Brazil Phone=(11) 555-7647 Fax=null Orders=... CustomerCustomerDemos=...
CustomerID=WHITC CompanyName=White Clover Markets ContactName=Karl Jablonski ContactTitle=Owner Address=305 - 14th Ave. S. Suite 3B City=Seattle Region=WA PostalCode=98128 Country=USA Phone=(206) 555-4112 Fax=(206) 555-4115 Orders=... CustomerCustomerDemos=...
CustomerID=GODOS CompanyName=Godos Cocina Típica ContactName=José Pedro Freyre ContactTitle=Sales Manager Address=C/ Romero, 33 City=Sevilla Region=null PostalCode=41101 Country=Spain Phone=(95) 555 82 82 Fax=null Orders=... CustomerCustomerDemos=...
CustomerID=SANTG CompanyName=Santé Gourmet ContactName=Jonas Bergulfsen ContactTitle=Owner Address=Erling Skakkes gate 78 City=Stavern Region=null PostalCode=4110 Country=Norway Phone=07-98 92 35 Fax=07-98 92 47 Orders=... CustomerCustomerDemos=...
CustomerID=BLONP CompanyName=Blondesddsl père et fils ContactName=Frédérique Citeaux ContactTitle=Marketing Manager Address=24, place Kléber City=Strasbourg Region=null PostalCode=67000 Country=France Phone=88.60.15.31 Fax=88.60.15.32 Orders=... CustomerCustomerDemos=...
CustomerID=WANDK CompanyName=Die Wandernde Kuh ContactName=Rita Müller ContactTitle=Sales Representative Address=Adenauerallee 900 City=Stuttgart Region=null PostalCode=70563 Country=Germany Phone=0711-020361 Fax=0711-035428 Orders=... CustomerCustomerDemos=...
CustomerID=FRANS CompanyName=Franchi S.p.A. ContactName=Paolo Accorti ContactTitle=Sales Representative Address=Via Monte Bianco 34 City=Torino Region=null PostalCode=10100 Country=Italy Phone=011-4988260 Fax=011-4988261 Orders=... CustomerCustomerDemos=...
CustomerID=LAMAI CompanyName=La maison d'Asie ContactName=Annette Roulet ContactTitle=Sales Manager Address=1 rue Alsace-Lorraine City=Toulouse Region=null PostalCode=31000 Country=France Phone=61.77.61.10 Fax=61.77.61.11 Orders=... CustomerCustomerDemos=...
CustomerID=BOTTM CompanyName=Bottom-Dollar Markets ContactName=Elizabeth Lincoln ContactTitle=Accounting Manager Address=23 Tsawassen Blvd. City=Tsawassen Region=BC PostalCode=T2F 8M4 Country=Canada Phone=(604) 555-4729 Fax=(604) 555-3745 Orders=... CustomerCustomerDemos=...
CustomerID=LAUGB CompanyName=Laughing Bacchus Wine Cellars ContactName=Yoshi Tannamuri ContactTitle=Marketing Assistant Address=1900 Oak St. City=Vancouver Region=BC PostalCode=V3F 2K1 Country=Canada Phone=(604) 555-3392 Fax=(604) 555-7293 Orders=... CustomerCustomerDemos=...
CustomerID=LACOR CompanyName=La corne d'abondance ContactName=Daniel Tonini ContactTitle=Sales Representative Address=67, avenue de l'Europe City=Versailles Region=null PostalCode=78000 Country=France Phone=30.59.84.10 Fax=30.59.85.11 Orders=... CustomerCustomerDemos=...
CustomerID=LAZYK CompanyName=Lazy K Kountry Store ContactName=John Steel ContactTitle=Marketing Manager Address=12 Orchestra Terrace City=Walla Walla Region=WA PostalCode=99362 Country=USA Phone=(509) 555-7969 Fax=(509) 555-6221 Orders=... CustomerCustomerDemos=...
CustomerID=WOLZA CompanyName=Wolski Zajazd ContactName=Zbyszek Piestrzeniewicz ContactTitle=Owner Address=ul. Filtrowa 68 City=Warszawa Region=null PostalCode=01-012 Country=Poland Phone=(26) 642-7012 Fax=(26) 642-7012 Orders=... CustomerCustomerDemos=...
This sample uses orderby to sort Orders from EmployeeID 1 by ship-to country, and then by freight from highest to lowest.
Public Sub LinqToSqlOrderBy05()
Dim q = From o In db.Orders _
Where o.EmployeeID = 1 _
Order By o.ShipCountry, o.Freight Descending
ObjectDumper.Write(q)
End Sub
Result:
OrderID=10916 CustomerID=RANCH EmployeeID=1 OrderDate=2/27/1998 RequiredDate=3/27/1998 ShippedDate=3/9/1998 ShipVia=2 Freight=63.7700 ShipName=Rancho grande ShipAddress=Av. del Libertador 900 ShipCity=Buenos Aires ShipRegion=null ShipPostalCode=1010 ShipCountry=Argentina Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10776 CustomerID=ERNSH EmployeeID=1 OrderDate=12/15/1997 RequiredDate=1/12/1998 ShippedDate=12/18/1997 ShipVia=3 Freight=351.5300 ShipName=Ernst Handel ShipAddress=Kirchgasse 6 ShipCity=Graz ShipRegion=null ShipPostalCode=8010 ShipCountry=Austria Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10351 CustomerID=ERNSH EmployeeID=1 OrderDate=11/11/1996 RequiredDate=12/9/1996 ShippedDate=11/20/1996 ShipVia=1 Freight=162.3300 ShipName=Ernst Handel ShipAddress=Kirchgasse 6 ShipCity=Graz ShipRegion=null ShipPostalCode=8010 ShipCountry=Austria Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10258 CustomerID=ERNSH EmployeeID=1 OrderDate=7/17/1996 RequiredDate=8/14/1996 ShippedDate=7/23/1996 ShipVia=1 Freight=140.5100 ShipName=Ernst Handel ShipAddress=Kirchgasse 6 ShipCity=Graz ShipRegion=null ShipPostalCode=8010 ShipCountry=Austria Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10773 CustomerID=ERNSH EmployeeID=1 OrderDate=12/11/1997 RequiredDate=1/8/1998 ShippedDate=12/16/1997 ShipVia=3 Freight=96.4300 ShipName=Ernst Handel ShipAddress=Kirchgasse 6 ShipCity=Graz ShipRegion=null ShipPostalCode=8010 ShipCountry=Austria Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10968 CustomerID=ERNSH EmployeeID=1 OrderDate=3/23/1998 RequiredDate=4/20/1998 ShippedDate=4/1/1998 ShipVia=3 Freight=74.6000 ShipName=Ernst Handel ShipAddress=Kirchgasse 6 ShipCity=Graz ShipRegion=null ShipPostalCode=8010 ShipCountry=Austria Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=11038 CustomerID=SUPRD EmployeeID=1 OrderDate=4/21/1998 RequiredDate=5/19/1998 ShippedDate=4/30/1998 ShipVia=2 Freight=29.5900 ShipName=Suprêmes délices ShipAddress=Boulevard Tirou, 255 ShipCity=Charleroi ShipRegion=null ShipPostalCode=B-6000 ShipCountry=Belgium Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10709 CustomerID=GOURL EmployeeID=1 OrderDate=10/17/1997 RequiredDate=11/14/1997 ShippedDate=11/20/1997 ShipVia=3 Freight=210.8000 ShipName=Gourmet Lanchonetes ShipAddress=Av. Brasil, 442 ShipCity=Campinas ShipRegion=SP ShipPostalCode=04876-786 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10981 CustomerID=HANAR EmployeeID=1 OrderDate=3/27/1998 RequiredDate=4/24/1998 ShippedDate=4/2/1998 ShipVia=2 Freight=193.3700 ShipName=Hanari Carnes ShipAddress=Rua do Paço, 67 ShipCity=Rio de Janeiro ShipRegion=RJ ShipPostalCode=05454-876 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10587 CustomerID=QUEDE EmployeeID=1 OrderDate=7/2/1997 RequiredDate=7/30/1997 ShippedDate=7/9/1997 ShipVia=1 Freight=62.5200 ShipName=Que Delícia ShipAddress=Rua da Panificadora, 12 ShipCity=Rio de Janeiro ShipRegion=RJ ShipPostalCode=02389-673 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10813 CustomerID=RICAR EmployeeID=1 OrderDate=1/5/1998 RequiredDate=2/2/1998 ShippedDate=1/9/1998 ShipVia=1 Freight=47.3800 ShipName=Ricardo Adocicados ShipAddress=Av. Copacabana, 267 ShipCity=Rio de Janeiro ShipRegion=RJ ShipPostalCode=02389-890 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10877 CustomerID=RICAR EmployeeID=1 OrderDate=2/9/1998 RequiredDate=3/9/1998 ShippedDate=2/19/1998 ShipVia=1 Freight=38.0600 ShipName=Ricardo Adocicados ShipAddress=Av. Copacabana, 267 ShipCity=Rio de Janeiro ShipRegion=RJ ShipPostalCode=02389-890 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10834 CustomerID=TRADH EmployeeID=1 OrderDate=1/15/1998 RequiredDate=2/12/1998 ShippedDate=1/19/1998 ShipVia=3 Freight=29.7800 ShipName=Tradiçao Hipermercados ShipAddress=Av. Inês de Castro, 414 ShipCity=Sao Paulo ShipRegion=SP ShipPostalCode=05634-030 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10690 CustomerID=HANAR EmployeeID=1 OrderDate=10/2/1997 RequiredDate=10/30/1997 ShippedDate=10/3/1997 ShipVia=1 Freight=15.8000 ShipName=Hanari Carnes ShipAddress=Rua do Paço, 67 ShipCity=Rio de Janeiro ShipRegion=RJ ShipPostalCode=05454-876 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10886 CustomerID=HANAR EmployeeID=1 OrderDate=2/13/1998 RequiredDate=3/13/1998 ShippedDate=3/2/1998 ShipVia=1 Freight=4.9900 ShipName=Hanari Carnes ShipAddress=Rua do Paço, 67 ShipCity=Rio de Janeiro ShipRegion=RJ ShipPostalCode=05454-876 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10900 CustomerID=WELLI EmployeeID=1 OrderDate=2/20/1998 RequiredDate=3/20/1998 ShippedDate=3/4/1998 ShipVia=2 Freight=1.6600 ShipName=Wellington Importadora ShipAddress=Rua do Mercado, 12 ShipCity=Resende ShipRegion=SP ShipPostalCode=08737-363 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10292 CustomerID=TRADH EmployeeID=1 OrderDate=8/28/1996 RequiredDate=9/25/1996 ShippedDate=9/2/1996 ShipVia=2 Freight=1.3500 ShipName=Tradiçao Hipermercados ShipAddress=Av. Inês de Castro, 414 ShipCity=Sao Paulo ShipRegion=SP ShipPostalCode=05634-030 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10969 CustomerID=COMMI EmployeeID=1 OrderDate=3/23/1998 RequiredDate=4/20/1998 ShippedDate=3/30/1998 ShipVia=2 Freight=0.2100 ShipName=Comércio Mineiro ShipAddress=Av. dos Lusíadas, 23 ShipCity=Sao Paulo ShipRegion=SP ShipPostalCode=05432-043 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10605 CustomerID=MEREP EmployeeID=1 OrderDate=7/21/1997 RequiredDate=8/18/1997 ShippedDate=7/29/1997 ShipVia=2 Freight=379.1300 ShipName=Mère Paillarde ShipAddress=43 rue St. Laurent ShipCity=Montréal ShipRegion=Québec ShipPostalCode=H1J 1C3 ShipCountry=Canada Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10618 CustomerID=MEREP EmployeeID=1 OrderDate=8/1/1997 RequiredDate=9/12/1997 ShippedDate=8/8/1997 ShipVia=1 Freight=154.6800 ShipName=Mère Paillarde ShipAddress=43 rue St. Laurent ShipCity=Montréal ShipRegion=Québec ShipPostalCode=H1J 1C3 ShipCountry=Canada Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=11027 CustomerID=BOTTM EmployeeID=1 OrderDate=4/16/1998 RequiredDate=5/14/1998 ShippedDate=4/20/1998 ShipVia=1 Freight=52.5200 ShipName=Bottom-Dollar Markets ShipAddress=23 Tsawassen Blvd. ShipCity=Tsawassen ShipRegion=BC ShipPostalCode=T2F 8M4 ShipCountry=Canada Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10975 CustomerID=BOTTM EmployeeID=1 OrderDate=3/25/1998 RequiredDate=4/22/1998 ShippedDate=3/27/1998 ShipVia=3 Freight=32.2700 ShipName=Bottom-Dollar Markets ShipAddress=23 Tsawassen Blvd. ShipCity=Tsawassen ShipRegion=BC ShipPostalCode=T2F 8M4 ShipCountry=Canada Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10376 CustomerID=MEREP EmployeeID=1 OrderDate=12/9/1996 RequiredDate=1/6/1997 ShippedDate=12/13/1996 ShipVia=2 Freight=20.3900 ShipName=Mère Paillarde ShipAddress=43 rue St. Laurent ShipCity=Montréal ShipRegion=Québec ShipPostalCode=H1J 1C3 ShipCountry=Canada Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10921 CustomerID=VAFFE EmployeeID=1 OrderDate=3/3/1998 RequiredDate=4/14/1998 ShippedDate=3/9/1998 ShipVia=1 Freight=176.4800 ShipName=Vaffeljernet ShipAddress=Smagsloget 45 ShipCity=Århus ShipRegion=null ShipPostalCode=8200 ShipCountry=Denmark Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10465 CustomerID=VAFFE EmployeeID=1 OrderDate=3/5/1997 RequiredDate=4/2/1997 ShippedDate=3/14/1997 ShipVia=3 Freight=145.0400 ShipName=Vaffeljernet ShipAddress=Smagsloget 45 ShipCity=Århus ShipRegion=null ShipPostalCode=8200 ShipCountry=Denmark Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10591 CustomerID=VAFFE EmployeeID=1 OrderDate=7/7/1997 RequiredDate=7/21/1997 ShippedDate=7/16/1997 ShipVia=1 Freight=55.9200 ShipName=Vaffeljernet ShipAddress=Smagsloget 45 ShipCity=Århus ShipRegion=null ShipPostalCode=8200 ShipCountry=Denmark Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10946 CustomerID=VAFFE EmployeeID=1 OrderDate=3/12/1998 RequiredDate=4/9/1998 ShippedDate=3/19/1998 ShipVia=2 Freight=27.2000 ShipName=Vaffeljernet ShipAddress=Smagsloget 45 ShipCity=Århus ShipRegion=null ShipPostalCode=8200 ShipCountry=Denmark Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10270 CustomerID=WARTH EmployeeID=1 OrderDate=8/1/1996 RequiredDate=8/29/1996 ShippedDate=8/2/1996 ShipVia=1 Freight=136.5400 ShipName=Wartian Herkku ShipAddress=Torikatu 38 ShipCity=Oulu ShipRegion=null ShipPostalCode=90110 ShipCountry=Finland Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10910 CustomerID=WILMK EmployeeID=1 OrderDate=2/26/1998 RequiredDate=3/26/1998 ShippedDate=3/4/1998 ShipVia=3 Freight=38.1100 ShipName=Wilman Kala ShipAddress=Keskuskatu 45 ShipCity=Helsinki ShipRegion=null ShipPostalCode=21240 ShipCountry=Finland Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10546 CustomerID=VICTE EmployeeID=1 OrderDate=5/23/1997 RequiredDate=6/20/1997 ShippedDate=5/27/1997 ShipVia=3 Freight=194.7200 ShipName=Victuailles en stock ShipAddress=2, rue du Commerce ShipCity=Lyon ShipRegion=null ShipPostalCode=69004 ShipCountry=France Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10340 CustomerID=BONAP EmployeeID=1 OrderDate=10/29/1996 RequiredDate=11/26/1996 ShippedDate=11/8/1996 ShipVia=3 Freight=166.3100 ShipName=Bon app' ShipAddress=12, rue des Bouchers ShipCity=Marseille ShipRegion=null ShipPostalCode=13008 ShipCountry=France Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10789 CustomerID=FOLIG EmployeeID=1 OrderDate=12/22/1997 RequiredDate=1/19/1998 ShippedDate=12/31/1997 ShipVia=2 Freight=100.6000 ShipName=Folies gourmandes ShipAddress=184, chaussée de Tournai ShipCity=Lille ShipRegion=null ShipPostalCode=59000 ShipCountry=France Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10827 CustomerID=BONAP EmployeeID=1 OrderDate=1/12/1998 RequiredDate=1/26/1998 ShippedDate=2/6/1998 ShipVia=2 Freight=63.5400 ShipName=Bon app' ShipAddress=12, rue des Bouchers ShipCity=Marseille ShipRegion=null ShipPostalCode=13008 ShipCountry=France Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10850 CustomerID=VICTE EmployeeID=1 OrderDate=1/23/1998 RequiredDate=3/6/1998 ShippedDate=1/30/1998 ShipVia=1 Freight=49.1900 ShipName=Victuailles en stock ShipAddress=2, rue du Commerce ShipCity=Lyon ShipRegion=null ShipPostalCode=69004 ShipCountry=France Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10671 CustomerID=FRANR EmployeeID=1 OrderDate=9/17/1997 RequiredDate=10/15/1997 ShippedDate=9/24/1997 ShipVia=1 Freight=30.3400 ShipName=France restauration ShipAddress=54, rue Royale ShipCity=Nantes ShipRegion=null ShipPostalCode=44000 ShipCountry=France Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10311 CustomerID=DUMON EmployeeID=1 OrderDate=9/20/1996 RequiredDate=10/4/1996 ShippedDate=9/26/1996 ShipVia=3 Freight=24.6900 ShipName=Du monde entier ShipAddress=67, rue des Cinquante Otages ShipCity=Nantes ShipRegion=null ShipPostalCode=44000 ShipCountry=France Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10525 CustomerID=BONAP EmployeeID=1 OrderDate=5/2/1997 RequiredDate=5/30/1997 ShippedDate=5/23/1997 ShipVia=2 Freight=11.0600 ShipName=Bon app' ShipAddress=12, rue des Bouchers ShipCity=Marseille ShipRegion=null ShipPostalCode=13008 ShipCountry=France Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10371 CustomerID=LAMAI EmployeeID=1 OrderDate=12/3/1996 RequiredDate=12/31/1996 ShippedDate=12/24/1996 ShipVia=1 Freight=0.4500 ShipName=La maison d'Asie ShipAddress=1 rue Alsace-Lorraine ShipCity=Toulouse ShipRegion=null ShipPostalCode=31000 ShipCountry=France Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=11012 CustomerID=FRANK EmployeeID=1 OrderDate=4/9/1998 RequiredDate=4/23/1998 ShippedDate=4/17/1998 ShipVia=3 Freight=242.9500 ShipName=Frankenversand ShipAddress=Berliner Platz 43 ShipCity=München ShipRegion=null ShipPostalCode=80805 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10361 CustomerID=QUICK EmployeeID=1 OrderDate=11/22/1996 RequiredDate=12/20/1996 ShippedDate=12/3/1996 ShipVia=2 Freight=183.1700 ShipName=QUICK-Stop ShipAddress=Taucherstraße 10 ShipCity=Cunewalde ShipRegion=null ShipPostalCode=01307 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10718 CustomerID=KOENE EmployeeID=1 OrderDate=10/27/1997 RequiredDate=11/24/1997 ShippedDate=10/29/1997 ShipVia=3 Freight=170.8800 ShipName=Königlich Essen ShipAddress=Maubelstr. 90 ShipCity=Brandenburg ShipRegion=null ShipPostalCode=14776 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10396 CustomerID=FRANK EmployeeID=1 OrderDate=12/27/1996 RequiredDate=1/10/1997 ShippedDate=1/6/1997 ShipVia=3 Freight=135.3500 ShipName=Frankenversand ShipAddress=Berliner Platz 43 ShipCity=München ShipRegion=null ShipPostalCode=80805 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10653 CustomerID=FRANK EmployeeID=1 OrderDate=9/2/1997 RequiredDate=9/30/1997 ShippedDate=9/19/1997 ShipVia=1 Freight=93.2500 ShipName=Frankenversand ShipAddress=Berliner Platz 43 ShipCity=München ShipRegion=null ShipPostalCode=80805 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10825 CustomerID=DRACD EmployeeID=1 OrderDate=1/9/1998 RequiredDate=2/6/1998 ShippedDate=1/14/1998 ShipVia=1 Freight=79.2500 ShipName=Drachenblut Delikatessen ShipAddress=Walserweg 21 ShipCity=Aachen ShipRegion=null ShipPostalCode=52066 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10285 CustomerID=QUICK EmployeeID=1 OrderDate=8/20/1996 RequiredDate=9/17/1996 ShippedDate=8/26/1996 ShipVia=2 Freight=76.8300 ShipName=QUICK-Stop ShipAddress=Taucherstraße 10 ShipCity=Cunewalde ShipRegion=null ShipPostalCode=01307 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10859 CustomerID=FRANK EmployeeID=1 OrderDate=1/29/1998 RequiredDate=2/26/1998 ShippedDate=2/2/1998 ShipVia=2 Freight=76.1000 ShipName=Frankenversand ShipAddress=Berliner Platz 43 ShipCity=München ShipRegion=null ShipPostalCode=80805 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10835 CustomerID=ALFKI EmployeeID=1 OrderDate=1/15/1998 RequiredDate=2/12/1998 ShippedDate=1/21/1998 ShipVia=3 Freight=69.5300 ShipName=Alfred's Futterkiste ShipAddress=Obere Str. 57 ShipCity=Berlin ShipRegion=null ShipPostalCode=12209 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10325 CustomerID=KOENE EmployeeID=1 OrderDate=10/9/1996 RequiredDate=10/23/1996 ShippedDate=10/14/1996 ShipVia=3 Freight=64.8600 ShipName=Königlich Essen ShipAddress=Maubelstr. 90 ShipCity=Brandenburg ShipRegion=null ShipPostalCode=14776 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10717 CustomerID=FRANK EmployeeID=1 OrderDate=10/24/1997 RequiredDate=11/21/1997 ShippedDate=10/29/1997 ShipVia=2 Freight=59.2500 ShipName=Frankenversand ShipAddress=Berliner Platz 43 ShipCity=München ShipRegion=null ShipPostalCode=80805 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10668 CustomerID=WANDK EmployeeID=1 OrderDate=9/15/1997 RequiredDate=10/13/1997 ShippedDate=9/23/1997 ShipVia=2 Freight=47.2200 ShipName=Die Wandernde Kuh ShipAddress=Adenauerallee 900 ShipCity=Stuttgart ShipRegion=null ShipPostalCode=70563 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10788 CustomerID=QUICK EmployeeID=1 OrderDate=12/22/1997 RequiredDate=1/19/1998 ShippedDate=1/19/1998 ShipVia=2 Freight=42.7000 ShipName=QUICK-Stop ShipAddress=Taucherstraße 10 ShipCity=Cunewalde ShipRegion=null ShipPostalCode=01307 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10952 CustomerID=ALFKI EmployeeID=1 OrderDate=3/16/1998 RequiredDate=4/27/1998 ShippedDate=3/24/1998 ShipVia=1 Freight=40.4200 ShipName=Alfred's Futterkiste ShipAddress=Obere Str. 57 ShipCity=Berlin ShipRegion=null ShipPostalCode=12209 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10991 CustomerID=QUICK EmployeeID=1 OrderDate=4/1/1998 RequiredDate=4/29/1998 ShippedDate=4/7/1998 ShipVia=1 Freight=38.5100 ShipName=QUICK-Stop ShipAddress=Taucherstraße 10 ShipCity=Cunewalde ShipRegion=null ShipPostalCode=01307 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10630 CustomerID=KOENE EmployeeID=1 OrderDate=8/13/1997 RequiredDate=9/10/1997 ShippedDate=8/19/1997 ShipVia=2 Freight=32.3500 ShipName=Königlich Essen ShipAddress=Maubelstr. 90 ShipCity=Brandenburg ShipRegion=null ShipPostalCode=14776 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10542 CustomerID=KOENE EmployeeID=1 OrderDate=5/20/1997 RequiredDate=6/17/1997 ShippedDate=5/26/1997 ShipVia=3 Freight=10.9500 ShipName=Königlich Essen ShipAddress=Maubelstr. 90 ShipCity=Brandenburg ShipRegion=null ShipPostalCode=14776 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=11067 CustomerID=DRACD EmployeeID=1 OrderDate=5/4/1998 RequiredDate=5/18/1998 ShippedDate=5/6/1998 ShipVia=2 Freight=7.9800 ShipName=Drachenblut Delikatessen ShipAddress=Walserweg 21 ShipCity=Aachen ShipRegion=null ShipPostalCode=52066 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10508 CustomerID=OTTIK EmployeeID=1 OrderDate=4/16/1997 RequiredDate=5/14/1997 ShippedDate=5/13/1997 ShipVia=2 Freight=4.9900 ShipName=Ottilies Käseladen ShipAddress=Mehrheimerstr. 369 ShipCity=Köln ShipRegion=null ShipPostalCode=50739 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10567 CustomerID=HUNGO EmployeeID=1 OrderDate=6/12/1997 RequiredDate=7/10/1997 ShippedDate=6/17/1997 ShipVia=1 Freight=33.9700 ShipName=Hungry Owl All-Night Grocers ShipAddress=8 Johnstown Road ShipCity=Cork ShipRegion=Co. Cork ShipPostalCode=null ShipCountry=Ireland Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10275 CustomerID=MAGAA EmployeeID=1 OrderDate=8/7/1996 RequiredDate=9/4/1996 ShippedDate=8/9/1996 ShipVia=1 Freight=26.9300 ShipName=Magazzini Alimentari Riuniti ShipAddress=Via Ludovico il Moro 22 ShipCity=Bergamo ShipRegion=null ShipPostalCode=24100 ShipCountry=Italy Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10562 CustomerID=REGGC EmployeeID=1 OrderDate=6/9/1997 RequiredDate=7/7/1997 ShippedDate=6/12/1997 ShipVia=1 Freight=22.9500 ShipName=Reggiani Caseifici ShipAddress=Strada Provinciale 124 ShipCity=Reggio Emilia ShipRegion=null ShipPostalCode=42100 ShipCountry=Italy Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10710 CustomerID=FRANS EmployeeID=1 OrderDate=10/20/1997 RequiredDate=11/17/1997 ShippedDate=10/23/1997 ShipVia=1 Freight=4.9800 ShipName=Franchi S.p.A. ShipAddress=Via Monte Bianco 34 ShipCity=Torino ShipRegion=null ShipPostalCode=10100 ShipCountry=Italy Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10655 CustomerID=REGGC EmployeeID=1 OrderDate=9/3/1997 RequiredDate=10/1/1997 ShippedDate=9/11/1997 ShipVia=2 Freight=4.4100 ShipName=Reggiani Caseifici ShipAddress=Strada Provinciale 124 ShipCity=Reggio Emilia ShipRegion=null ShipPostalCode=42100 ShipCountry=Italy Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10950 CustomerID=MAGAA EmployeeID=1 OrderDate=3/16/1998 RequiredDate=4/13/1998 ShippedDate=3/23/1998 ShipVia=2 Freight=2.5000 ShipName=Magazzini Alimentari Riuniti ShipAddress=Via Ludovico il Moro 22 ShipCity=Bergamo ShipRegion=null ShipPostalCode=24100 ShipCountry=Italy Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10304 CustomerID=TORTU EmployeeID=1 OrderDate=9/12/1996 RequiredDate=10/10/1996 ShippedDate=9/17/1996 ShipVia=2 Freight=63.7900 ShipName=Tortuga Restaurante ShipAddress=Avda. Azteca 123 ShipCity=México D.F. ShipRegion=null ShipPostalCode=05033 ShipCountry=Mexico Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10842 CustomerID=TORTU EmployeeID=1 OrderDate=1/20/1998 RequiredDate=2/17/1998 ShippedDate=1/29/1998 ShipVia=3 Freight=54.4200 ShipName=Tortuga Restaurante ShipAddress=Avda. Azteca 123 ShipCity=México D.F. ShipRegion=null ShipPostalCode=05033 ShipCountry=Mexico Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10995 CustomerID=PERIC EmployeeID=1 OrderDate=4/2/1998 RequiredDate=4/30/1998 ShippedDate=4/6/1998 ShipVia=3 Freight=46.0000 ShipName=Pericles Comidas clásicas ShipAddress=Calle Dr. Jorge Cash 321 ShipCity=México D.F. ShipRegion=null ShipPostalCode=05033 ShipCountry=Mexico Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10293 CustomerID=TORTU EmployeeID=1 OrderDate=8/29/1996 RequiredDate=9/26/1996 ShippedDate=9/11/1996 ShipVia=3 Freight=21.1800 ShipName=Tortuga Restaurante ShipAddress=Avda. Azteca 123 ShipCity=México D.F. ShipRegion=null ShipPostalCode=05033 ShipCountry=Mexico Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=11069 CustomerID=TORTU EmployeeID=1 OrderDate=5/4/1998 RequiredDate=6/1/1998 ShippedDate=5/6/1998 ShipVia=2 Freight=15.6700 ShipName=Tortuga Restaurante ShipAddress=Avda. Azteca 123 ShipCity=México D.F. ShipRegion=null ShipPostalCode=05033 ShipCountry=Mexico Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10677 CustomerID=ANTON EmployeeID=1 OrderDate=9/22/1997 RequiredDate=10/20/1997 ShippedDate=9/26/1997 ShipVia=3 Freight=4.0300 ShipName=Antonio Moreno Taquería ShipAddress=Mataderos 2312 ShipCity=México D.F. ShipRegion=null ShipPostalCode=05023 ShipCountry=Mexico Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10387 CustomerID=SANTG EmployeeID=1 OrderDate=12/18/1996 RequiredDate=1/15/1997 ShippedDate=12/20/1996 ShipVia=2 Freight=93.6300 ShipName=Santé Gourmet ShipAddress=Erling Skakkes gate 78 ShipCity=Stavern ShipRegion=null ShipPostalCode=4110 ShipCountry=Norway Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10909 CustomerID=SANTG EmployeeID=1 OrderDate=2/26/1998 RequiredDate=3/26/1998 ShippedDate=3/10/1998 ShipVia=2 Freight=53.0500 ShipName=Santé Gourmet ShipAddress=Erling Skakkes gate 78 ShipCity=Stavern ShipRegion=null ShipPostalCode=4110 ShipCountry=Norway Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10792 CustomerID=WOLZA EmployeeID=1 OrderDate=12/23/1997 RequiredDate=1/20/1998 ShippedDate=12/31/1997 ShipVia=3 Freight=23.7900 ShipName=Wolski Zajazd ShipAddress=ul. Filtrowa 68 ShipCity=Warszawa ShipRegion=null ShipPostalCode=01-012 ShipCountry=Poland Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10374 CustomerID=WOLZA EmployeeID=1 OrderDate=12/5/1996 RequiredDate=1/2/1997 ShippedDate=12/9/1996 ShipVia=3 Freight=3.9400 ShipName=Wolski Zajazd ShipAddress=ul. Filtrowa 68 ShipCity=Warszawa ShipRegion=null ShipPostalCode=01-012 ShipCountry=Poland Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10604 CustomerID=FURIB EmployeeID=1 OrderDate=7/18/1997 RequiredDate=8/15/1997 ShippedDate=7/29/1997 ShipVia=1 Freight=7.4600 ShipName=Furia Bacalhau e Frutos do Mar ShipAddress=Jardim das rosas n. 32 ShipCity=Lisboa ShipRegion=null ShipPostalCode=1675 ShipCountry=Portugal Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10664 CustomerID=FURIB EmployeeID=1 OrderDate=9/10/1997 RequiredDate=10/8/1997 ShippedDate=9/19/1997 ShipVia=3 Freight=1.2700 ShipName=Furia Bacalhau e Frutos do Mar ShipAddress=Jardim das rosas n. 32 ShipCity=Lisboa ShipRegion=null ShipPostalCode=1675 ShipCountry=Portugal Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10888 CustomerID=GODOS EmployeeID=1 OrderDate=2/16/1998 RequiredDate=3/16/1998 ShippedDate=2/23/1998 ShipVia=2 Freight=51.8700 ShipName=Godos Cocina Típica ShipAddress=C/ Romero, 33 ShipCity=Sevilla ShipRegion=null ShipPostalCode=41101 ShipCountry=Spain Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10306 CustomerID=ROMEY EmployeeID=1 OrderDate=9/16/1996 RequiredDate=10/14/1996 ShippedDate=9/23/1996 ShipVia=3 Freight=7.5600 ShipName=Romero y tomillo ShipAddress=Gran Vía, 1 ShipCity=Madrid ShipRegion=null ShipPostalCode=28001 ShipCountry=Spain Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10928 CustomerID=GALED EmployeeID=1 OrderDate=3/5/1998 RequiredDate=4/2/1998 ShippedDate=3/18/1998 ShipVia=1 Freight=1.3600 ShipName=Galería del gastronómo ShipAddress=Rambla de Cataluña, 23 ShipCity=Barcelona ShipRegion=null ShipPostalCode=8022 ShipCountry=Spain Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10524 CustomerID=BERGS EmployeeID=1 OrderDate=5/1/1997 RequiredDate=5/29/1997 ShippedDate=5/7/1997 ShipVia=2 Freight=244.7900 ShipName=Berglunds snabbköp ShipAddress=Berguvsvägen 8 ShipCity=Luleå ShipRegion=null ShipPostalCode=S-958 22 ShipCountry=Sweden Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10626 CustomerID=BERGS EmployeeID=1 OrderDate=8/11/1997 RequiredDate=9/8/1997 ShippedDate=8/20/1997 ShipVia=2 Freight=138.6900 ShipName=Berglunds snabbköp ShipAddress=Berguvsvägen 8 ShipCity=Luleå ShipRegion=null ShipPostalCode=S-958 22 ShipCountry=Sweden Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10733 CustomerID=BERGS EmployeeID=1 OrderDate=11/7/1997 RequiredDate=12/5/1997 ShippedDate=11/10/1997 ShipVia=3 Freight=110.1100 ShipName=Berglunds snabbköp ShipAddress=Berguvsvägen 8 ShipCity=Luleå ShipRegion=null ShipPostalCode=S-958 22 ShipCountry=Sweden Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10902 CustomerID=FOLKO EmployeeID=1 OrderDate=2/23/1998 RequiredDate=3/23/1998 ShippedDate=3/3/1998 ShipVia=1 Freight=44.1500 ShipName=Folk och fä HB ShipAddress=Åkergatan 24 ShipCity=Bräcke ShipRegion=null ShipPostalCode=S-844 67 ShipCountry=Sweden Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10689 CustomerID=BERGS EmployeeID=1 OrderDate=10/1/1997 RequiredDate=10/29/1997 ShippedDate=10/7/1997 ShipVia=2 Freight=13.4200 ShipName=Berglunds snabbköp ShipAddress=Berguvsvägen 8 ShipCity=Luleå ShipRegion=null ShipPostalCode=S-958 22 ShipCountry=Sweden Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10537 CustomerID=RICSU EmployeeID=1 OrderDate=5/14/1997 RequiredDate=5/28/1997 ShippedDate=5/19/1997 ShipVia=1 Freight=78.8500 ShipName=Richter Supermarkt ShipAddress=Starenweg 5 ShipCity=Genève ShipRegion=null ShipPostalCode=1204 ShipCountry=Switzerland Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10746 CustomerID=CHOPS EmployeeID=1 OrderDate=11/19/1997 RequiredDate=12/17/1997 ShippedDate=11/21/1997 ShipVia=3 Freight=31.4300 ShipName=Chop-suey Chinese ShipAddress=Hauptstr. 31 ShipCity=Bern ShipRegion=null ShipPostalCode=3012 ShipCountry=Switzerland Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10800 CustomerID=SEVES EmployeeID=1 OrderDate=12/26/1997 RequiredDate=1/23/1998 ShippedDate=1/5/1998 ShipVia=3 Freight=137.4400 ShipName=Seven Seas Imports ShipAddress=90 Wadhurst Rd. ShipCity=London ShipRegion=null ShipPostalCode=OX15 4NB ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=11023 CustomerID=BSBEV EmployeeID=1 OrderDate=4/14/1998 RequiredDate=4/28/1998 ShippedDate=4/24/1998 ShipVia=2 Freight=123.8300 ShipName=B's Beverages ShipAddress=Fauntleroy Circus ShipCity=London ShipRegion=null ShipPostalCode=EC2 5NT ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10400 CustomerID=EASTC EmployeeID=1 OrderDate=1/1/1997 RequiredDate=1/29/1997 ShippedDate=1/16/1997 ShipVia=3 Freight=83.9300 ShipName=Eastern Connection ShipAddress=35 King George ShipCity=London ShipRegion=null ShipPostalCode=WX3 6FW ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10558 CustomerID=AROUT EmployeeID=1 OrderDate=6/4/1997 RequiredDate=7/2/1997 ShippedDate=6/10/1997 ShipVia=2 Freight=72.9700 ShipName=Around the Horn ShipAddress=Brook Farm Stratford St. Mary ShipCity=Colchester ShipRegion=Essex ShipPostalCode=CO7 6JX ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10364 CustomerID=EASTC EmployeeID=1 OrderDate=11/26/1996 RequiredDate=1/7/1997 ShippedDate=12/4/1996 ShipVia=1 Freight=71.9700 ShipName=Eastern Connection ShipAddress=35 King George ShipCity=London ShipRegion=null ShipPostalCode=WX3 6FW ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10453 CustomerID=AROUT EmployeeID=1 OrderDate=2/21/1997 RequiredDate=3/21/1997 ShippedDate=2/26/1997 ShipVia=2 Freight=25.3600 ShipName=Around the Horn ShipAddress=Brook Farm Stratford St. Mary ShipCity=Colchester ShipRegion=Essex ShipPostalCode=CO7 6JX ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10743 CustomerID=AROUT EmployeeID=1 OrderDate=11/17/1997 RequiredDate=12/15/1997 ShippedDate=11/21/1997 ShipVia=2 Freight=23.7200 ShipName=Around the Horn ShipAddress=Brook Farm Stratford St. Mary ShipCity=Colchester ShipRegion=Essex ShipPostalCode=CO7 6JX ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10377 CustomerID=SEVES EmployeeID=1 OrderDate=12/9/1996 RequiredDate=1/6/1997 ShippedDate=12/13/1996 ShipVia=3 Freight=22.2100 ShipName=Seven Seas Imports ShipAddress=90 Wadhurst Rd. ShipCity=London ShipRegion=null ShipPostalCode=OX15 4NB ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10473 CustomerID=ISLAT EmployeeID=1 OrderDate=3/13/1997 RequiredDate=3/27/1997 ShippedDate=3/21/1997 ShipVia=3 Freight=16.3700 ShipName=Island Trading ShipAddress=Garden House Crowther Way ShipCity=Cowes ShipRegion=Isle of Wight ShipPostalCode=PO31 7PJ ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10612 CustomerID=SAVEA EmployeeID=1 OrderDate=7/28/1997 RequiredDate=8/25/1997 ShippedDate=8/1/1997 ShipVia=2 Freight=544.0800 ShipName=Save-a-lot Markets ShipAddress=187 Suffolk Ln. ShipCity=Boise ShipRegion=ID ShipPostalCode=83720 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10984 CustomerID=SAVEA EmployeeID=1 OrderDate=3/30/1998 RequiredDate=4/27/1998 ShippedDate=4/3/1998 ShipVia=3 Freight=211.2200 ShipName=Save-a-lot Markets ShipAddress=187 Suffolk Ln. ShipCity=Boise ShipRegion=ID ShipPostalCode=83720 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10713 CustomerID=SAVEA EmployeeID=1 OrderDate=10/22/1997 RequiredDate=11/19/1997 ShippedDate=10/24/1997 ShipVia=1 Freight=167.0500 ShipName=Save-a-lot Markets ShipAddress=187 Suffolk Ln. ShipCity=Boise ShipRegion=ID ShipPostalCode=83720 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10316 CustomerID=RATTC EmployeeID=1 OrderDate=9/27/1996 RequiredDate=10/25/1996 ShippedDate=10/8/1996 ShipVia=3 Freight=150.1500 ShipName=Rattlesnake Canyon Grocery ShipAddress=2817 Milton Dr. ShipCity=Albuquerque ShipRegion=NM ShipPostalCode=87110 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10393 CustomerID=SAVEA EmployeeID=1 OrderDate=12/25/1996 RequiredDate=1/22/1997 ShippedDate=1/3/1997 ShipVia=3 Freight=126.5600 ShipName=Save-a-lot Markets ShipAddress=187 Suffolk Ln. ShipCity=Boise ShipRegion=ID ShipPostalCode=83720 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10616 CustomerID=GREAL EmployeeID=1 OrderDate=7/31/1997 RequiredDate=8/28/1997 ShippedDate=8/5/1997 ShipVia=2 Freight=116.5300 ShipName=Great Lakes Food Market ShipAddress=2732 Baker Blvd. ShipCity=Eugene ShipRegion=OR ShipPostalCode=97403 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10894 CustomerID=SAVEA EmployeeID=1 OrderDate=2/18/1998 RequiredDate=3/18/1998 ShippedDate=2/20/1998 ShipVia=1 Freight=116.1300 ShipName=Save-a-lot Markets ShipAddress=187 Suffolk Ln. ShipCity=Boise ShipRegion=ID ShipPostalCode=83720 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10314 CustomerID=RATTC EmployeeID=1 OrderDate=9/25/1996 RequiredDate=10/23/1996 ShippedDate=10/4/1996 ShipVia=2 Freight=74.1600 ShipName=Rattlesnake Canyon Grocery ShipAddress=2817 Milton Dr. ShipCity=Albuquerque ShipRegion=NM ShipPostalCode=87110 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10469 CustomerID=WHITC EmployeeID=1 OrderDate=3/10/1997 RequiredDate=4/7/1997 ShippedDate=3/14/1997 ShipVia=1 Freight=60.1800 ShipName=White Clover Markets ShipAddress=1029 - 12th Ave. S. ShipCity=Seattle ShipRegion=WA ShipPostalCode=98124 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10598 CustomerID=RATTC EmployeeID=1 OrderDate=7/14/1997 RequiredDate=8/11/1997 ShippedDate=7/18/1997 ShipVia=3 Freight=44.4200 ShipName=Rattlesnake Canyon Grocery ShipAddress=2817 Milton Dr. ShipCity=Albuquerque ShipRegion=NM ShipPostalCode=87110 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10821 CustomerID=SPLIR EmployeeID=1 OrderDate=1/8/1998 RequiredDate=2/5/1998 ShippedDate=1/15/1998 ShipVia=1 Freight=36.6800 ShipName=Split Rail Beer & Ale ShipAddress=P.O. Box 555 ShipCity=Lander ShipRegion=WY ShipPostalCode=82520 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10385 CustomerID=SPLIR EmployeeID=1 OrderDate=12/17/1996 RequiredDate=1/14/1997 ShippedDate=12/23/1996 ShipVia=2 Freight=30.9600 ShipName=Split Rail Beer & Ale ShipAddress=P.O. Box 555 ShipCity=Lander ShipRegion=WY ShipPostalCode=82520 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10394 CustomerID=HUNGC EmployeeID=1 OrderDate=12/25/1996 RequiredDate=1/22/1997 ShippedDate=1/3/1997 ShipVia=3 Freight=30.3400 ShipName=Hungry Coyote Import Store ShipAddress=City Center Plaza 516 Main St. ShipCity=Elgin ShipRegion=OR ShipPostalCode=97827 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=11064 CustomerID=SAVEA EmployeeID=1 OrderDate=5/1/1998 RequiredDate=5/29/1998 ShippedDate=5/4/1998 ShipVia=1 Freight=30.0900 ShipName=Save-a-lot Markets ShipAddress=187 Suffolk Ln. ShipCity=Boise ShipRegion=ID ShipPostalCode=83720 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10680 CustomerID=OLDWO EmployeeID=1 OrderDate=9/24/1997 RequiredDate=10/22/1997 ShippedDate=9/26/1997 ShipVia=1 Freight=26.6100 ShipName=Old World Delicatessen ShipAddress=2743 Bering St. ShipCity=Anchorage ShipRegion=AK ShipPostalCode=99508 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10665 CustomerID=LONEP EmployeeID=1 OrderDate=9/11/1997 RequiredDate=10/9/1997 ShippedDate=9/17/1997 ShipVia=2 Freight=26.3100 ShipName=Lonesome Pine Restaurant ShipAddress=89 Chiaroscuro Rd. ShipCity=Portland ShipRegion=OR ShipPostalCode=97219 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10579 CustomerID=LETSS EmployeeID=1 OrderDate=6/25/1997 RequiredDate=7/23/1997 ShippedDate=7/4/1997 ShipVia=2 Freight=13.7300 ShipName=Let's Stop N Shop ShipAddress=87 Polk St. Suite 5 ShipCity=San Francisco ShipRegion=CA ShipPostalCode=94117 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10401 CustomerID=RATTC EmployeeID=1 OrderDate=1/1/1997 RequiredDate=1/29/1997 ShippedDate=1/10/1997 ShipVia=1 Freight=12.5100 ShipName=Rattlesnake Canyon Grocery ShipAddress=2817 Milton Dr. ShipCity=Albuquerque ShipRegion=NM ShipPostalCode=87110 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=11077 CustomerID=RATTC EmployeeID=1 OrderDate=5/6/1998 RequiredDate=6/3/1998 ShippedDate=null ShipVia=2 Freight=8.5300 ShipName=Rattlesnake Canyon Grocery ShipAddress=2817 Milton Dr. ShipCity=Albuquerque ShipRegion=NM ShipPostalCode=87110 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10482 CustomerID=LAZYK EmployeeID=1 OrderDate=3/21/1997 RequiredDate=4/18/1997 ShippedDate=4/10/1997 ShipVia=3 Freight=7.4800 ShipName=Lazy K Kountry Store ShipAddress=12 Orchestra Terrace ShipCity=Walla Walla ShipRegion=WA ShipPostalCode=99362 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10992 CustomerID=THEBI EmployeeID=1 OrderDate=4/1/1998 RequiredDate=4/29/1998 ShippedDate=4/3/1998 ShipVia=3 Freight=4.2700 ShipName=The Big Cheese ShipAddress=89 Jefferson Way Suite 2 ShipCity=Portland ShipRegion=OR ShipPostalCode=97201 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10461 CustomerID=LILAS EmployeeID=1 OrderDate=2/28/1997 RequiredDate=3/28/1997 ShippedDate=3/5/1997 ShipVia=3 Freight=148.6100 ShipName=LILA-Supermercado ShipAddress=Carrera 52 con Ave. Bolívar #65-98 Llano Largo ShipCity=Barquisimeto ShipRegion=Lara ShipPostalCode=3508 ShipCountry=Venezuela Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=11039 CustomerID=LINOD EmployeeID=1 OrderDate=4/21/1998 RequiredDate=5/19/1998 ShippedDate=null ShipVia=2 Freight=65.0000 ShipName=LINO-Delicateses ShipAddress=Ave. 5 de Mayo Porlamar ShipCity=I. de Margarita ShipRegion=Nueva Esparta ShipPostalCode=4980 ShipCountry=Venezuela Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10976 CustomerID=HILAA EmployeeID=1 OrderDate=3/25/1998 RequiredDate=5/6/1998 ShippedDate=4/3/1998 ShipVia=1 Freight=37.9700 ShipName=HILARION-Abastos ShipAddress=Carrera 22 con Ave. Carlos Soublette #8-35 ShipCity=San Cristóbal ShipRegion=Táchira ShipPostalCode=5022 ShipCountry=Venezuela Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10357 CustomerID=LILAS EmployeeID=1 OrderDate=11/19/1996 RequiredDate=12/17/1996 ShippedDate=12/2/1996 ShipVia=3 Freight=34.8800 ShipName=LILA-Supermercado ShipAddress=Carrera 52 con Ave. Bolívar #65-98 Llano Largo ShipCity=Barquisimeto ShipRegion=Lara ShipPostalCode=3508 ShipCountry=Venezuela Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10405 CustomerID=LINOD EmployeeID=1 OrderDate=1/6/1997 RequiredDate=2/3/1997 ShippedDate=1/22/1997 ShipVia=1 Freight=34.8200 ShipName=LINO-Delicateses ShipAddress=Ave. 5 de Mayo Porlamar ShipCity=I. de Margarita ShipRegion=Nueva Esparta ShipPostalCode=4980 ShipCountry=Venezuela Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10486 CustomerID=HILAA EmployeeID=1 OrderDate=3/26/1997 RequiredDate=4/23/1997 ShippedDate=4/2/1997 ShipVia=2 Freight=30.5300 ShipName=HILARION-Abastos ShipAddress=Carrera 22 con Ave. Carlos Soublette #8-35 ShipCity=San Cristóbal ShipRegion=Táchira ShipPostalCode=5022 ShipCountry=Venezuela Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10785 CustomerID=GROSR EmployeeID=1 OrderDate=12/18/1997 RequiredDate=1/15/1998 ShippedDate=12/24/1997 ShipVia=3 Freight=1.5100 ShipName=GROSELLA-Restaurante ShipAddress=5ª Ave. Los Palos Grandes ShipCity=Caracas ShipRegion=DF ShipPostalCode=1081 ShipCountry=Venezuela Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=11071 CustomerID=LILAS EmployeeID=1 OrderDate=5/5/1998 RequiredDate=6/2/1998 ShippedDate=null ShipVia=1 Freight=0.9300 ShipName=LILA-Supermercado ShipAddress=Carrera 52 con Ave. Bolívar #65-98 Llano Largo ShipCity=Barquisimeto ShipRegion=Lara ShipPostalCode=3508 ShipCountry=Venezuela Order_Details=... Employee={ } Customer={ } Shipper={ }
This sample uses Orderby, Max and Group By to find the Products that have the highest unit price in each category, and sorts the group by category id.
Public Sub LinqToSqlOrderBy06()
Dim categories = From p In db.Products _
Group p By p.CategoryID Into Group _
Order By CategoryID _
Select New With {Group, _
.MostExpensiveProducts = _
From p2 In Group _
Where p2.UnitPrice = Group.Max(Function(p3) p3.UnitPrice) _
Select p2}
ObjectDumper.Write(categories, 1)
End Sub
Result:
Group=... MostExpensiveProducts=...
Group: ProductID=1 ProductName=Chai SupplierID=1 CategoryID=1 QuantityPerUnit=10 boxes x 20 bags UnitPrice=18.0000 UnitsInStock=39 UnitsOnOrder=0 ReorderLevel=10 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=2 ProductName=Chang SupplierID=1 CategoryID=1 QuantityPerUnit=24 - 12 oz bottles UnitPrice=19.0000 UnitsInStock=17 UnitsOnOrder=40 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=24 ProductName=Guaraná Fantástica SupplierID=10 CategoryID=1 QuantityPerUnit=12 - 355 ml cans UnitPrice=5.5000 UnitsInStock=20 UnitsOnOrder=0 ReorderLevel=0 Discontinued=True Order_Details=... Category={ } Supplier={ }
Group: ProductID=34 ProductName=Sasquatch Ale SupplierID=16 CategoryID=1 QuantityPerUnit=24 - 12 oz bottles UnitPrice=15.0000 UnitsInStock=111 UnitsOnOrder=0 ReorderLevel=15 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=35 ProductName=Steeleye Stout SupplierID=16 CategoryID=1 QuantityPerUnit=24 - 12 oz bottles UnitPrice=19.0000 UnitsInStock=20 UnitsOnOrder=0 ReorderLevel=15 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=38 ProductName=Côte de Blaye SupplierID=18 CategoryID=1 QuantityPerUnit=12 - 75 cl bottles UnitPrice=264.5000 UnitsInStock=17 UnitsOnOrder=0 ReorderLevel=15 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=39 ProductName=Chartreuse verte SupplierID=18 CategoryID=1 QuantityPerUnit=750 cc per bottle UnitPrice=19.0000 UnitsInStock=69 UnitsOnOrder=0 ReorderLevel=5 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=43 ProductName=Ipoh Coffee SupplierID=20 CategoryID=1 QuantityPerUnit=16 - 500 g tins UnitPrice=47.0000 UnitsInStock=17 UnitsOnOrder=10 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=67 ProductName=Laughing Lumberjack Lager SupplierID=16 CategoryID=1 QuantityPerUnit=24 - 12 oz bottles UnitPrice=15.0000 UnitsInStock=52 UnitsOnOrder=0 ReorderLevel=10 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=70 ProductName=Outback Lager SupplierID=7 CategoryID=1 QuantityPerUnit=24 - 355 ml bottles UnitPrice=16.0000 UnitsInStock=15 UnitsOnOrder=10 ReorderLevel=30 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=75 ProductName=Rhönbräu Klosterbier SupplierID=12 CategoryID=1 QuantityPerUnit=24 - 0.5 l bottles UnitPrice=8.7500 UnitsInStock=125 UnitsOnOrder=0 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=76 ProductName=Lakkalikööri SupplierID=23 CategoryID=1 QuantityPerUnit=500 ml UnitPrice=19.0000 UnitsInStock=57 UnitsOnOrder=0 ReorderLevel=20 Discontinued=False Order_Details=... Category={ } Supplier={ }
MostExpensiveProducts: ProductID=38 ProductName=Côte de Blaye SupplierID=18 CategoryID=1 QuantityPerUnit=12 - 75 cl bottles UnitPrice=264.5000 UnitsInStock=17 UnitsOnOrder=0 ReorderLevel=15 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group=... MostExpensiveProducts=...
Group: ProductID=3 ProductName=Aniseed Syrup SupplierID=1 CategoryID=2 QuantityPerUnit=12 - 550 ml bottles UnitPrice=10.0000 UnitsInStock=13 UnitsOnOrder=70 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=4 ProductName=Chef Anton's Cajun Seasoning SupplierID=2 CategoryID=2 QuantityPerUnit=48 - 6 oz jars UnitPrice=22.0000 UnitsInStock=53 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=5 ProductName=Chef Anton's Gumbo Mix SupplierID=2 CategoryID=2 QuantityPerUnit=36 boxes UnitPrice=22.3500 UnitsInStock=0 UnitsOnOrder=0 ReorderLevel=0 Discontinued=True Order_Details=... Category={ } Supplier={ }
Group: ProductID=6 ProductName=Grandma's Boysenberry Spread SupplierID=3 CategoryID=2 QuantityPerUnit=12 - 8 oz jars UnitPrice=26.0000 UnitsInStock=120 UnitsOnOrder=0 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=8 ProductName=Northwoods Cranberry Sauce SupplierID=3 CategoryID=2 QuantityPerUnit=12 - 12 oz jars UnitPrice=41.0000 UnitsInStock=6 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=15 ProductName=Genen Shouyu SupplierID=6 CategoryID=2 QuantityPerUnit=24 - 250 ml bottles UnitPrice=16.5000 UnitsInStock=39 UnitsOnOrder=0 ReorderLevel=5 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=44 ProductName=Gula Malacca SupplierID=20 CategoryID=2 QuantityPerUnit=20 - 2 kg bags UnitPrice=20.4500 UnitsInStock=27 UnitsOnOrder=0 ReorderLevel=15 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=61 ProductName=Sirop d'érable SupplierID=29 CategoryID=2 QuantityPerUnit=24 - 500 ml bottles UnitPrice=29.5000 UnitsInStock=113 UnitsOnOrder=0 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=63 ProductName=Vegie-spread SupplierID=7 CategoryID=2 QuantityPerUnit=15 - 625 g jars UnitPrice=44.9000 UnitsInStock=24 UnitsOnOrder=0 ReorderLevel=5 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=65 ProductName=Louisiana Fiery Hot Pepper Sauce SupplierID=2 CategoryID=2 QuantityPerUnit=32 - 8 oz bottles UnitPrice=22.0500 UnitsInStock=76 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=66 ProductName=Louisiana Hot Spiced Okra SupplierID=2 CategoryID=2 QuantityPerUnit=24 - 8 oz jars UnitPrice=18.0000 UnitsInStock=4 UnitsOnOrder=100 ReorderLevel=20 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=77 ProductName=Original Frankfurter grüne Soße SupplierID=12 CategoryID=2 QuantityPerUnit=12 boxes UnitPrice=14.0000 UnitsInStock=32 UnitsOnOrder=0 ReorderLevel=15 Discontinued=False Order_Details=... Category={ } Supplier={ }
MostExpensiveProducts: ProductID=63 ProductName=Vegie-spread SupplierID=7 CategoryID=2 QuantityPerUnit=15 - 625 g jars UnitPrice=44.9000 UnitsInStock=24 UnitsOnOrder=0 ReorderLevel=5 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group=... MostExpensiveProducts=...
Group: ProductID=16 ProductName=Pavlova SupplierID=7 CategoryID=3 QuantityPerUnit=32 - 500 g boxes UnitPrice=18.4500 UnitsInStock=29 UnitsOnOrder=0 ReorderLevel=10 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=19 ProductName=Teatime Chocolate Biscuits SupplierID=8 CategoryID=3 QuantityPerUnit=10 boxes x 12 pieces UnitPrice=10.2000 UnitsInStock=25 UnitsOnOrder=0 ReorderLevel=5 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=20 ProductName=Sir Rodney's Marmalade SupplierID=8 CategoryID=3 QuantityPerUnit=30 gift boxes UnitPrice=82.0000 UnitsInStock=40 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=21 ProductName=Sir Rodney's Scones SupplierID=8 CategoryID=3 QuantityPerUnit=24 pkgs. x 4 pieces UnitPrice=11.0000 UnitsInStock=3 UnitsOnOrder=40 ReorderLevel=5 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=25 ProductName=NuNuCa Nuß-Nougat-Creme SupplierID=11 CategoryID=3 QuantityPerUnit=20 - 450 g glasses UnitPrice=15.0000 UnitsInStock=76 UnitsOnOrder=0 ReorderLevel=30 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=26 ProductName=Gumbär Gummibärchen SupplierID=11 CategoryID=3 QuantityPerUnit=100 - 250 g bags UnitPrice=32.2300 UnitsInStock=15 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=27 ProductName=Schoggi Schokolade SupplierID=11 CategoryID=3 QuantityPerUnit=100 - 100 g pieces UnitPrice=44.9000 UnitsInStock=49 UnitsOnOrder=0 ReorderLevel=30 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=47 ProductName=Zaanse koeken SupplierID=22 CategoryID=3 QuantityPerUnit=10 - 4 oz boxes UnitPrice=10.5000 UnitsInStock=36 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=48 ProductName=Chocolade SupplierID=22 CategoryID=3 QuantityPerUnit=10 pkgs. UnitPrice=13.7500 UnitsInStock=15 UnitsOnOrder=70 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=49 ProductName=Maxilaku SupplierID=23 CategoryID=3 QuantityPerUnit=24 - 50 g pkgs. UnitPrice=21.0000 UnitsInStock=10 UnitsOnOrder=60 ReorderLevel=15 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=50 ProductName=Valkoinen suklaa SupplierID=23 CategoryID=3 QuantityPerUnit=12 - 100 g bars UnitPrice=17.2500 UnitsInStock=65 UnitsOnOrder=0 ReorderLevel=30 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=62 ProductName=Tarte au sucre SupplierID=29 CategoryID=3 QuantityPerUnit=48 pies UnitPrice=50.3000 UnitsInStock=17 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=68 ProductName=Scottish Longbreads SupplierID=8 CategoryID=3 QuantityPerUnit=10 boxes x 8 pieces UnitPrice=13.5000 UnitsInStock=6 UnitsOnOrder=10 ReorderLevel=15 Discontinued=False Order_Details=... Category={ } Supplier={ }
MostExpensiveProducts: ProductID=20 ProductName=Sir Rodney's Marmalade SupplierID=8 CategoryID=3 QuantityPerUnit=30 gift boxes UnitPrice=82.0000 UnitsInStock=40 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group=... MostExpensiveProducts=...
Group: ProductID=11 ProductName=Queso Cabrales SupplierID=5 CategoryID=4 QuantityPerUnit=1 kg pkg. UnitPrice=22.0000 UnitsInStock=22 UnitsOnOrder=30 ReorderLevel=30 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=12 ProductName=Queso Manchego La Pastora SupplierID=5 CategoryID=4 QuantityPerUnit=10 - 500 g pkgs. UnitPrice=39.0000 UnitsInStock=86 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=31 ProductName=Gorgonzola Telino SupplierID=14 CategoryID=4 QuantityPerUnit=12 - 100 g pkgs UnitPrice=13.5000 UnitsInStock=0 UnitsOnOrder=70 ReorderLevel=20 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=32 ProductName=Mascarpone Fabioli SupplierID=14 CategoryID=4 QuantityPerUnit=24 - 200 g pkgs. UnitPrice=33.0000 UnitsInStock=9 UnitsOnOrder=40 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=33 ProductName=Geitost SupplierID=15 CategoryID=4 QuantityPerUnit=500 g UnitPrice=3.5000 UnitsInStock=112 UnitsOnOrder=0 ReorderLevel=20 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=59 ProductName=Raclette Courdavault SupplierID=28 CategoryID=4 QuantityPerUnit=5 kg pkg. UnitPrice=56.0000 UnitsInStock=79 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=60 ProductName=Camembert Pierrot SupplierID=28 CategoryID=4 QuantityPerUnit=15 - 300 g rounds UnitPrice=35.0000 UnitsInStock=19 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=69 ProductName=Gudbrandsdalsost SupplierID=15 CategoryID=4 QuantityPerUnit=10 kg pkg. UnitPrice=37.0000 UnitsInStock=26 UnitsOnOrder=0 ReorderLevel=15 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=71 ProductName=Flotemysost SupplierID=15 CategoryID=4 QuantityPerUnit=10 - 500 g pkgs. UnitPrice=22.5000 UnitsInStock=26 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=72 ProductName=Mozzarella di Giovanni SupplierID=14 CategoryID=4 QuantityPerUnit=24 - 200 g pkgs. UnitPrice=35.8000 UnitsInStock=14 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
MostExpensiveProducts: ProductID=59 ProductName=Raclette Courdavault SupplierID=28 CategoryID=4 QuantityPerUnit=5 kg pkg. UnitPrice=56.0000 UnitsInStock=79 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group=... MostExpensiveProducts=...
Group: ProductID=22 ProductName=Gustaf's Knäckebröd SupplierID=9 CategoryID=5 QuantityPerUnit=24 - 500 g pkgs. UnitPrice=22.0000 UnitsInStock=104 UnitsOnOrder=0 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=23 ProductName=Tunnbröd SupplierID=9 CategoryID=5 QuantityPerUnit=12 - 250 g pkgs. UnitPrice=10.0000 UnitsInStock=61 UnitsOnOrder=0 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=42 ProductName=Singaporean Hokkien Fried Mee SupplierID=20 CategoryID=5 QuantityPerUnit=32 - 1 kg pkgs. UnitPrice=15.0000 UnitsInStock=26 UnitsOnOrder=0 ReorderLevel=0 Discontinued=True Order_Details=... Category={ } Supplier={ }
Group: ProductID=52 ProductName=Filo Mix SupplierID=24 CategoryID=5 QuantityPerUnit=16 - 2 kg boxes UnitPrice=8.0000 UnitsInStock=38 UnitsOnOrder=0 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=56 ProductName=Gnocchi di nonna Alice SupplierID=26 CategoryID=5 QuantityPerUnit=24 - 250 g pkgs. UnitPrice=39.0000 UnitsInStock=21 UnitsOnOrder=10 ReorderLevel=30 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=57 ProductName=Ravioli Angelo SupplierID=26 CategoryID=5 QuantityPerUnit=24 - 250 g pkgs. UnitPrice=20.5000 UnitsInStock=36 UnitsOnOrder=0 ReorderLevel=20 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=64 ProductName=Wimmers gute Semmelknödel SupplierID=12 CategoryID=5 QuantityPerUnit=20 bags x 4 pieces UnitPrice=34.2500 UnitsInStock=22 UnitsOnOrder=80 ReorderLevel=30 Discontinued=False Order_Details=... Category={ } Supplier={ }
MostExpensiveProducts: ProductID=56 ProductName=Gnocchi di nonna Alice SupplierID=26 CategoryID=5 QuantityPerUnit=24 - 250 g pkgs. UnitPrice=39.0000 UnitsInStock=21 UnitsOnOrder=10 ReorderLevel=30 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group=... MostExpensiveProducts=...
Group: ProductID=9 ProductName=Mishi Kobe Niku SupplierID=4 CategoryID=6 QuantityPerUnit=18 - 500 g pkgs. UnitPrice=98.0000 UnitsInStock=29 UnitsOnOrder=0 ReorderLevel=0 Discontinued=True Order_Details=... Category={ } Supplier={ }
Group: ProductID=17 ProductName=Alice Mutton SupplierID=7 CategoryID=6 QuantityPerUnit=20 - 1 kg tins UnitPrice=40.0000 UnitsInStock=0 UnitsOnOrder=0 ReorderLevel=0 Discontinued=True Order_Details=... Category={ } Supplier={ }
Group: ProductID=29 ProductName=Thüringer Rostbratwurst SupplierID=12 CategoryID=6 QuantityPerUnit=50 bags x 30 sausgs. UnitPrice=124.7900 UnitsInStock=0 UnitsOnOrder=0 ReorderLevel=0 Discontinued=True Order_Details=... Category={ } Supplier={ }
Group: ProductID=53 ProductName=Perth Pasties SupplierID=24 CategoryID=6 QuantityPerUnit=48 pieces UnitPrice=33.8000 UnitsInStock=0 UnitsOnOrder=0 ReorderLevel=0 Discontinued=True Order_Details=... Category={ } Supplier={ }
Group: ProductID=54 ProductName=Tourtière SupplierID=25 CategoryID=6 QuantityPerUnit=16 pies UnitPrice=8.4500 UnitsInStock=21 UnitsOnOrder=0 ReorderLevel=10 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=55 ProductName=Pâté chinois SupplierID=25 CategoryID=6 QuantityPerUnit=24 boxes x 2 pies UnitPrice=25.0000 UnitsInStock=115 UnitsOnOrder=0 ReorderLevel=20 Discontinued=False Order_Details=... Category={ } Supplier={ }
MostExpensiveProducts: ProductID=29 ProductName=Thüringer Rostbratwurst SupplierID=12 CategoryID=6 QuantityPerUnit=50 bags x 30 sausgs. UnitPrice=124.7900 UnitsInStock=0 UnitsOnOrder=0 ReorderLevel=0 Discontinued=True Order_Details=... Category={ } Supplier={ }
Group=... MostExpensiveProducts=...
Group: ProductID=7 ProductName=Uncle Bob's Organic Dried Pears SupplierID=3 CategoryID=7 QuantityPerUnit=12 - 1 lb pkgs. UnitPrice=31.0000 UnitsInStock=15 UnitsOnOrder=0 ReorderLevel=10 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=14 ProductName=Tofu SupplierID=6 CategoryID=7 QuantityPerUnit=40 - 100 g pkgs. UnitPrice=24.2500 UnitsInStock=35 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=28 ProductName=Rössle Sauerkraut SupplierID=12 CategoryID=7 QuantityPerUnit=25 - 825 g cans UnitPrice=46.6000 UnitsInStock=26 UnitsOnOrder=0 ReorderLevel=0 Discontinued=True Order_Details=... Category={ } Supplier={ }
Group: ProductID=51 ProductName=Manjimup Dried Apples SupplierID=24 CategoryID=7 QuantityPerUnit=50 - 300 g pkgs. UnitPrice=54.0000 UnitsInStock=20 UnitsOnOrder=0 ReorderLevel=10 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=74 ProductName=Longlife Tofu SupplierID=4 CategoryID=7 QuantityPerUnit=5 kg pkg. UnitPrice=11.0000 UnitsInStock=4 UnitsOnOrder=20 ReorderLevel=5 Discontinued=False Order_Details=... Category={ } Supplier={ }
MostExpensiveProducts: ProductID=51 ProductName=Manjimup Dried Apples SupplierID=24 CategoryID=7 QuantityPerUnit=50 - 300 g pkgs. UnitPrice=54.0000 UnitsInStock=20 UnitsOnOrder=0 ReorderLevel=10 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group=... MostExpensiveProducts=...
Group: ProductID=10 ProductName=Ikura SupplierID=4 CategoryID=8 QuantityPerUnit=12 - 200 ml jars UnitPrice=32.0000 UnitsInStock=31 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=13 ProductName=Konbu SupplierID=6 CategoryID=8 QuantityPerUnit=2 kg box UnitPrice=7.0000 UnitsInStock=24 UnitsOnOrder=0 ReorderLevel=5 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=18 ProductName=Carnarvon Tigers SupplierID=7 CategoryID=8 QuantityPerUnit=16 kg pkg. UnitPrice=63.5000 UnitsInStock=42 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=30 ProductName=Nord-Ost Matjeshering SupplierID=13 CategoryID=8 QuantityPerUnit=10 - 200 g glasses UnitPrice=26.8900 UnitsInStock=10 UnitsOnOrder=0 ReorderLevel=15 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=36 ProductName=Inlagd Sill SupplierID=17 CategoryID=8 QuantityPerUnit=24 - 250 g jars UnitPrice=20.0000 UnitsInStock=112 UnitsOnOrder=0 ReorderLevel=20 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=37 ProductName=Gravad lax SupplierID=17 CategoryID=8 QuantityPerUnit=12 - 500 g pkgs. UnitPrice=27.0000 UnitsInStock=11 UnitsOnOrder=50 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=40 ProductName=Boston Crab Meat SupplierID=19 CategoryID=8 QuantityPerUnit=24 - 4 oz tins UnitPrice=19.4000 UnitsInStock=123 UnitsOnOrder=0 ReorderLevel=30 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=41 ProductName=Jack's New England Clam Chowder SupplierID=19 CategoryID=8 QuantityPerUnit=12 - 12 oz cans UnitPrice=10.6500 UnitsInStock=85 UnitsOnOrder=0 ReorderLevel=10 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=45 ProductName=Rogede sild SupplierID=21 CategoryID=8 QuantityPerUnit=1k pkg. UnitPrice=10.5000 UnitsInStock=5 UnitsOnOrder=70 ReorderLevel=15 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=46 ProductName=Spegesild SupplierID=21 CategoryID=8 QuantityPerUnit=4 - 450 g glasses UnitPrice=13.0000 UnitsInStock=95 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=58 ProductName=Escargots de Bourgogne SupplierID=27 CategoryID=8 QuantityPerUnit=24 pieces UnitPrice=14.2500 UnitsInStock=62 UnitsOnOrder=0 ReorderLevel=20 Discontinued=False Order_Details=... Category={ } Supplier={ }
Group: ProductID=73 ProductName=Röd Kaviar SupplierID=17 CategoryID=8 QuantityPerUnit=24 - 150 g jars UnitPrice=16.0000 UnitsInStock=101 UnitsOnOrder=0 ReorderLevel=5 Discontinued=False Order_Details=... Category={ } Supplier={ }
MostExpensiveProducts: ProductID=18 ProductName=Carnarvon Tigers SupplierID=7 CategoryID=8 QuantityPerUnit=16 kg pkg. UnitPrice=63.5000 UnitsInStock=42 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
