COUNT/SUM/MIN/MAX/AVGOn This Page |
This sample uses Count to find the number of Customers in the database.
Public Sub LinqToSqlCount01()
Dim q = db.Customers.Count()
Console.WriteLine(q)
End Sub
Result:
91
This sample uses Count to find the number of Products in the database that are not discontinued.
Public Sub LinqToSqlCount02()
Dim q = (From p In db.Products _
Where Not p.Discontinued _
Select p).Count()
Console.WriteLine(q)
End Sub
Result:
69
This sample uses Sum to find the total freight over all Orders.
Public Sub LinqToSqlCount03()
Dim q = (From o In db.Orders _
Select o.Freight).Sum()
Console.WriteLine(q)
End Sub
Result:
64914.4400
This sample uses Sum to find the total number of units on order over all Products.
Public Sub LinqToSqlCount04()
Dim q = (From p In db.Products _
Select CInt(p.UnitsOnOrder.Value)).Sum()
Console.WriteLine(q)
End Sub
Result:
780
This sample uses Min to find the lowest unit price of any Product.
Public Sub LinqToSqlCount05()
Dim q = (From p In db.Products _
Select p.UnitPrice).Min()
Console.WriteLine(q)
End Sub
Result:
2.5000
This sample uses Min to find the lowest freight of any Order.
Public Sub LinqToSqlCount06()
Dim q = (From o In db.Orders _
Select o.Freight).Min()
Console.WriteLine(q)
End Sub
Result:
0.0200
This sample uses Min to find the Products that have the lowest unit price in each category.
Public Sub LinqToSqlCount07()
Dim categories = From p In db.Products _
Group p By p.CategoryID Into g = Group _
Select CategoryID = g, _
CheapestProducts = _
From p2 In g _
Where p2.UnitPrice = g.Min(Function(p3) p3.UnitPrice) _
Select p2
ObjectDumper.Write(categories, 1)
End Sub
Result:
CategoryID=... CheapestProducts=...
CategoryID: ProductID=1 ProductName=Chai SupplierID=1 CategoryID=1 QuantityPerUnit=10 boxes x 20 bags UnitPrice=777.7700 UnitsInStock=39 UnitsOnOrder=0 ReorderLevel=10 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: 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={ }
CategoryID: ProductID=24 ProductName=Guaraná Fantástica SupplierID=10 CategoryID=1 QuantityPerUnit=12 - 355 ml cans UnitPrice=4.5000 UnitsInStock=20 UnitsOnOrder=0 ReorderLevel=0 Discontinued=True Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=34 ProductName=Sasquatch Ale SupplierID=16 CategoryID=1 QuantityPerUnit=24 - 12 oz bottles UnitPrice=14.0000 UnitsInStock=111 UnitsOnOrder=0 ReorderLevel=15 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=35 ProductName=Steeleye Stout SupplierID=16 CategoryID=1 QuantityPerUnit=24 - 12 oz bottles UnitPrice=18.0000 UnitsInStock=20 UnitsOnOrder=0 ReorderLevel=15 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=38 ProductName=Côte de Blaye SupplierID=18 CategoryID=1 QuantityPerUnit=12 - 75 cl bottles UnitPrice=263.5000 UnitsInStock=17 UnitsOnOrder=0 ReorderLevel=15 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=39 ProductName=Chartreuse verte SupplierID=18 CategoryID=1 QuantityPerUnit=750 cc per bottle UnitPrice=18.0000 UnitsInStock=69 UnitsOnOrder=0 ReorderLevel=5 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=43 ProductName=Ipoh Coffee SupplierID=20 CategoryID=1 QuantityPerUnit=16 - 500 g tins UnitPrice=46.0000 UnitsInStock=17 UnitsOnOrder=10 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=67 ProductName=Laughing Lumberjack Lager SupplierID=16 CategoryID=1 QuantityPerUnit=24 - 12 oz bottles UnitPrice=14.0000 UnitsInStock=52 UnitsOnOrder=0 ReorderLevel=10 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=70 ProductName=Outback Lager SupplierID=7 CategoryID=1 QuantityPerUnit=24 - 355 ml bottles UnitPrice=15.0000 UnitsInStock=15 UnitsOnOrder=10 ReorderLevel=30 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=75 ProductName=Rhönbräu Klosterbier SupplierID=12 CategoryID=1 QuantityPerUnit=24 - 0.5 l bottles UnitPrice=7.7500 UnitsInStock=125 UnitsOnOrder=0 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=76 ProductName=Lakkalikööri SupplierID=23 CategoryID=1 QuantityPerUnit=500 ml UnitPrice=18.0000 UnitsInStock=57 UnitsOnOrder=0 ReorderLevel=20 Discontinued=False Order_Details=... Category={ } Supplier={ }
CheapestProducts: ProductID=24 ProductName=Guaraná Fantástica SupplierID=10 CategoryID=1 QuantityPerUnit=12 - 355 ml cans UnitPrice=4.5000 UnitsInStock=20 UnitsOnOrder=0 ReorderLevel=0 Discontinued=True Order_Details=... Category={ } Supplier={ }
CategoryID=... CheapestProducts=...
CategoryID: 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={ }
CategoryID: 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={ }
CategoryID: ProductID=5 ProductName=Chef Anton's Gumbo Mix SupplierID=2 CategoryID=2 QuantityPerUnit=36 boxes UnitPrice=21.3500 UnitsInStock=0 UnitsOnOrder=0 ReorderLevel=0 Discontinued=True Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=6 ProductName=Grandma's Boysenberry Spread SupplierID=3 CategoryID=2 QuantityPerUnit=12 - 8 oz jars UnitPrice=25.0000 UnitsInStock=120 UnitsOnOrder=0 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=8 ProductName=Northwoods Cranberry Sauce SupplierID=3 CategoryID=2 QuantityPerUnit=12 - 12 oz jars UnitPrice=40.0000 UnitsInStock=6 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=15 ProductName=Genen Shouyu SupplierID=6 CategoryID=2 QuantityPerUnit=24 - 250 ml bottles UnitPrice=15.5000 UnitsInStock=39 UnitsOnOrder=0 ReorderLevel=5 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=44 ProductName=Gula Malacca SupplierID=20 CategoryID=2 QuantityPerUnit=20 - 2 kg bags UnitPrice=19.4500 UnitsInStock=27 UnitsOnOrder=0 ReorderLevel=15 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=61 ProductName=Sirop d'érable SupplierID=29 CategoryID=2 QuantityPerUnit=24 - 500 ml bottles UnitPrice=28.5000 UnitsInStock=113 UnitsOnOrder=0 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=63 ProductName=Vegie-spread SupplierID=7 CategoryID=2 QuantityPerUnit=15 - 625 g jars UnitPrice=43.9000 UnitsInStock=24 UnitsOnOrder=0 ReorderLevel=5 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=65 ProductName=Louisiana Fiery Hot Pepper Sauce SupplierID=2 CategoryID=2 QuantityPerUnit=32 - 8 oz bottles UnitPrice=21.0500 UnitsInStock=76 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=66 ProductName=Louisiana Hot Spiced Okra SupplierID=2 CategoryID=2 QuantityPerUnit=24 - 8 oz jars UnitPrice=17.0000 UnitsInStock=4 UnitsOnOrder=100 ReorderLevel=20 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=77 ProductName=Original Frankfurter grüne Soße SupplierID=12 CategoryID=2 QuantityPerUnit=12 boxes UnitPrice=13.0000 UnitsInStock=32 UnitsOnOrder=0 ReorderLevel=15 Discontinued=False Order_Details=... Category={ } Supplier={ }
CheapestProducts: 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={ }
CategoryID=... CheapestProducts=...
CategoryID: ProductID=16 ProductName=Pavlova SupplierID=7 CategoryID=3 QuantityPerUnit=32 - 500 g boxes UnitPrice=17.4500 UnitsInStock=29 UnitsOnOrder=0 ReorderLevel=10 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=19 ProductName=Teatime Chocolate Biscuits SupplierID=8 CategoryID=3 QuantityPerUnit=10 boxes x 12 pieces UnitPrice=9.2000 UnitsInStock=25 UnitsOnOrder=0 ReorderLevel=5 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=20 ProductName=Sir Rodney's Marmalade SupplierID=8 CategoryID=3 QuantityPerUnit=30 gift boxes UnitPrice=81.0000 UnitsInStock=40 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=21 ProductName=Sir Rodney's Scones SupplierID=8 CategoryID=3 QuantityPerUnit=24 pkgs. x 4 pieces UnitPrice=10.0000 UnitsInStock=3 UnitsOnOrder=40 ReorderLevel=5 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=25 ProductName=NuNuCa Nuß-Nougat-Creme SupplierID=11 CategoryID=3 QuantityPerUnit=20 - 450 g glasses UnitPrice=14.0000 UnitsInStock=76 UnitsOnOrder=0 ReorderLevel=30 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=26 ProductName=Gumbär Gummibärchen SupplierID=11 CategoryID=3 QuantityPerUnit=100 - 250 g bags UnitPrice=31.2300 UnitsInStock=15 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=27 ProductName=Schoggi Schokolade SupplierID=11 CategoryID=3 QuantityPerUnit=100 - 100 g pieces UnitPrice=43.9000 UnitsInStock=49 UnitsOnOrder=0 ReorderLevel=30 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=47 ProductName=Zaanse koeken SupplierID=22 CategoryID=3 QuantityPerUnit=10 - 4 oz boxes UnitPrice=9.5000 UnitsInStock=36 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=48 ProductName=Chocolade SupplierID=22 CategoryID=3 QuantityPerUnit=10 pkgs. UnitPrice=12.7500 UnitsInStock=15 UnitsOnOrder=70 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=49 ProductName=Maxilaku SupplierID=23 CategoryID=3 QuantityPerUnit=24 - 50 g pkgs. UnitPrice=20.0000 UnitsInStock=10 UnitsOnOrder=60 ReorderLevel=15 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=50 ProductName=Valkoinen suklaa SupplierID=23 CategoryID=3 QuantityPerUnit=12 - 100 g bars UnitPrice=16.2500 UnitsInStock=65 UnitsOnOrder=0 ReorderLevel=30 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=62 ProductName=Tarte au sucre SupplierID=29 CategoryID=3 QuantityPerUnit=48 pies UnitPrice=49.3000 UnitsInStock=17 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=68 ProductName=Scottish Longbreads SupplierID=8 CategoryID=3 QuantityPerUnit=10 boxes x 8 pieces UnitPrice=12.5000 UnitsInStock=6 UnitsOnOrder=10 ReorderLevel=15 Discontinued=False Order_Details=... Category={ } Supplier={ }
CheapestProducts: ProductID=19 ProductName=Teatime Chocolate Biscuits SupplierID=8 CategoryID=3 QuantityPerUnit=10 boxes x 12 pieces UnitPrice=9.2000 UnitsInStock=25 UnitsOnOrder=0 ReorderLevel=5 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID=... CheapestProducts=...
CategoryID: ProductID=11 ProductName=Queso Cabrales SupplierID=5 CategoryID=4 QuantityPerUnit=1 kg pkg. UnitPrice=21.0000 UnitsInStock=22 UnitsOnOrder=30 ReorderLevel=30 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=12 ProductName=Queso Manchego La Pastora SupplierID=5 CategoryID=4 QuantityPerUnit=10 - 500 g pkgs. UnitPrice=38.0000 UnitsInStock=86 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=31 ProductName=Gorgonzola Telino SupplierID=14 CategoryID=4 QuantityPerUnit=12 - 100 g pkgs UnitPrice=12.5000 UnitsInStock=0 UnitsOnOrder=70 ReorderLevel=20 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=32 ProductName=Mascarpone Fabioli SupplierID=14 CategoryID=4 QuantityPerUnit=24 - 200 g pkgs. UnitPrice=32.0000 UnitsInStock=9 UnitsOnOrder=40 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=33 ProductName=Geitost SupplierID=15 CategoryID=4 QuantityPerUnit=500 g UnitPrice=2.5000 UnitsInStock=112 UnitsOnOrder=0 ReorderLevel=20 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=59 ProductName=Raclette Courdavault SupplierID=28 CategoryID=4 QuantityPerUnit=5 kg pkg. UnitPrice=55.0000 UnitsInStock=79 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=60 ProductName=Camembert Pierrot SupplierID=28 CategoryID=4 QuantityPerUnit=15 - 300 g rounds UnitPrice=34.0000 UnitsInStock=19 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=69 ProductName=Gudbrandsdalsost SupplierID=15 CategoryID=4 QuantityPerUnit=10 kg pkg. UnitPrice=36.0000 UnitsInStock=26 UnitsOnOrder=0 ReorderLevel=15 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=71 ProductName=Flotemysost SupplierID=15 CategoryID=4 QuantityPerUnit=10 - 500 g pkgs. UnitPrice=21.5000 UnitsInStock=26 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=72 ProductName=Mozzarella di Giovanni SupplierID=14 CategoryID=4 QuantityPerUnit=24 - 200 g pkgs. UnitPrice=34.8000 UnitsInStock=14 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
CheapestProducts: ProductID=33 ProductName=Geitost SupplierID=15 CategoryID=4 QuantityPerUnit=500 g UnitPrice=2.5000 UnitsInStock=112 UnitsOnOrder=0 ReorderLevel=20 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID=... CheapestProducts=...
CategoryID: ProductID=22 ProductName=Gustaf's Knäckebröd SupplierID=9 CategoryID=5 QuantityPerUnit=24 - 500 g pkgs. UnitPrice=21.0000 UnitsInStock=104 UnitsOnOrder=0 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=23 ProductName=Tunnbröd SupplierID=9 CategoryID=5 QuantityPerUnit=12 - 250 g pkgs. UnitPrice=9.0000 UnitsInStock=61 UnitsOnOrder=0 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=42 ProductName=Singaporean Hokkien Fried Mee SupplierID=20 CategoryID=5 QuantityPerUnit=32 - 1 kg pkgs. UnitPrice=14.0000 UnitsInStock=26 UnitsOnOrder=0 ReorderLevel=0 Discontinued=True Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=52 ProductName=Filo Mix SupplierID=24 CategoryID=5 QuantityPerUnit=16 - 2 kg boxes UnitPrice=7.0000 UnitsInStock=38 UnitsOnOrder=0 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=56 ProductName=Gnocchi di nonna Alice SupplierID=26 CategoryID=5 QuantityPerUnit=24 - 250 g pkgs. UnitPrice=38.0000 UnitsInStock=21 UnitsOnOrder=10 ReorderLevel=30 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=57 ProductName=Ravioli Angelo SupplierID=26 CategoryID=5 QuantityPerUnit=24 - 250 g pkgs. UnitPrice=19.5000 UnitsInStock=36 UnitsOnOrder=0 ReorderLevel=20 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=64 ProductName=Wimmers gute Semmelknödel SupplierID=12 CategoryID=5 QuantityPerUnit=20 bags x 4 pieces UnitPrice=33.2500 UnitsInStock=22 UnitsOnOrder=80 ReorderLevel=30 Discontinued=False Order_Details=... Category={ } Supplier={ }
CheapestProducts: ProductID=52 ProductName=Filo Mix SupplierID=24 CategoryID=5 QuantityPerUnit=16 - 2 kg boxes UnitPrice=7.0000 UnitsInStock=38 UnitsOnOrder=0 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID=... CheapestProducts=...
CategoryID: ProductID=9 ProductName=Mishi Kobe Niku SupplierID=4 CategoryID=6 QuantityPerUnit=18 - 500 g pkgs. UnitPrice=97.0000 UnitsInStock=29 UnitsOnOrder=0 ReorderLevel=0 Discontinued=True Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=17 ProductName=Alice Mutton SupplierID=7 CategoryID=6 QuantityPerUnit=20 - 1 kg tins UnitPrice=39.0000 UnitsInStock=0 UnitsOnOrder=0 ReorderLevel=0 Discontinued=True Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=29 ProductName=Thüringer Rostbratwurst SupplierID=12 CategoryID=6 QuantityPerUnit=50 bags x 30 sausgs. UnitPrice=123.7900 UnitsInStock=0 UnitsOnOrder=0 ReorderLevel=0 Discontinued=True Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=53 ProductName=Perth Pasties SupplierID=24 CategoryID=6 QuantityPerUnit=48 pieces UnitPrice=32.8000 UnitsInStock=0 UnitsOnOrder=0 ReorderLevel=0 Discontinued=True Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=54 ProductName=Tourtière SupplierID=25 CategoryID=6 QuantityPerUnit=16 pies UnitPrice=7.4500 UnitsInStock=21 UnitsOnOrder=0 ReorderLevel=10 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=55 ProductName=Pâté chinois SupplierID=25 CategoryID=6 QuantityPerUnit=24 boxes x 2 pies UnitPrice=24.0000 UnitsInStock=115 UnitsOnOrder=0 ReorderLevel=20 Discontinued=False Order_Details=... Category={ } Supplier={ }
CheapestProducts: ProductID=54 ProductName=Tourtière SupplierID=25 CategoryID=6 QuantityPerUnit=16 pies UnitPrice=7.4500 UnitsInStock=21 UnitsOnOrder=0 ReorderLevel=10 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID=... CheapestProducts=...
CategoryID: ProductID=7 ProductName=Uncle Bob's Organic Dried Pears SupplierID=3 CategoryID=7 QuantityPerUnit=12 - 1 lb pkgs. UnitPrice=30.0000 UnitsInStock=15 UnitsOnOrder=0 ReorderLevel=10 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=14 ProductName=Tofu SupplierID=6 CategoryID=7 QuantityPerUnit=40 - 100 g pkgs. UnitPrice=23.2500 UnitsInStock=35 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=28 ProductName=Rössle Sauerkraut SupplierID=12 CategoryID=7 QuantityPerUnit=25 - 825 g cans UnitPrice=45.6000 UnitsInStock=26 UnitsOnOrder=0 ReorderLevel=0 Discontinued=True Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=51 ProductName=Manjimup Dried Apples SupplierID=24 CategoryID=7 QuantityPerUnit=50 - 300 g pkgs. UnitPrice=53.0000 UnitsInStock=20 UnitsOnOrder=0 ReorderLevel=10 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=74 ProductName=Longlife Tofu SupplierID=4 CategoryID=7 QuantityPerUnit=5 kg pkg. UnitPrice=10.0000 UnitsInStock=4 UnitsOnOrder=20 ReorderLevel=5 Discontinued=False Order_Details=... Category={ } Supplier={ }
CheapestProducts: ProductID=74 ProductName=Longlife Tofu SupplierID=4 CategoryID=7 QuantityPerUnit=5 kg pkg. UnitPrice=10.0000 UnitsInStock=4 UnitsOnOrder=20 ReorderLevel=5 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID=... CheapestProducts=...
CategoryID: ProductID=10 ProductName=Ikura SupplierID=4 CategoryID=8 QuantityPerUnit=12 - 200 ml jars UnitPrice=31.0000 UnitsInStock=31 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=13 ProductName=Konbu SupplierID=6 CategoryID=8 QuantityPerUnit=2 kg box UnitPrice=6.0000 UnitsInStock=24 UnitsOnOrder=0 ReorderLevel=5 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=18 ProductName=Carnarvon Tigers SupplierID=7 CategoryID=8 QuantityPerUnit=16 kg pkg. UnitPrice=62.5000 UnitsInStock=42 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=30 ProductName=Nord-Ost Matjeshering SupplierID=13 CategoryID=8 QuantityPerUnit=10 - 200 g glasses UnitPrice=25.8900 UnitsInStock=10 UnitsOnOrder=0 ReorderLevel=15 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=36 ProductName=Inlagd Sill SupplierID=17 CategoryID=8 QuantityPerUnit=24 - 250 g jars UnitPrice=19.0000 UnitsInStock=112 UnitsOnOrder=0 ReorderLevel=20 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=37 ProductName=Gravad lax SupplierID=17 CategoryID=8 QuantityPerUnit=12 - 500 g pkgs. UnitPrice=26.0000 UnitsInStock=11 UnitsOnOrder=50 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=40 ProductName=Boston Crab Meat SupplierID=19 CategoryID=8 QuantityPerUnit=24 - 4 oz tins UnitPrice=18.4000 UnitsInStock=123 UnitsOnOrder=0 ReorderLevel=30 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=41 ProductName=Jack's New England Clam Chowder SupplierID=19 CategoryID=8 QuantityPerUnit=12 - 12 oz cans UnitPrice=9.6500 UnitsInStock=85 UnitsOnOrder=0 ReorderLevel=10 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=45 ProductName=Rogede sild SupplierID=21 CategoryID=8 QuantityPerUnit=1k pkg. UnitPrice=9.5000 UnitsInStock=5 UnitsOnOrder=70 ReorderLevel=15 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=46 ProductName=Spegesild SupplierID=21 CategoryID=8 QuantityPerUnit=4 - 450 g glasses UnitPrice=12.0000 UnitsInStock=95 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=58 ProductName=Escargots de Bourgogne SupplierID=27 CategoryID=8 QuantityPerUnit=24 pieces UnitPrice=13.2500 UnitsInStock=62 UnitsOnOrder=0 ReorderLevel=20 Discontinued=False Order_Details=... Category={ } Supplier={ }
CategoryID: ProductID=73 ProductName=Röd Kaviar SupplierID=17 CategoryID=8 QuantityPerUnit=24 - 150 g jars UnitPrice=15.0000 UnitsInStock=101 UnitsOnOrder=0 ReorderLevel=5 Discontinued=False Order_Details=... Category={ } Supplier={ }
CheapestProducts: ProductID=13 ProductName=Konbu SupplierID=6 CategoryID=8 QuantityPerUnit=2 kg box UnitPrice=6.0000 UnitsInStock=24 UnitsOnOrder=0 ReorderLevel=5 Discontinued=False Order_Details=... Category={ } Supplier={ }
This sample uses Max to find the latest hire date of any Employee.
Public Sub LinqToSqlCount08()
Dim q = (From e In db.Employees _
Select e.HireDate).Max()
Console.WriteLine(q)
End Sub
Result:
11/15/1994 12:00:00 AM
This sample uses Max to find the most units in stock of any Product.
Public Sub LinqToSqlCount09()
Dim q = (From p In db.Products _
Select p.UnitsInStock).Max()
Console.WriteLine(q)
End Sub
Result:
125
This sample uses Max to find the Products that have the highest unit price in each category.
Public Sub LinqToSqlCount10()
Dim categories = From p In db.Products _
Group p By p.CategoryID Into g = Group _
Select New With { _
g, _
.MostExpensiveProducts = _
From p2 In g _
Where p2.UnitPrice = g.Max(Function(p3) p3.UnitPrice) _
Select p2}
ObjectDumper.Write(categories, 1)
End Sub
Result:
g=... MostExpensiveProducts=...
g: ProductID=1 ProductName=Chai SupplierID=1 CategoryID=1 QuantityPerUnit=10 boxes x 20 bags UnitPrice=777.7700 UnitsInStock=39 UnitsOnOrder=0 ReorderLevel=10 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: 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={ }
g: ProductID=24 ProductName=Guaraná Fantástica SupplierID=10 CategoryID=1 QuantityPerUnit=12 - 355 ml cans UnitPrice=4.5000 UnitsInStock=20 UnitsOnOrder=0 ReorderLevel=0 Discontinued=True Order_Details=... Category={ } Supplier={ }
g: ProductID=34 ProductName=Sasquatch Ale SupplierID=16 CategoryID=1 QuantityPerUnit=24 - 12 oz bottles UnitPrice=14.0000 UnitsInStock=111 UnitsOnOrder=0 ReorderLevel=15 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=35 ProductName=Steeleye Stout SupplierID=16 CategoryID=1 QuantityPerUnit=24 - 12 oz bottles UnitPrice=18.0000 UnitsInStock=20 UnitsOnOrder=0 ReorderLevel=15 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=38 ProductName=Côte de Blaye SupplierID=18 CategoryID=1 QuantityPerUnit=12 - 75 cl bottles UnitPrice=263.5000 UnitsInStock=17 UnitsOnOrder=0 ReorderLevel=15 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=39 ProductName=Chartreuse verte SupplierID=18 CategoryID=1 QuantityPerUnit=750 cc per bottle UnitPrice=18.0000 UnitsInStock=69 UnitsOnOrder=0 ReorderLevel=5 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=43 ProductName=Ipoh Coffee SupplierID=20 CategoryID=1 QuantityPerUnit=16 - 500 g tins UnitPrice=46.0000 UnitsInStock=17 UnitsOnOrder=10 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=67 ProductName=Laughing Lumberjack Lager SupplierID=16 CategoryID=1 QuantityPerUnit=24 - 12 oz bottles UnitPrice=14.0000 UnitsInStock=52 UnitsOnOrder=0 ReorderLevel=10 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=70 ProductName=Outback Lager SupplierID=7 CategoryID=1 QuantityPerUnit=24 - 355 ml bottles UnitPrice=15.0000 UnitsInStock=15 UnitsOnOrder=10 ReorderLevel=30 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=75 ProductName=Rhönbräu Klosterbier SupplierID=12 CategoryID=1 QuantityPerUnit=24 - 0.5 l bottles UnitPrice=7.7500 UnitsInStock=125 UnitsOnOrder=0 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=76 ProductName=Lakkalikööri SupplierID=23 CategoryID=1 QuantityPerUnit=500 ml UnitPrice=18.0000 UnitsInStock=57 UnitsOnOrder=0 ReorderLevel=20 Discontinued=False Order_Details=... Category={ } Supplier={ }
MostExpensiveProducts: ProductID=1 ProductName=Chai SupplierID=1 CategoryID=1 QuantityPerUnit=10 boxes x 20 bags UnitPrice=777.7700 UnitsInStock=39 UnitsOnOrder=0 ReorderLevel=10 Discontinued=False Order_Details=... Category={ } Supplier={ }
g=... MostExpensiveProducts=...
g: 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={ }
g: 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={ }
g: ProductID=5 ProductName=Chef Anton's Gumbo Mix SupplierID=2 CategoryID=2 QuantityPerUnit=36 boxes UnitPrice=21.3500 UnitsInStock=0 UnitsOnOrder=0 ReorderLevel=0 Discontinued=True Order_Details=... Category={ } Supplier={ }
g: ProductID=6 ProductName=Grandma's Boysenberry Spread SupplierID=3 CategoryID=2 QuantityPerUnit=12 - 8 oz jars UnitPrice=25.0000 UnitsInStock=120 UnitsOnOrder=0 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=8 ProductName=Northwoods Cranberry Sauce SupplierID=3 CategoryID=2 QuantityPerUnit=12 - 12 oz jars UnitPrice=40.0000 UnitsInStock=6 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=15 ProductName=Genen Shouyu SupplierID=6 CategoryID=2 QuantityPerUnit=24 - 250 ml bottles UnitPrice=15.5000 UnitsInStock=39 UnitsOnOrder=0 ReorderLevel=5 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=44 ProductName=Gula Malacca SupplierID=20 CategoryID=2 QuantityPerUnit=20 - 2 kg bags UnitPrice=19.4500 UnitsInStock=27 UnitsOnOrder=0 ReorderLevel=15 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=61 ProductName=Sirop d'érable SupplierID=29 CategoryID=2 QuantityPerUnit=24 - 500 ml bottles UnitPrice=28.5000 UnitsInStock=113 UnitsOnOrder=0 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=63 ProductName=Vegie-spread SupplierID=7 CategoryID=2 QuantityPerUnit=15 - 625 g jars UnitPrice=43.9000 UnitsInStock=24 UnitsOnOrder=0 ReorderLevel=5 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=65 ProductName=Louisiana Fiery Hot Pepper Sauce SupplierID=2 CategoryID=2 QuantityPerUnit=32 - 8 oz bottles UnitPrice=21.0500 UnitsInStock=76 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=66 ProductName=Louisiana Hot Spiced Okra SupplierID=2 CategoryID=2 QuantityPerUnit=24 - 8 oz jars UnitPrice=17.0000 UnitsInStock=4 UnitsOnOrder=100 ReorderLevel=20 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=77 ProductName=Original Frankfurter grüne Soße SupplierID=12 CategoryID=2 QuantityPerUnit=12 boxes UnitPrice=13.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=43.9000 UnitsInStock=24 UnitsOnOrder=0 ReorderLevel=5 Discontinued=False Order_Details=... Category={ } Supplier={ }
g=... MostExpensiveProducts=...
g: ProductID=16 ProductName=Pavlova SupplierID=7 CategoryID=3 QuantityPerUnit=32 - 500 g boxes UnitPrice=17.4500 UnitsInStock=29 UnitsOnOrder=0 ReorderLevel=10 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=19 ProductName=Teatime Chocolate Biscuits SupplierID=8 CategoryID=3 QuantityPerUnit=10 boxes x 12 pieces UnitPrice=9.2000 UnitsInStock=25 UnitsOnOrder=0 ReorderLevel=5 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=20 ProductName=Sir Rodney's Marmalade SupplierID=8 CategoryID=3 QuantityPerUnit=30 gift boxes UnitPrice=81.0000 UnitsInStock=40 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=21 ProductName=Sir Rodney's Scones SupplierID=8 CategoryID=3 QuantityPerUnit=24 pkgs. x 4 pieces UnitPrice=10.0000 UnitsInStock=3 UnitsOnOrder=40 ReorderLevel=5 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=25 ProductName=NuNuCa Nuß-Nougat-Creme SupplierID=11 CategoryID=3 QuantityPerUnit=20 - 450 g glasses UnitPrice=14.0000 UnitsInStock=76 UnitsOnOrder=0 ReorderLevel=30 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=26 ProductName=Gumbär Gummibärchen SupplierID=11 CategoryID=3 QuantityPerUnit=100 - 250 g bags UnitPrice=31.2300 UnitsInStock=15 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=27 ProductName=Schoggi Schokolade SupplierID=11 CategoryID=3 QuantityPerUnit=100 - 100 g pieces UnitPrice=43.9000 UnitsInStock=49 UnitsOnOrder=0 ReorderLevel=30 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=47 ProductName=Zaanse koeken SupplierID=22 CategoryID=3 QuantityPerUnit=10 - 4 oz boxes UnitPrice=9.5000 UnitsInStock=36 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=48 ProductName=Chocolade SupplierID=22 CategoryID=3 QuantityPerUnit=10 pkgs. UnitPrice=12.7500 UnitsInStock=15 UnitsOnOrder=70 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=49 ProductName=Maxilaku SupplierID=23 CategoryID=3 QuantityPerUnit=24 - 50 g pkgs. UnitPrice=20.0000 UnitsInStock=10 UnitsOnOrder=60 ReorderLevel=15 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=50 ProductName=Valkoinen suklaa SupplierID=23 CategoryID=3 QuantityPerUnit=12 - 100 g bars UnitPrice=16.2500 UnitsInStock=65 UnitsOnOrder=0 ReorderLevel=30 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=62 ProductName=Tarte au sucre SupplierID=29 CategoryID=3 QuantityPerUnit=48 pies UnitPrice=49.3000 UnitsInStock=17 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=68 ProductName=Scottish Longbreads SupplierID=8 CategoryID=3 QuantityPerUnit=10 boxes x 8 pieces UnitPrice=12.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=81.0000 UnitsInStock=40 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
g=... MostExpensiveProducts=...
g: ProductID=11 ProductName=Queso Cabrales SupplierID=5 CategoryID=4 QuantityPerUnit=1 kg pkg. UnitPrice=21.0000 UnitsInStock=22 UnitsOnOrder=30 ReorderLevel=30 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=12 ProductName=Queso Manchego La Pastora SupplierID=5 CategoryID=4 QuantityPerUnit=10 - 500 g pkgs. UnitPrice=38.0000 UnitsInStock=86 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=31 ProductName=Gorgonzola Telino SupplierID=14 CategoryID=4 QuantityPerUnit=12 - 100 g pkgs UnitPrice=12.5000 UnitsInStock=0 UnitsOnOrder=70 ReorderLevel=20 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=32 ProductName=Mascarpone Fabioli SupplierID=14 CategoryID=4 QuantityPerUnit=24 - 200 g pkgs. UnitPrice=32.0000 UnitsInStock=9 UnitsOnOrder=40 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=33 ProductName=Geitost SupplierID=15 CategoryID=4 QuantityPerUnit=500 g UnitPrice=2.5000 UnitsInStock=112 UnitsOnOrder=0 ReorderLevel=20 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=59 ProductName=Raclette Courdavault SupplierID=28 CategoryID=4 QuantityPerUnit=5 kg pkg. UnitPrice=55.0000 UnitsInStock=79 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=60 ProductName=Camembert Pierrot SupplierID=28 CategoryID=4 QuantityPerUnit=15 - 300 g rounds UnitPrice=34.0000 UnitsInStock=19 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=69 ProductName=Gudbrandsdalsost SupplierID=15 CategoryID=4 QuantityPerUnit=10 kg pkg. UnitPrice=36.0000 UnitsInStock=26 UnitsOnOrder=0 ReorderLevel=15 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=71 ProductName=Flotemysost SupplierID=15 CategoryID=4 QuantityPerUnit=10 - 500 g pkgs. UnitPrice=21.5000 UnitsInStock=26 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=72 ProductName=Mozzarella di Giovanni SupplierID=14 CategoryID=4 QuantityPerUnit=24 - 200 g pkgs. UnitPrice=34.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=55.0000 UnitsInStock=79 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
g=... MostExpensiveProducts=...
g: ProductID=22 ProductName=Gustaf's Knäckebröd SupplierID=9 CategoryID=5 QuantityPerUnit=24 - 500 g pkgs. UnitPrice=21.0000 UnitsInStock=104 UnitsOnOrder=0 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=23 ProductName=Tunnbröd SupplierID=9 CategoryID=5 QuantityPerUnit=12 - 250 g pkgs. UnitPrice=9.0000 UnitsInStock=61 UnitsOnOrder=0 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=42 ProductName=Singaporean Hokkien Fried Mee SupplierID=20 CategoryID=5 QuantityPerUnit=32 - 1 kg pkgs. UnitPrice=14.0000 UnitsInStock=26 UnitsOnOrder=0 ReorderLevel=0 Discontinued=True Order_Details=... Category={ } Supplier={ }
g: ProductID=52 ProductName=Filo Mix SupplierID=24 CategoryID=5 QuantityPerUnit=16 - 2 kg boxes UnitPrice=7.0000 UnitsInStock=38 UnitsOnOrder=0 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=56 ProductName=Gnocchi di nonna Alice SupplierID=26 CategoryID=5 QuantityPerUnit=24 - 250 g pkgs. UnitPrice=38.0000 UnitsInStock=21 UnitsOnOrder=10 ReorderLevel=30 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=57 ProductName=Ravioli Angelo SupplierID=26 CategoryID=5 QuantityPerUnit=24 - 250 g pkgs. UnitPrice=19.5000 UnitsInStock=36 UnitsOnOrder=0 ReorderLevel=20 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=64 ProductName=Wimmers gute Semmelknödel SupplierID=12 CategoryID=5 QuantityPerUnit=20 bags x 4 pieces UnitPrice=33.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=38.0000 UnitsInStock=21 UnitsOnOrder=10 ReorderLevel=30 Discontinued=False Order_Details=... Category={ } Supplier={ }
g=... MostExpensiveProducts=...
g: ProductID=9 ProductName=Mishi Kobe Niku SupplierID=4 CategoryID=6 QuantityPerUnit=18 - 500 g pkgs. UnitPrice=97.0000 UnitsInStock=29 UnitsOnOrder=0 ReorderLevel=0 Discontinued=True Order_Details=... Category={ } Supplier={ }
g: ProductID=17 ProductName=Alice Mutton SupplierID=7 CategoryID=6 QuantityPerUnit=20 - 1 kg tins UnitPrice=39.0000 UnitsInStock=0 UnitsOnOrder=0 ReorderLevel=0 Discontinued=True Order_Details=... Category={ } Supplier={ }
g: ProductID=29 ProductName=Thüringer Rostbratwurst SupplierID=12 CategoryID=6 QuantityPerUnit=50 bags x 30 sausgs. UnitPrice=123.7900 UnitsInStock=0 UnitsOnOrder=0 ReorderLevel=0 Discontinued=True Order_Details=... Category={ } Supplier={ }
g: ProductID=53 ProductName=Perth Pasties SupplierID=24 CategoryID=6 QuantityPerUnit=48 pieces UnitPrice=32.8000 UnitsInStock=0 UnitsOnOrder=0 ReorderLevel=0 Discontinued=True Order_Details=... Category={ } Supplier={ }
g: ProductID=54 ProductName=Tourtière SupplierID=25 CategoryID=6 QuantityPerUnit=16 pies UnitPrice=7.4500 UnitsInStock=21 UnitsOnOrder=0 ReorderLevel=10 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=55 ProductName=Pâté chinois SupplierID=25 CategoryID=6 QuantityPerUnit=24 boxes x 2 pies UnitPrice=24.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=123.7900 UnitsInStock=0 UnitsOnOrder=0 ReorderLevel=0 Discontinued=True Order_Details=... Category={ } Supplier={ }
g=... MostExpensiveProducts=...
g: ProductID=7 ProductName=Uncle Bob's Organic Dried Pears SupplierID=3 CategoryID=7 QuantityPerUnit=12 - 1 lb pkgs. UnitPrice=30.0000 UnitsInStock=15 UnitsOnOrder=0 ReorderLevel=10 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=14 ProductName=Tofu SupplierID=6 CategoryID=7 QuantityPerUnit=40 - 100 g pkgs. UnitPrice=23.2500 UnitsInStock=35 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=28 ProductName=Rössle Sauerkraut SupplierID=12 CategoryID=7 QuantityPerUnit=25 - 825 g cans UnitPrice=45.6000 UnitsInStock=26 UnitsOnOrder=0 ReorderLevel=0 Discontinued=True Order_Details=... Category={ } Supplier={ }
g: ProductID=51 ProductName=Manjimup Dried Apples SupplierID=24 CategoryID=7 QuantityPerUnit=50 - 300 g pkgs. UnitPrice=53.0000 UnitsInStock=20 UnitsOnOrder=0 ReorderLevel=10 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=74 ProductName=Longlife Tofu SupplierID=4 CategoryID=7 QuantityPerUnit=5 kg pkg. UnitPrice=10.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=53.0000 UnitsInStock=20 UnitsOnOrder=0 ReorderLevel=10 Discontinued=False Order_Details=... Category={ } Supplier={ }
g=... MostExpensiveProducts=...
g: ProductID=10 ProductName=Ikura SupplierID=4 CategoryID=8 QuantityPerUnit=12 - 200 ml jars UnitPrice=31.0000 UnitsInStock=31 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=13 ProductName=Konbu SupplierID=6 CategoryID=8 QuantityPerUnit=2 kg box UnitPrice=6.0000 UnitsInStock=24 UnitsOnOrder=0 ReorderLevel=5 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=18 ProductName=Carnarvon Tigers SupplierID=7 CategoryID=8 QuantityPerUnit=16 kg pkg. UnitPrice=62.5000 UnitsInStock=42 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=30 ProductName=Nord-Ost Matjeshering SupplierID=13 CategoryID=8 QuantityPerUnit=10 - 200 g glasses UnitPrice=25.8900 UnitsInStock=10 UnitsOnOrder=0 ReorderLevel=15 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=36 ProductName=Inlagd Sill SupplierID=17 CategoryID=8 QuantityPerUnit=24 - 250 g jars UnitPrice=19.0000 UnitsInStock=112 UnitsOnOrder=0 ReorderLevel=20 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=37 ProductName=Gravad lax SupplierID=17 CategoryID=8 QuantityPerUnit=12 - 500 g pkgs. UnitPrice=26.0000 UnitsInStock=11 UnitsOnOrder=50 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=40 ProductName=Boston Crab Meat SupplierID=19 CategoryID=8 QuantityPerUnit=24 - 4 oz tins UnitPrice=18.4000 UnitsInStock=123 UnitsOnOrder=0 ReorderLevel=30 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=41 ProductName=Jack's New England Clam Chowder SupplierID=19 CategoryID=8 QuantityPerUnit=12 - 12 oz cans UnitPrice=9.6500 UnitsInStock=85 UnitsOnOrder=0 ReorderLevel=10 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=45 ProductName=Rogede sild SupplierID=21 CategoryID=8 QuantityPerUnit=1k pkg. UnitPrice=9.5000 UnitsInStock=5 UnitsOnOrder=70 ReorderLevel=15 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=46 ProductName=Spegesild SupplierID=21 CategoryID=8 QuantityPerUnit=4 - 450 g glasses UnitPrice=12.0000 UnitsInStock=95 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=58 ProductName=Escargots de Bourgogne SupplierID=27 CategoryID=8 QuantityPerUnit=24 pieces UnitPrice=13.2500 UnitsInStock=62 UnitsOnOrder=0 ReorderLevel=20 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=73 ProductName=Röd Kaviar SupplierID=17 CategoryID=8 QuantityPerUnit=24 - 150 g jars UnitPrice=15.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=62.5000 UnitsInStock=42 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
This sample uses Average to find the average freight of all Orders.
Public Sub LinqToSqlCount11()
Dim q = (From o In db.Orders _
Select o.Freight).Average()
Console.WriteLine(q)
End Sub
Result:
78.2101
This sample uses Average to find the average unit price of all Products.
Public Sub LinqToSqlCount12()
Dim q = (From p In db.Products _
Select p.UnitPrice).Average()
Console.WriteLine(q)
End Sub
Result:
38.7335
This sample uses Average to find the Products that have unit price higher than the average unit price of the category for each category.
Public Sub LinqToSqlCount13()
Dim categories = From p In db.Products _
Group p By p.CategoryID Into g = Group _
Select New With _
{g, _
.ExpensiveProducts = _
From p2 In g _
Where (p2.UnitPrice > g.Average(Function(p3) p3.UnitPrice)) _
Select p2}
ObjectDumper.Write(categories, 1)
End Sub
Result:
ExpensiveProducts=... g=...
ExpensiveProducts: ProductID=1 ProductName=Chai SupplierID=1 CategoryID=1 QuantityPerUnit=10 boxes x 20 bags UnitPrice=777.7700 UnitsInStock=39 UnitsOnOrder=0 ReorderLevel=10 Discontinued=False Order_Details=... Category={ } Supplier={ }
ExpensiveProducts: ProductID=38 ProductName=Côte de Blaye SupplierID=18 CategoryID=1 QuantityPerUnit=12 - 75 cl bottles UnitPrice=263.5000 UnitsInStock=17 UnitsOnOrder=0 ReorderLevel=15 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=1 ProductName=Chai SupplierID=1 CategoryID=1 QuantityPerUnit=10 boxes x 20 bags UnitPrice=777.7700 UnitsInStock=39 UnitsOnOrder=0 ReorderLevel=10 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: 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={ }
g: ProductID=24 ProductName=Guaraná Fantástica SupplierID=10 CategoryID=1 QuantityPerUnit=12 - 355 ml cans UnitPrice=4.5000 UnitsInStock=20 UnitsOnOrder=0 ReorderLevel=0 Discontinued=True Order_Details=... Category={ } Supplier={ }
g: ProductID=34 ProductName=Sasquatch Ale SupplierID=16 CategoryID=1 QuantityPerUnit=24 - 12 oz bottles UnitPrice=14.0000 UnitsInStock=111 UnitsOnOrder=0 ReorderLevel=15 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=35 ProductName=Steeleye Stout SupplierID=16 CategoryID=1 QuantityPerUnit=24 - 12 oz bottles UnitPrice=18.0000 UnitsInStock=20 UnitsOnOrder=0 ReorderLevel=15 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=38 ProductName=Côte de Blaye SupplierID=18 CategoryID=1 QuantityPerUnit=12 - 75 cl bottles UnitPrice=263.5000 UnitsInStock=17 UnitsOnOrder=0 ReorderLevel=15 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=39 ProductName=Chartreuse verte SupplierID=18 CategoryID=1 QuantityPerUnit=750 cc per bottle UnitPrice=18.0000 UnitsInStock=69 UnitsOnOrder=0 ReorderLevel=5 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=43 ProductName=Ipoh Coffee SupplierID=20 CategoryID=1 QuantityPerUnit=16 - 500 g tins UnitPrice=46.0000 UnitsInStock=17 UnitsOnOrder=10 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=67 ProductName=Laughing Lumberjack Lager SupplierID=16 CategoryID=1 QuantityPerUnit=24 - 12 oz bottles UnitPrice=14.0000 UnitsInStock=52 UnitsOnOrder=0 ReorderLevel=10 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=70 ProductName=Outback Lager SupplierID=7 CategoryID=1 QuantityPerUnit=24 - 355 ml bottles UnitPrice=15.0000 UnitsInStock=15 UnitsOnOrder=10 ReorderLevel=30 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=75 ProductName=Rhönbräu Klosterbier SupplierID=12 CategoryID=1 QuantityPerUnit=24 - 0.5 l bottles UnitPrice=7.7500 UnitsInStock=125 UnitsOnOrder=0 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=76 ProductName=Lakkalikööri SupplierID=23 CategoryID=1 QuantityPerUnit=500 ml UnitPrice=18.0000 UnitsInStock=57 UnitsOnOrder=0 ReorderLevel=20 Discontinued=False Order_Details=... Category={ } Supplier={ }
ExpensiveProducts=... g=...
ExpensiveProducts: ProductID=6 ProductName=Grandma's Boysenberry Spread SupplierID=3 CategoryID=2 QuantityPerUnit=12 - 8 oz jars UnitPrice=25.0000 UnitsInStock=120 UnitsOnOrder=0 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
ExpensiveProducts: ProductID=8 ProductName=Northwoods Cranberry Sauce SupplierID=3 CategoryID=2 QuantityPerUnit=12 - 12 oz jars UnitPrice=40.0000 UnitsInStock=6 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
ExpensiveProducts: ProductID=61 ProductName=Sirop d'érable SupplierID=29 CategoryID=2 QuantityPerUnit=24 - 500 ml bottles UnitPrice=28.5000 UnitsInStock=113 UnitsOnOrder=0 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
ExpensiveProducts: ProductID=63 ProductName=Vegie-spread SupplierID=7 CategoryID=2 QuantityPerUnit=15 - 625 g jars UnitPrice=43.9000 UnitsInStock=24 UnitsOnOrder=0 ReorderLevel=5 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: 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={ }
g: 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={ }
g: ProductID=5 ProductName=Chef Anton's Gumbo Mix SupplierID=2 CategoryID=2 QuantityPerUnit=36 boxes UnitPrice=21.3500 UnitsInStock=0 UnitsOnOrder=0 ReorderLevel=0 Discontinued=True Order_Details=... Category={ } Supplier={ }
g: ProductID=6 ProductName=Grandma's Boysenberry Spread SupplierID=3 CategoryID=2 QuantityPerUnit=12 - 8 oz jars UnitPrice=25.0000 UnitsInStock=120 UnitsOnOrder=0 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=8 ProductName=Northwoods Cranberry Sauce SupplierID=3 CategoryID=2 QuantityPerUnit=12 - 12 oz jars UnitPrice=40.0000 UnitsInStock=6 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=15 ProductName=Genen Shouyu SupplierID=6 CategoryID=2 QuantityPerUnit=24 - 250 ml bottles UnitPrice=15.5000 UnitsInStock=39 UnitsOnOrder=0 ReorderLevel=5 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=44 ProductName=Gula Malacca SupplierID=20 CategoryID=2 QuantityPerUnit=20 - 2 kg bags UnitPrice=19.4500 UnitsInStock=27 UnitsOnOrder=0 ReorderLevel=15 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=61 ProductName=Sirop d'érable SupplierID=29 CategoryID=2 QuantityPerUnit=24 - 500 ml bottles UnitPrice=28.5000 UnitsInStock=113 UnitsOnOrder=0 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=63 ProductName=Vegie-spread SupplierID=7 CategoryID=2 QuantityPerUnit=15 - 625 g jars UnitPrice=43.9000 UnitsInStock=24 UnitsOnOrder=0 ReorderLevel=5 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=65 ProductName=Louisiana Fiery Hot Pepper Sauce SupplierID=2 CategoryID=2 QuantityPerUnit=32 - 8 oz bottles UnitPrice=21.0500 UnitsInStock=76 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=66 ProductName=Louisiana Hot Spiced Okra SupplierID=2 CategoryID=2 QuantityPerUnit=24 - 8 oz jars UnitPrice=17.0000 UnitsInStock=4 UnitsOnOrder=100 ReorderLevel=20 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=77 ProductName=Original Frankfurter grüne Soße SupplierID=12 CategoryID=2 QuantityPerUnit=12 boxes UnitPrice=13.0000 UnitsInStock=32 UnitsOnOrder=0 ReorderLevel=15 Discontinued=False Order_Details=... Category={ } Supplier={ }
ExpensiveProducts=... g=...
ExpensiveProducts: ProductID=20 ProductName=Sir Rodney's Marmalade SupplierID=8 CategoryID=3 QuantityPerUnit=30 gift boxes UnitPrice=81.0000 UnitsInStock=40 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
ExpensiveProducts: ProductID=26 ProductName=Gumbär Gummibärchen SupplierID=11 CategoryID=3 QuantityPerUnit=100 - 250 g bags UnitPrice=31.2300 UnitsInStock=15 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
ExpensiveProducts: ProductID=27 ProductName=Schoggi Schokolade SupplierID=11 CategoryID=3 QuantityPerUnit=100 - 100 g pieces UnitPrice=43.9000 UnitsInStock=49 UnitsOnOrder=0 ReorderLevel=30 Discontinued=False Order_Details=... Category={ } Supplier={ }
ExpensiveProducts: ProductID=62 ProductName=Tarte au sucre SupplierID=29 CategoryID=3 QuantityPerUnit=48 pies UnitPrice=49.3000 UnitsInStock=17 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=16 ProductName=Pavlova SupplierID=7 CategoryID=3 QuantityPerUnit=32 - 500 g boxes UnitPrice=17.4500 UnitsInStock=29 UnitsOnOrder=0 ReorderLevel=10 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=19 ProductName=Teatime Chocolate Biscuits SupplierID=8 CategoryID=3 QuantityPerUnit=10 boxes x 12 pieces UnitPrice=9.2000 UnitsInStock=25 UnitsOnOrder=0 ReorderLevel=5 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=20 ProductName=Sir Rodney's Marmalade SupplierID=8 CategoryID=3 QuantityPerUnit=30 gift boxes UnitPrice=81.0000 UnitsInStock=40 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=21 ProductName=Sir Rodney's Scones SupplierID=8 CategoryID=3 QuantityPerUnit=24 pkgs. x 4 pieces UnitPrice=10.0000 UnitsInStock=3 UnitsOnOrder=40 ReorderLevel=5 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=25 ProductName=NuNuCa Nuß-Nougat-Creme SupplierID=11 CategoryID=3 QuantityPerUnit=20 - 450 g glasses UnitPrice=14.0000 UnitsInStock=76 UnitsOnOrder=0 ReorderLevel=30 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=26 ProductName=Gumbär Gummibärchen SupplierID=11 CategoryID=3 QuantityPerUnit=100 - 250 g bags UnitPrice=31.2300 UnitsInStock=15 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=27 ProductName=Schoggi Schokolade SupplierID=11 CategoryID=3 QuantityPerUnit=100 - 100 g pieces UnitPrice=43.9000 UnitsInStock=49 UnitsOnOrder=0 ReorderLevel=30 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=47 ProductName=Zaanse koeken SupplierID=22 CategoryID=3 QuantityPerUnit=10 - 4 oz boxes UnitPrice=9.5000 UnitsInStock=36 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=48 ProductName=Chocolade SupplierID=22 CategoryID=3 QuantityPerUnit=10 pkgs. UnitPrice=12.7500 UnitsInStock=15 UnitsOnOrder=70 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=49 ProductName=Maxilaku SupplierID=23 CategoryID=3 QuantityPerUnit=24 - 50 g pkgs. UnitPrice=20.0000 UnitsInStock=10 UnitsOnOrder=60 ReorderLevel=15 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=50 ProductName=Valkoinen suklaa SupplierID=23 CategoryID=3 QuantityPerUnit=12 - 100 g bars UnitPrice=16.2500 UnitsInStock=65 UnitsOnOrder=0 ReorderLevel=30 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=62 ProductName=Tarte au sucre SupplierID=29 CategoryID=3 QuantityPerUnit=48 pies UnitPrice=49.3000 UnitsInStock=17 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=68 ProductName=Scottish Longbreads SupplierID=8 CategoryID=3 QuantityPerUnit=10 boxes x 8 pieces UnitPrice=12.5000 UnitsInStock=6 UnitsOnOrder=10 ReorderLevel=15 Discontinued=False Order_Details=... Category={ } Supplier={ }
ExpensiveProducts=... g=...
ExpensiveProducts: ProductID=12 ProductName=Queso Manchego La Pastora SupplierID=5 CategoryID=4 QuantityPerUnit=10 - 500 g pkgs. UnitPrice=38.0000 UnitsInStock=86 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
ExpensiveProducts: ProductID=32 ProductName=Mascarpone Fabioli SupplierID=14 CategoryID=4 QuantityPerUnit=24 - 200 g pkgs. UnitPrice=32.0000 UnitsInStock=9 UnitsOnOrder=40 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
ExpensiveProducts: ProductID=59 ProductName=Raclette Courdavault SupplierID=28 CategoryID=4 QuantityPerUnit=5 kg pkg. UnitPrice=55.0000 UnitsInStock=79 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
ExpensiveProducts: ProductID=60 ProductName=Camembert Pierrot SupplierID=28 CategoryID=4 QuantityPerUnit=15 - 300 g rounds UnitPrice=34.0000 UnitsInStock=19 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
ExpensiveProducts: ProductID=69 ProductName=Gudbrandsdalsost SupplierID=15 CategoryID=4 QuantityPerUnit=10 kg pkg. UnitPrice=36.0000 UnitsInStock=26 UnitsOnOrder=0 ReorderLevel=15 Discontinued=False Order_Details=... Category={ } Supplier={ }
ExpensiveProducts: ProductID=72 ProductName=Mozzarella di Giovanni SupplierID=14 CategoryID=4 QuantityPerUnit=24 - 200 g pkgs. UnitPrice=34.8000 UnitsInStock=14 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=11 ProductName=Queso Cabrales SupplierID=5 CategoryID=4 QuantityPerUnit=1 kg pkg. UnitPrice=21.0000 UnitsInStock=22 UnitsOnOrder=30 ReorderLevel=30 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=12 ProductName=Queso Manchego La Pastora SupplierID=5 CategoryID=4 QuantityPerUnit=10 - 500 g pkgs. UnitPrice=38.0000 UnitsInStock=86 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=31 ProductName=Gorgonzola Telino SupplierID=14 CategoryID=4 QuantityPerUnit=12 - 100 g pkgs UnitPrice=12.5000 UnitsInStock=0 UnitsOnOrder=70 ReorderLevel=20 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=32 ProductName=Mascarpone Fabioli SupplierID=14 CategoryID=4 QuantityPerUnit=24 - 200 g pkgs. UnitPrice=32.0000 UnitsInStock=9 UnitsOnOrder=40 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=33 ProductName=Geitost SupplierID=15 CategoryID=4 QuantityPerUnit=500 g UnitPrice=2.5000 UnitsInStock=112 UnitsOnOrder=0 ReorderLevel=20 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=59 ProductName=Raclette Courdavault SupplierID=28 CategoryID=4 QuantityPerUnit=5 kg pkg. UnitPrice=55.0000 UnitsInStock=79 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=60 ProductName=Camembert Pierrot SupplierID=28 CategoryID=4 QuantityPerUnit=15 - 300 g rounds UnitPrice=34.0000 UnitsInStock=19 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=69 ProductName=Gudbrandsdalsost SupplierID=15 CategoryID=4 QuantityPerUnit=10 kg pkg. UnitPrice=36.0000 UnitsInStock=26 UnitsOnOrder=0 ReorderLevel=15 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=71 ProductName=Flotemysost SupplierID=15 CategoryID=4 QuantityPerUnit=10 - 500 g pkgs. UnitPrice=21.5000 UnitsInStock=26 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=72 ProductName=Mozzarella di Giovanni SupplierID=14 CategoryID=4 QuantityPerUnit=24 - 200 g pkgs. UnitPrice=34.8000 UnitsInStock=14 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
ExpensiveProducts=... g=...
ExpensiveProducts: ProductID=22 ProductName=Gustaf's Knäckebröd SupplierID=9 CategoryID=5 QuantityPerUnit=24 - 500 g pkgs. UnitPrice=21.0000 UnitsInStock=104 UnitsOnOrder=0 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
ExpensiveProducts: ProductID=56 ProductName=Gnocchi di nonna Alice SupplierID=26 CategoryID=5 QuantityPerUnit=24 - 250 g pkgs. UnitPrice=38.0000 UnitsInStock=21 UnitsOnOrder=10 ReorderLevel=30 Discontinued=False Order_Details=... Category={ } Supplier={ }
ExpensiveProducts: ProductID=64 ProductName=Wimmers gute Semmelknödel SupplierID=12 CategoryID=5 QuantityPerUnit=20 bags x 4 pieces UnitPrice=33.2500 UnitsInStock=22 UnitsOnOrder=80 ReorderLevel=30 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=22 ProductName=Gustaf's Knäckebröd SupplierID=9 CategoryID=5 QuantityPerUnit=24 - 500 g pkgs. UnitPrice=21.0000 UnitsInStock=104 UnitsOnOrder=0 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=23 ProductName=Tunnbröd SupplierID=9 CategoryID=5 QuantityPerUnit=12 - 250 g pkgs. UnitPrice=9.0000 UnitsInStock=61 UnitsOnOrder=0 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=42 ProductName=Singaporean Hokkien Fried Mee SupplierID=20 CategoryID=5 QuantityPerUnit=32 - 1 kg pkgs. UnitPrice=14.0000 UnitsInStock=26 UnitsOnOrder=0 ReorderLevel=0 Discontinued=True Order_Details=... Category={ } Supplier={ }
g: ProductID=52 ProductName=Filo Mix SupplierID=24 CategoryID=5 QuantityPerUnit=16 - 2 kg boxes UnitPrice=7.0000 UnitsInStock=38 UnitsOnOrder=0 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=56 ProductName=Gnocchi di nonna Alice SupplierID=26 CategoryID=5 QuantityPerUnit=24 - 250 g pkgs. UnitPrice=38.0000 UnitsInStock=21 UnitsOnOrder=10 ReorderLevel=30 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=57 ProductName=Ravioli Angelo SupplierID=26 CategoryID=5 QuantityPerUnit=24 - 250 g pkgs. UnitPrice=19.5000 UnitsInStock=36 UnitsOnOrder=0 ReorderLevel=20 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=64 ProductName=Wimmers gute Semmelknödel SupplierID=12 CategoryID=5 QuantityPerUnit=20 bags x 4 pieces UnitPrice=33.2500 UnitsInStock=22 UnitsOnOrder=80 ReorderLevel=30 Discontinued=False Order_Details=... Category={ } Supplier={ }
ExpensiveProducts=... g=...
ExpensiveProducts: ProductID=9 ProductName=Mishi Kobe Niku SupplierID=4 CategoryID=6 QuantityPerUnit=18 - 500 g pkgs. UnitPrice=97.0000 UnitsInStock=29 UnitsOnOrder=0 ReorderLevel=0 Discontinued=True Order_Details=... Category={ } Supplier={ }
ExpensiveProducts: ProductID=29 ProductName=Thüringer Rostbratwurst SupplierID=12 CategoryID=6 QuantityPerUnit=50 bags x 30 sausgs. UnitPrice=123.7900 UnitsInStock=0 UnitsOnOrder=0 ReorderLevel=0 Discontinued=True Order_Details=... Category={ } Supplier={ }
g: ProductID=9 ProductName=Mishi Kobe Niku SupplierID=4 CategoryID=6 QuantityPerUnit=18 - 500 g pkgs. UnitPrice=97.0000 UnitsInStock=29 UnitsOnOrder=0 ReorderLevel=0 Discontinued=True Order_Details=... Category={ } Supplier={ }
g: ProductID=17 ProductName=Alice Mutton SupplierID=7 CategoryID=6 QuantityPerUnit=20 - 1 kg tins UnitPrice=39.0000 UnitsInStock=0 UnitsOnOrder=0 ReorderLevel=0 Discontinued=True Order_Details=... Category={ } Supplier={ }
g: ProductID=29 ProductName=Thüringer Rostbratwurst SupplierID=12 CategoryID=6 QuantityPerUnit=50 bags x 30 sausgs. UnitPrice=123.7900 UnitsInStock=0 UnitsOnOrder=0 ReorderLevel=0 Discontinued=True Order_Details=... Category={ } Supplier={ }
g: ProductID=53 ProductName=Perth Pasties SupplierID=24 CategoryID=6 QuantityPerUnit=48 pieces UnitPrice=32.8000 UnitsInStock=0 UnitsOnOrder=0 ReorderLevel=0 Discontinued=True Order_Details=... Category={ } Supplier={ }
g: ProductID=54 ProductName=Tourtière SupplierID=25 CategoryID=6 QuantityPerUnit=16 pies UnitPrice=7.4500 UnitsInStock=21 UnitsOnOrder=0 ReorderLevel=10 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=55 ProductName=Pâté chinois SupplierID=25 CategoryID=6 QuantityPerUnit=24 boxes x 2 pies UnitPrice=24.0000 UnitsInStock=115 UnitsOnOrder=0 ReorderLevel=20 Discontinued=False Order_Details=... Category={ } Supplier={ }
ExpensiveProducts=... g=...
ExpensiveProducts: ProductID=28 ProductName=Rössle Sauerkraut SupplierID=12 CategoryID=7 QuantityPerUnit=25 - 825 g cans UnitPrice=45.6000 UnitsInStock=26 UnitsOnOrder=0 ReorderLevel=0 Discontinued=True Order_Details=... Category={ } Supplier={ }
ExpensiveProducts: ProductID=51 ProductName=Manjimup Dried Apples SupplierID=24 CategoryID=7 QuantityPerUnit=50 - 300 g pkgs. UnitPrice=53.0000 UnitsInStock=20 UnitsOnOrder=0 ReorderLevel=10 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=7 ProductName=Uncle Bob's Organic Dried Pears SupplierID=3 CategoryID=7 QuantityPerUnit=12 - 1 lb pkgs. UnitPrice=30.0000 UnitsInStock=15 UnitsOnOrder=0 ReorderLevel=10 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=14 ProductName=Tofu SupplierID=6 CategoryID=7 QuantityPerUnit=40 - 100 g pkgs. UnitPrice=23.2500 UnitsInStock=35 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=28 ProductName=Rössle Sauerkraut SupplierID=12 CategoryID=7 QuantityPerUnit=25 - 825 g cans UnitPrice=45.6000 UnitsInStock=26 UnitsOnOrder=0 ReorderLevel=0 Discontinued=True Order_Details=... Category={ } Supplier={ }
g: ProductID=51 ProductName=Manjimup Dried Apples SupplierID=24 CategoryID=7 QuantityPerUnit=50 - 300 g pkgs. UnitPrice=53.0000 UnitsInStock=20 UnitsOnOrder=0 ReorderLevel=10 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=74 ProductName=Longlife Tofu SupplierID=4 CategoryID=7 QuantityPerUnit=5 kg pkg. UnitPrice=10.0000 UnitsInStock=4 UnitsOnOrder=20 ReorderLevel=5 Discontinued=False Order_Details=... Category={ } Supplier={ }
ExpensiveProducts=... g=...
ExpensiveProducts: ProductID=10 ProductName=Ikura SupplierID=4 CategoryID=8 QuantityPerUnit=12 - 200 ml jars UnitPrice=31.0000 UnitsInStock=31 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
ExpensiveProducts: ProductID=18 ProductName=Carnarvon Tigers SupplierID=7 CategoryID=8 QuantityPerUnit=16 kg pkg. UnitPrice=62.5000 UnitsInStock=42 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
ExpensiveProducts: ProductID=30 ProductName=Nord-Ost Matjeshering SupplierID=13 CategoryID=8 QuantityPerUnit=10 - 200 g glasses UnitPrice=25.8900 UnitsInStock=10 UnitsOnOrder=0 ReorderLevel=15 Discontinued=False Order_Details=... Category={ } Supplier={ }
ExpensiveProducts: ProductID=37 ProductName=Gravad lax SupplierID=17 CategoryID=8 QuantityPerUnit=12 - 500 g pkgs. UnitPrice=26.0000 UnitsInStock=11 UnitsOnOrder=50 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=10 ProductName=Ikura SupplierID=4 CategoryID=8 QuantityPerUnit=12 - 200 ml jars UnitPrice=31.0000 UnitsInStock=31 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=13 ProductName=Konbu SupplierID=6 CategoryID=8 QuantityPerUnit=2 kg box UnitPrice=6.0000 UnitsInStock=24 UnitsOnOrder=0 ReorderLevel=5 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=18 ProductName=Carnarvon Tigers SupplierID=7 CategoryID=8 QuantityPerUnit=16 kg pkg. UnitPrice=62.5000 UnitsInStock=42 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=30 ProductName=Nord-Ost Matjeshering SupplierID=13 CategoryID=8 QuantityPerUnit=10 - 200 g glasses UnitPrice=25.8900 UnitsInStock=10 UnitsOnOrder=0 ReorderLevel=15 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=36 ProductName=Inlagd Sill SupplierID=17 CategoryID=8 QuantityPerUnit=24 - 250 g jars UnitPrice=19.0000 UnitsInStock=112 UnitsOnOrder=0 ReorderLevel=20 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=37 ProductName=Gravad lax SupplierID=17 CategoryID=8 QuantityPerUnit=12 - 500 g pkgs. UnitPrice=26.0000 UnitsInStock=11 UnitsOnOrder=50 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=40 ProductName=Boston Crab Meat SupplierID=19 CategoryID=8 QuantityPerUnit=24 - 4 oz tins UnitPrice=18.4000 UnitsInStock=123 UnitsOnOrder=0 ReorderLevel=30 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=41 ProductName=Jack's New England Clam Chowder SupplierID=19 CategoryID=8 QuantityPerUnit=12 - 12 oz cans UnitPrice=9.6500 UnitsInStock=85 UnitsOnOrder=0 ReorderLevel=10 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=45 ProductName=Rogede sild SupplierID=21 CategoryID=8 QuantityPerUnit=1k pkg. UnitPrice=9.5000 UnitsInStock=5 UnitsOnOrder=70 ReorderLevel=15 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=46 ProductName=Spegesild SupplierID=21 CategoryID=8 QuantityPerUnit=4 - 450 g glasses UnitPrice=12.0000 UnitsInStock=95 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=58 ProductName=Escargots de Bourgogne SupplierID=27 CategoryID=8 QuantityPerUnit=24 pieces UnitPrice=13.2500 UnitsInStock=62 UnitsOnOrder=0 ReorderLevel=20 Discontinued=False Order_Details=... Category={ } Supplier={ }
g: ProductID=73 ProductName=Röd Kaviar SupplierID=17 CategoryID=8 QuantityPerUnit=24 - 150 g jars UnitPrice=15.0000 UnitsInStock=101 UnitsOnOrder=0 ReorderLevel=5 Discontinued=False Order_Details=... Category={ } Supplier={ }
