This sample uses Take to select the first 5 Employees hired.
Public Sub LinqToSqlTop01()
Dim q = From e In db.Employees _
Order By e.HireDate Take 5
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=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={ }
This sample uses Skip to select all but the 10 most expensive Products.
Public Sub LinqToSqlTop02()
Dim q = From p In db.Products _
Order By p.UnitPrice Descending Skip 10
ObjectDumper.Write(q)
End Sub
Result:
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={ }
