LINQ To SQL Samples - View |
This sample uses SELECT and WHERE to return a sequence of invoices where shipping city is London.
Public Sub LinqToSqlView01()
Dim q = From i In db.Invoices _
Where i.ShipCity = "London" _
Select New With {i.OrderID, i.ProductName, i.Quantity, i.CustomerName}
ObjectDumper.Write(q, 1)
End Sub
Result:
CustomerName=B's Beverages OrderID=10289 ProductName=Aniseed Syrup Quantity=30
CustomerName=B's Beverages OrderID=10289 ProductName=Wimmers gute Semmelknödel Quantity=9
CustomerName=Seven Seas Imports OrderID=10359 ProductName=Pavlova Quantity=56
CustomerName=Seven Seas Imports OrderID=10359 ProductName=Gorgonzola Telino Quantity=70
CustomerName=Seven Seas Imports OrderID=10359 ProductName=Camembert Pierrot Quantity=80
CustomerName=Eastern Connection OrderID=10364 ProductName=Gudbrandsdalsost Quantity=30
CustomerName=Eastern Connection OrderID=10364 ProductName=Flotemysost Quantity=5
CustomerName=Seven Seas Imports OrderID=10377 ProductName=Rössle Sauerkraut Quantity=20
CustomerName=Seven Seas Imports OrderID=10377 ProductName=Chartreuse verte Quantity=20
CustomerName=Seven Seas Imports OrderID=10388 ProductName=Rogede sild Quantity=15
CustomerName=Seven Seas Imports OrderID=10388 ProductName=Filo Mix Quantity=20
CustomerName=Seven Seas Imports OrderID=10388 ProductName=Perth Pasties Quantity=40
CustomerName=Eastern Connection OrderID=10400 ProductName=Thüringer Rostbratwurst Quantity=21
CustomerName=Eastern Connection OrderID=10400 ProductName=Steeleye Stout Quantity=35
CustomerName=Eastern Connection OrderID=10400 ProductName=Maxilaku Quantity=30
CustomerName=Consolidated Holdings OrderID=10435 ProductName=Chang Quantity=10
CustomerName=Consolidated Holdings OrderID=10435 ProductName=Gustaf's Knäckebröd Quantity=12
CustomerName=Consolidated Holdings OrderID=10435 ProductName=Mozzarella di Giovanni Quantity=10
CustomerName=Consolidated Holdings OrderID=10462 ProductName=Konbu Quantity=1
CustomerName=Consolidated Holdings OrderID=10462 ProductName=Tunnbröd Quantity=21
CustomerName=B's Beverages OrderID=10471 ProductName=Uncle Bob's Organic Dried Pears Quantity=30
CustomerName=B's Beverages OrderID=10471 ProductName=Gnocchi di nonna Alice Quantity=20
CustomerName=Seven Seas Imports OrderID=10472 ProductName=Guaraná Fantástica Quantity=80
CustomerName=Seven Seas Imports OrderID=10472 ProductName=Manjimup Dried Apples Quantity=18
CustomerName=B's Beverages OrderID=10484 ProductName=Sir Rodney's Scones Quantity=14
CustomerName=B's Beverages OrderID=10484 ProductName=Boston Crab Meat Quantity=10
CustomerName=B's Beverages OrderID=10484 ProductName=Manjimup Dried Apples Quantity=3
CustomerName=North/South OrderID=10517 ProductName=Filo Mix Quantity=6
CustomerName=North/South OrderID=10517 ProductName=Raclette Courdavault Quantity=4
CustomerName=North/South OrderID=10517 ProductName=Outback Lager Quantity=6
CustomerName=Seven Seas Imports OrderID=10523 ProductName=Alice Mutton Quantity=25
CustomerName=Seven Seas Imports OrderID=10523 ProductName=Sir Rodney's Marmalade Quantity=15
CustomerName=Seven Seas Imports OrderID=10523 ProductName=Gravad lax Quantity=18
CustomerName=Seven Seas Imports OrderID=10523 ProductName=Jack's New England Clam Chowder Quantity=6
CustomerName=Eastern Connection OrderID=10532 ProductName=Nord-Ost Matjeshering Quantity=15
CustomerName=Eastern Connection OrderID=10532 ProductName=Louisiana Hot Spiced Okra Quantity=24
CustomerName=B's Beverages OrderID=10538 ProductName=Outback Lager Quantity=7
CustomerName=B's Beverages OrderID=10538 ProductName=Mozzarella di Giovanni Quantity=1
CustomerName=B's Beverages OrderID=10539 ProductName=Konbu Quantity=8
CustomerName=B's Beverages OrderID=10539 ProductName=Sir Rodney's Scones Quantity=15
CustomerName=B's Beverages OrderID=10539 ProductName=Geitost Quantity=15
CustomerName=B's Beverages OrderID=10539 ProductName=Maxilaku Quantity=6
CustomerName=Seven Seas Imports OrderID=10547 ProductName=Mascarpone Fabioli Quantity=24
CustomerName=Seven Seas Imports OrderID=10547 ProductName=Inlagd Sill Quantity=60
CustomerName=B's Beverages OrderID=10578 ProductName=Steeleye Stout Quantity=20
CustomerName=B's Beverages OrderID=10578 ProductName=Ravioli Angelo Quantity=6
CustomerName=B's Beverages OrderID=10599 ProductName=Tarte au sucre Quantity=10
CustomerName=Eastern Connection OrderID=10726 ProductName=Chef Anton's Cajun Seasoning Quantity=25
CustomerName=Eastern Connection OrderID=10726 ProductName=Queso Cabrales Quantity=5
CustomerName=North/South OrderID=10752 ProductName=Chai Quantity=8
CustomerName=North/South OrderID=10752 ProductName=Gudbrandsdalsost Quantity=3
CustomerName=Seven Seas Imports OrderID=10800 ProductName=Queso Cabrales Quantity=50
CustomerName=Seven Seas Imports OrderID=10800 ProductName=Manjimup Dried Apples Quantity=10
CustomerName=Seven Seas Imports OrderID=10800 ProductName=Tourtière Quantity=7
CustomerName=Seven Seas Imports OrderID=10804 ProductName=Ikura Quantity=36
CustomerName=Seven Seas Imports OrderID=10804 ProductName=Rössle Sauerkraut Quantity=24
CustomerName=Seven Seas Imports OrderID=10804 ProductName=Maxilaku Quantity=4
CustomerName=Consolidated Holdings OrderID=10848 ProductName=Chef Anton's Gumbo Mix Quantity=30
CustomerName=Consolidated Holdings OrderID=10848 ProductName=Mishi Kobe Niku Quantity=3
CustomerName=Seven Seas Imports OrderID=10869 ProductName=Chai Quantity=40
CustomerName=Seven Seas Imports OrderID=10869 ProductName=Queso Cabrales Quantity=10
CustomerName=Seven Seas Imports OrderID=10869 ProductName=Tunnbröd Quantity=50
CustomerName=Seven Seas Imports OrderID=10869 ProductName=Scottish Longbreads Quantity=20
CustomerName=B's Beverages OrderID=10943 ProductName=Konbu Quantity=15
CustomerName=B's Beverages OrderID=10943 ProductName=Gustaf's Knäckebröd Quantity=21
CustomerName=B's Beverages OrderID=10943 ProductName=Spegesild Quantity=15
CustomerName=B's Beverages OrderID=10947 ProductName=Raclette Courdavault Quantity=4
CustomerName=Eastern Connection OrderID=10987 ProductName=Uncle Bob's Organic Dried Pears Quantity=60
CustomerName=Eastern Connection OrderID=10987 ProductName=Ipoh Coffee Quantity=6
CustomerName=Eastern Connection OrderID=10987 ProductName=Mozzarella di Giovanni Quantity=20
CustomerName=B's Beverages OrderID=11023 ProductName=Uncle Bob's Organic Dried Pears Quantity=4
CustomerName=B's Beverages OrderID=11023 ProductName=Ipoh Coffee Quantity=30
CustomerName=Eastern Connection OrderID=11024 ProductName=Gumbär Gummibärchen Quantity=12
CustomerName=Eastern Connection OrderID=11024 ProductName=Geitost Quantity=30
CustomerName=Eastern Connection OrderID=11024 ProductName=Louisiana Fiery Hot Pepper Sauce Quantity=21
CustomerName=Eastern Connection OrderID=11024 ProductName=Flotemysost Quantity=50
CustomerName=Eastern Connection OrderID=11047 ProductName=Chai Quantity=25
CustomerName=Eastern Connection OrderID=11047 ProductName=Chef Anton's Gumbo Mix Quantity=30
CustomerName=Eastern Connection OrderID=11056 ProductName=Uncle Bob's Organic Dried Pears Quantity=40
CustomerName=Eastern Connection OrderID=11056 ProductName=Pâté chinois Quantity=35
CustomerName=Eastern Connection OrderID=11056 ProductName=Camembert Pierrot Quantity=50
CustomerName=North/South OrderID=11057 ProductName=Outback Lager Quantity=3
Entities must have a mapped ID, but SqlMetal does not generate an ID for view by default.
Public Sub LinqToSqlView02()
Try
Dim q = From i In db.Invoices _
Where i.ShipCity = "London" _
Select i
ObjectDumper.Write(q, 1)
Catch ex As Exception
Console.WriteLine("{0} : {1}", ex.GetType().ToString(), ex.Message)
End Try
End Sub
Result:
ShipName=B's Beverages ShipAddress=Fauntleroy Circus ShipCity=London ShipRegion=null ShipPostalCode=EC2 5NT ShipCountry=UK CustomerID=BSBEV CustomerName=B's Beverages Address=Fauntleroy Circus City=London Region=null PostalCode=EC2 5NT Country=UK Salesperson=Robert King OrderID=10289 OrderDate=8/26/1996 RequiredDate=9/23/1996 ShippedDate=8/28/1996 ShipperName=Federal Shipping ProductID=3 ProductName=Aniseed Syrup UnitPrice=8.0000 Quantity=30 Discount=0 ExtendedPrice=240.0000 Freight=22.7700
ShipName=B's Beverages ShipAddress=Fauntleroy Circus ShipCity=London ShipRegion=null ShipPostalCode=EC2 5NT ShipCountry=UK CustomerID=BSBEV CustomerName=B's Beverages Address=Fauntleroy Circus City=London Region=null PostalCode=EC2 5NT Country=UK Salesperson=Robert King OrderID=10289 OrderDate=8/26/1996 RequiredDate=9/23/1996 ShippedDate=8/28/1996 ShipperName=Federal Shipping ProductID=64 ProductName=Wimmers gute Semmelknödel UnitPrice=26.6000 Quantity=9 Discount=0 ExtendedPrice=239.4000 Freight=22.7700
ShipName=Seven Seas Imports ShipAddress=90 Wadhurst Rd. ShipCity=London ShipRegion=null ShipPostalCode=OX15 4NB ShipCountry=UK CustomerID=SEVES CustomerName=Seven Seas Imports Address=90 Wadhurst Rd. City=London Region=null PostalCode=OX15 4NB Country=UK Salesperson=Steven Buchanan OrderID=10359 OrderDate=11/21/1996 RequiredDate=12/19/1996 ShippedDate=11/26/1996 ShipperName=Federal Shipping ProductID=16 ProductName=Pavlova UnitPrice=13.9000 Quantity=56 Discount=0.05 ExtendedPrice=739.4800 Freight=288.4300
ShipName=Seven Seas Imports ShipAddress=90 Wadhurst Rd. ShipCity=London ShipRegion=null ShipPostalCode=OX15 4NB ShipCountry=UK CustomerID=SEVES CustomerName=Seven Seas Imports Address=90 Wadhurst Rd. City=London Region=null PostalCode=OX15 4NB Country=UK Salesperson=Steven Buchanan OrderID=10359 OrderDate=11/21/1996 RequiredDate=12/19/1996 ShippedDate=11/26/1996 ShipperName=Federal Shipping ProductID=31 ProductName=Gorgonzola Telino UnitPrice=10.0000 Quantity=70 Discount=0.05 ExtendedPrice=665.0000 Freight=288.4300
ShipName=Seven Seas Imports ShipAddress=90 Wadhurst Rd. ShipCity=London ShipRegion=null ShipPostalCode=OX15 4NB ShipCountry=UK CustomerID=SEVES CustomerName=Seven Seas Imports Address=90 Wadhurst Rd. City=London Region=null PostalCode=OX15 4NB Country=UK Salesperson=Steven Buchanan OrderID=10359 OrderDate=11/21/1996 RequiredDate=12/19/1996 ShippedDate=11/26/1996 ShipperName=Federal Shipping ProductID=60 ProductName=Camembert Pierrot UnitPrice=27.2000 Quantity=80 Discount=0.05 ExtendedPrice=2067.2000 Freight=288.4300
ShipName=Eastern Connection ShipAddress=35 King George ShipCity=London ShipRegion=null ShipPostalCode=WX3 6FW ShipCountry=UK CustomerID=EASTC CustomerName=Eastern Connection Address=35 King George City=London Region=null PostalCode=WX3 6FW Country=UK Salesperson=Nancy Davolio OrderID=10364 OrderDate=11/26/1996 RequiredDate=1/7/1997 ShippedDate=12/4/1996 ShipperName=Speedy Express ProductID=69 ProductName=Gudbrandsdalsost UnitPrice=28.8000 Quantity=30 Discount=0 ExtendedPrice=864.0000 Freight=71.9700
ShipName=Eastern Connection ShipAddress=35 King George ShipCity=London ShipRegion=null ShipPostalCode=WX3 6FW ShipCountry=UK CustomerID=EASTC CustomerName=Eastern Connection Address=35 King George City=London Region=null PostalCode=WX3 6FW Country=UK Salesperson=Nancy Davolio OrderID=10364 OrderDate=11/26/1996 RequiredDate=1/7/1997 ShippedDate=12/4/1996 ShipperName=Speedy Express ProductID=71 ProductName=Flotemysost UnitPrice=17.2000 Quantity=5 Discount=0 ExtendedPrice=86.0000 Freight=71.9700
ShipName=Seven Seas Imports ShipAddress=90 Wadhurst Rd. ShipCity=London ShipRegion=null ShipPostalCode=OX15 4NB ShipCountry=UK CustomerID=SEVES CustomerName=Seven Seas Imports Address=90 Wadhurst Rd. City=London Region=null PostalCode=OX15 4NB Country=UK Salesperson=Nancy Davolio OrderID=10377 OrderDate=12/9/1996 RequiredDate=1/6/1997 ShippedDate=12/13/1996 ShipperName=Federal Shipping ProductID=28 ProductName=Rössle Sauerkraut UnitPrice=36.4000 Quantity=20 Discount=0.15 ExtendedPrice=618.8000 Freight=22.2100
ShipName=Seven Seas Imports ShipAddress=90 Wadhurst Rd. ShipCity=London ShipRegion=null ShipPostalCode=OX15 4NB ShipCountry=UK CustomerID=SEVES CustomerName=Seven Seas Imports Address=90 Wadhurst Rd. City=London Region=null PostalCode=OX15 4NB Country=UK Salesperson=Nancy Davolio OrderID=10377 OrderDate=12/9/1996 RequiredDate=1/6/1997 ShippedDate=12/13/1996 ShipperName=Federal Shipping ProductID=39 ProductName=Chartreuse verte UnitPrice=14.4000 Quantity=20 Discount=0.15 ExtendedPrice=244.8000 Freight=22.2100
ShipName=Seven Seas Imports ShipAddress=90 Wadhurst Rd. ShipCity=London ShipRegion=null ShipPostalCode=OX15 4NB ShipCountry=UK CustomerID=SEVES CustomerName=Seven Seas Imports Address=90 Wadhurst Rd. City=London Region=null PostalCode=OX15 4NB Country=UK Salesperson=Andrew Fuller OrderID=10388 OrderDate=12/19/1996 RequiredDate=1/16/1997 ShippedDate=12/20/1996 ShipperName=Speedy Express ProductID=45 ProductName=Rogede sild UnitPrice=7.6000 Quantity=15 Discount=0.2 ExtendedPrice=91.2000 Freight=34.8600
ShipName=Seven Seas Imports ShipAddress=90 Wadhurst Rd. ShipCity=London ShipRegion=null ShipPostalCode=OX15 4NB ShipCountry=UK CustomerID=SEVES CustomerName=Seven Seas Imports Address=90 Wadhurst Rd. City=London Region=null PostalCode=OX15 4NB Country=UK Salesperson=Andrew Fuller OrderID=10388 OrderDate=12/19/1996 RequiredDate=1/16/1997 ShippedDate=12/20/1996 ShipperName=Speedy Express ProductID=52 ProductName=Filo Mix UnitPrice=5.6000 Quantity=20 Discount=0.2 ExtendedPrice=89.6000 Freight=34.8600
ShipName=Seven Seas Imports ShipAddress=90 Wadhurst Rd. ShipCity=London ShipRegion=null ShipPostalCode=OX15 4NB ShipCountry=UK CustomerID=SEVES CustomerName=Seven Seas Imports Address=90 Wadhurst Rd. City=London Region=null PostalCode=OX15 4NB Country=UK Salesperson=Andrew Fuller OrderID=10388 OrderDate=12/19/1996 RequiredDate=1/16/1997 ShippedDate=12/20/1996 ShipperName=Speedy Express ProductID=53 ProductName=Perth Pasties UnitPrice=26.2000 Quantity=40 Discount=0 ExtendedPrice=1048.0000 Freight=34.8600
ShipName=Eastern Connection ShipAddress=35 King George ShipCity=London ShipRegion=null ShipPostalCode=WX3 6FW ShipCountry=UK CustomerID=EASTC CustomerName=Eastern Connection Address=35 King George City=London Region=null PostalCode=WX3 6FW Country=UK Salesperson=Nancy Davolio OrderID=10400 OrderDate=1/1/1997 RequiredDate=1/29/1997 ShippedDate=1/16/1997 ShipperName=Federal Shipping ProductID=29 ProductName=Thüringer Rostbratwurst UnitPrice=99.0000 Quantity=21 Discount=0 ExtendedPrice=2079.0000 Freight=83.9300
ShipName=Eastern Connection ShipAddress=35 King George ShipCity=London ShipRegion=null ShipPostalCode=WX3 6FW ShipCountry=UK CustomerID=EASTC CustomerName=Eastern Connection Address=35 King George City=London Region=null PostalCode=WX3 6FW Country=UK Salesperson=Nancy Davolio OrderID=10400 OrderDate=1/1/1997 RequiredDate=1/29/1997 ShippedDate=1/16/1997 ShipperName=Federal Shipping ProductID=35 ProductName=Steeleye Stout UnitPrice=14.4000 Quantity=35 Discount=0 ExtendedPrice=504.0000 Freight=83.9300
ShipName=Eastern Connection ShipAddress=35 King George ShipCity=London ShipRegion=null ShipPostalCode=WX3 6FW ShipCountry=UK CustomerID=EASTC CustomerName=Eastern Connection Address=35 King George City=London Region=null PostalCode=WX3 6FW Country=UK Salesperson=Nancy Davolio OrderID=10400 OrderDate=1/1/1997 RequiredDate=1/29/1997 ShippedDate=1/16/1997 ShipperName=Federal Shipping ProductID=49 ProductName=Maxilaku UnitPrice=16.0000 Quantity=30 Discount=0 ExtendedPrice=480.0000 Freight=83.9300
ShipName=Consolidated Holdings ShipAddress=Berkeley Gardens 12 Brewery ShipCity=London ShipRegion=null ShipPostalCode=WX1 6LT ShipCountry=UK CustomerID=CONSH CustomerName=Consolidated Holdings Address=Berkeley Gardens 12 Brewery City=London Region=null PostalCode=WX1 6LT Country=UK Salesperson=Laura Callahan OrderID=10435 OrderDate=2/4/1997 RequiredDate=3/18/1997 ShippedDate=2/7/1997 ShipperName=United Package ProductID=2 ProductName=Chang UnitPrice=15.2000 Quantity=10 Discount=0 ExtendedPrice=152.0000 Freight=9.2100
ShipName=Consolidated Holdings ShipAddress=Berkeley Gardens 12 Brewery ShipCity=London ShipRegion=null ShipPostalCode=WX1 6LT ShipCountry=UK CustomerID=CONSH CustomerName=Consolidated Holdings Address=Berkeley Gardens 12 Brewery City=London Region=null PostalCode=WX1 6LT Country=UK Salesperson=Laura Callahan OrderID=10435 OrderDate=2/4/1997 RequiredDate=3/18/1997 ShippedDate=2/7/1997 ShipperName=United Package ProductID=22 ProductName=Gustaf's Knäckebröd UnitPrice=16.8000 Quantity=12 Discount=0 ExtendedPrice=201.6000 Freight=9.2100
ShipName=Consolidated Holdings ShipAddress=Berkeley Gardens 12 Brewery ShipCity=London ShipRegion=null ShipPostalCode=WX1 6LT ShipCountry=UK CustomerID=CONSH CustomerName=Consolidated Holdings Address=Berkeley Gardens 12 Brewery City=London Region=null PostalCode=WX1 6LT Country=UK Salesperson=Laura Callahan OrderID=10435 OrderDate=2/4/1997 RequiredDate=3/18/1997 ShippedDate=2/7/1997 ShipperName=United Package ProductID=72 ProductName=Mozzarella di Giovanni UnitPrice=27.8000 Quantity=10 Discount=0 ExtendedPrice=278.0000 Freight=9.2100
ShipName=Consolidated Holdings ShipAddress=Berkeley Gardens 12 Brewery ShipCity=London ShipRegion=null ShipPostalCode=WX1 6LT ShipCountry=UK CustomerID=CONSH CustomerName=Consolidated Holdings Address=Berkeley Gardens 12 Brewery City=London Region=null PostalCode=WX1 6LT Country=UK Salesperson=Andrew Fuller OrderID=10462 OrderDate=3/3/1997 RequiredDate=3/31/1997 ShippedDate=3/18/1997 ShipperName=Speedy Express ProductID=13 ProductName=Konbu UnitPrice=4.8000 Quantity=1 Discount=0 ExtendedPrice=4.8000 Freight=6.1700
ShipName=Consolidated Holdings ShipAddress=Berkeley Gardens 12 Brewery ShipCity=London ShipRegion=null ShipPostalCode=WX1 6LT ShipCountry=UK CustomerID=CONSH CustomerName=Consolidated Holdings Address=Berkeley Gardens 12 Brewery City=London Region=null PostalCode=WX1 6LT Country=UK Salesperson=Andrew Fuller OrderID=10462 OrderDate=3/3/1997 RequiredDate=3/31/1997 ShippedDate=3/18/1997 ShipperName=Speedy Express ProductID=23 ProductName=Tunnbröd UnitPrice=7.2000 Quantity=21 Discount=0 ExtendedPrice=151.2000 Freight=6.1700
ShipName=B's Beverages ShipAddress=Fauntleroy Circus ShipCity=London ShipRegion=null ShipPostalCode=EC2 5NT ShipCountry=UK CustomerID=BSBEV CustomerName=B's Beverages Address=Fauntleroy Circus City=London Region=null PostalCode=EC2 5NT Country=UK Salesperson=Andrew Fuller OrderID=10471 OrderDate=3/11/1997 RequiredDate=4/8/1997 ShippedDate=3/18/1997 ShipperName=Federal Shipping ProductID=7 ProductName=Uncle Bob's Organic Dried Pears UnitPrice=24.0000 Quantity=30 Discount=0 ExtendedPrice=720.0000 Freight=45.5900
ShipName=B's Beverages ShipAddress=Fauntleroy Circus ShipCity=London ShipRegion=null ShipPostalCode=EC2 5NT ShipCountry=UK CustomerID=BSBEV CustomerName=B's Beverages Address=Fauntleroy Circus City=London Region=null PostalCode=EC2 5NT Country=UK Salesperson=Andrew Fuller OrderID=10471 OrderDate=3/11/1997 RequiredDate=4/8/1997 ShippedDate=3/18/1997 ShipperName=Federal Shipping ProductID=56 ProductName=Gnocchi di nonna Alice UnitPrice=30.4000 Quantity=20 Discount=0 ExtendedPrice=608.0000 Freight=45.5900
ShipName=Seven Seas Imports ShipAddress=90 Wadhurst Rd. ShipCity=London ShipRegion=null ShipPostalCode=OX15 4NB ShipCountry=UK CustomerID=SEVES CustomerName=Seven Seas Imports Address=90 Wadhurst Rd. City=London Region=null PostalCode=OX15 4NB Country=UK Salesperson=Laura Callahan OrderID=10472 OrderDate=3/12/1997 RequiredDate=4/9/1997 ShippedDate=3/19/1997 ShipperName=Speedy Express ProductID=24 ProductName=Guaraná Fantástica UnitPrice=3.6000 Quantity=80 Discount=0.05 ExtendedPrice=273.6000 Freight=4.2000
ShipName=Seven Seas Imports ShipAddress=90 Wadhurst Rd. ShipCity=London ShipRegion=null ShipPostalCode=OX15 4NB ShipCountry=UK CustomerID=SEVES CustomerName=Seven Seas Imports Address=90 Wadhurst Rd. City=London Region=null PostalCode=OX15 4NB Country=UK Salesperson=Laura Callahan OrderID=10472 OrderDate=3/12/1997 RequiredDate=4/9/1997 ShippedDate=3/19/1997 ShipperName=Speedy Express ProductID=51 ProductName=Manjimup Dried Apples UnitPrice=42.4000 Quantity=18 Discount=0 ExtendedPrice=763.2000 Freight=4.2000
ShipName=B's Beverages ShipAddress=Fauntleroy Circus ShipCity=London ShipRegion=null ShipPostalCode=EC2 5NT ShipCountry=UK CustomerID=BSBEV CustomerName=B's Beverages Address=Fauntleroy Circus City=London Region=null PostalCode=EC2 5NT Country=UK Salesperson=Janet Leverling OrderID=10484 OrderDate=3/24/1997 RequiredDate=4/21/1997 ShippedDate=4/1/1997 ShipperName=Federal Shipping ProductID=21 ProductName=Sir Rodney's Scones UnitPrice=8.0000 Quantity=14 Discount=0 ExtendedPrice=112.0000 Freight=6.8800
ShipName=B's Beverages ShipAddress=Fauntleroy Circus ShipCity=London ShipRegion=null ShipPostalCode=EC2 5NT ShipCountry=UK CustomerID=BSBEV CustomerName=B's Beverages Address=Fauntleroy Circus City=London Region=null PostalCode=EC2 5NT Country=UK Salesperson=Janet Leverling OrderID=10484 OrderDate=3/24/1997 RequiredDate=4/21/1997 ShippedDate=4/1/1997 ShipperName=Federal Shipping ProductID=40 ProductName=Boston Crab Meat UnitPrice=14.7000 Quantity=10 Discount=0 ExtendedPrice=147.0000 Freight=6.8800
ShipName=B's Beverages ShipAddress=Fauntleroy Circus ShipCity=London ShipRegion=null ShipPostalCode=EC2 5NT ShipCountry=UK CustomerID=BSBEV CustomerName=B's Beverages Address=Fauntleroy Circus City=London Region=null PostalCode=EC2 5NT Country=UK Salesperson=Janet Leverling OrderID=10484 OrderDate=3/24/1997 RequiredDate=4/21/1997 ShippedDate=4/1/1997 ShipperName=Federal Shipping ProductID=51 ProductName=Manjimup Dried Apples UnitPrice=42.4000 Quantity=3 Discount=0 ExtendedPrice=127.2000 Freight=6.8800
ShipName=North/South ShipAddress=South House 300 Queensbridge ShipCity=London ShipRegion=null ShipPostalCode=SW7 1RZ ShipCountry=UK CustomerID=NORTS CustomerName=North/South Address=South House 300 Queensbridge City=London Region=null PostalCode=SW7 1RZ Country=UK Salesperson=Janet Leverling OrderID=10517 OrderDate=4/24/1997 RequiredDate=5/22/1997 ShippedDate=4/29/1997 ShipperName=Federal Shipping ProductID=52 ProductName=Filo Mix UnitPrice=7.0000 Quantity=6 Discount=0 ExtendedPrice=42.0000 Freight=32.0700
ShipName=North/South ShipAddress=South House 300 Queensbridge ShipCity=London ShipRegion=null ShipPostalCode=SW7 1RZ ShipCountry=UK CustomerID=NORTS CustomerName=North/South Address=South House 300 Queensbridge City=London Region=null PostalCode=SW7 1RZ Country=UK Salesperson=Janet Leverling OrderID=10517 OrderDate=4/24/1997 RequiredDate=5/22/1997 ShippedDate=4/29/1997 ShipperName=Federal Shipping ProductID=59 ProductName=Raclette Courdavault UnitPrice=55.0000 Quantity=4 Discount=0 ExtendedPrice=220.0000 Freight=32.0700
ShipName=North/South ShipAddress=South House 300 Queensbridge ShipCity=London ShipRegion=null ShipPostalCode=SW7 1RZ ShipCountry=UK CustomerID=NORTS CustomerName=North/South Address=South House 300 Queensbridge City=London Region=null PostalCode=SW7 1RZ Country=UK Salesperson=Janet Leverling OrderID=10517 OrderDate=4/24/1997 RequiredDate=5/22/1997 ShippedDate=4/29/1997 ShipperName=Federal Shipping ProductID=70 ProductName=Outback Lager UnitPrice=15.0000 Quantity=6 Discount=0 ExtendedPrice=90.0000 Freight=32.0700
ShipName=Seven Seas Imports ShipAddress=90 Wadhurst Rd. ShipCity=London ShipRegion=null ShipPostalCode=OX15 4NB ShipCountry=UK CustomerID=SEVES CustomerName=Seven Seas Imports Address=90 Wadhurst Rd. City=London Region=null PostalCode=OX15 4NB Country=UK Salesperson=Robert King OrderID=10523 OrderDate=5/1/1997 RequiredDate=5/29/1997 ShippedDate=5/30/1997 ShipperName=United Package ProductID=17 ProductName=Alice Mutton UnitPrice=39.0000 Quantity=25 Discount=0.1 ExtendedPrice=877.5000 Freight=77.6300
ShipName=Seven Seas Imports ShipAddress=90 Wadhurst Rd. ShipCity=London ShipRegion=null ShipPostalCode=OX15 4NB ShipCountry=UK CustomerID=SEVES CustomerName=Seven Seas Imports Address=90 Wadhurst Rd. City=London Region=null PostalCode=OX15 4NB Country=UK Salesperson=Robert King OrderID=10523 OrderDate=5/1/1997 RequiredDate=5/29/1997 ShippedDate=5/30/1997 ShipperName=United Package ProductID=20 ProductName=Sir Rodney's Marmalade UnitPrice=81.0000 Quantity=15 Discount=0.1 ExtendedPrice=1093.5000 Freight=77.6300
ShipName=Seven Seas Imports ShipAddress=90 Wadhurst Rd. ShipCity=London ShipRegion=null ShipPostalCode=OX15 4NB ShipCountry=UK CustomerID=SEVES CustomerName=Seven Seas Imports Address=90 Wadhurst Rd. City=London Region=null PostalCode=OX15 4NB Country=UK Salesperson=Robert King OrderID=10523 OrderDate=5/1/1997 RequiredDate=5/29/1997 ShippedDate=5/30/1997 ShipperName=United Package ProductID=37 ProductName=Gravad lax UnitPrice=26.0000 Quantity=18 Discount=0.1 ExtendedPrice=421.2000 Freight=77.6300
ShipName=Seven Seas Imports ShipAddress=90 Wadhurst Rd. ShipCity=London ShipRegion=null ShipPostalCode=OX15 4NB ShipCountry=UK CustomerID=SEVES CustomerName=Seven Seas Imports Address=90 Wadhurst Rd. City=London Region=null PostalCode=OX15 4NB Country=UK Salesperson=Robert King OrderID=10523 OrderDate=5/1/1997 RequiredDate=5/29/1997 ShippedDate=5/30/1997 ShipperName=United Package ProductID=41 ProductName=Jack's New England Clam Chowder UnitPrice=9.6500 Quantity=6 Discount=0.1 ExtendedPrice=52.1100 Freight=77.6300
ShipName=Eastern Connection ShipAddress=35 King George ShipCity=London ShipRegion=null ShipPostalCode=WX3 6FW ShipCountry=UK CustomerID=EASTC CustomerName=Eastern Connection Address=35 King George City=London Region=null PostalCode=WX3 6FW Country=UK Salesperson=Robert King OrderID=10532 OrderDate=5/9/1997 RequiredDate=6/6/1997 ShippedDate=5/12/1997 ShipperName=Federal Shipping ProductID=30 ProductName=Nord-Ost Matjeshering UnitPrice=25.8900 Quantity=15 Discount=0 ExtendedPrice=388.3500 Freight=74.4600
ShipName=Eastern Connection ShipAddress=35 King George ShipCity=London ShipRegion=null ShipPostalCode=WX3 6FW ShipCountry=UK CustomerID=EASTC CustomerName=Eastern Connection Address=35 King George City=London Region=null PostalCode=WX3 6FW Country=UK Salesperson=Robert King OrderID=10532 OrderDate=5/9/1997 RequiredDate=6/6/1997 ShippedDate=5/12/1997 ShipperName=Federal Shipping ProductID=66 ProductName=Louisiana Hot Spiced Okra UnitPrice=17.0000 Quantity=24 Discount=0 ExtendedPrice=408.0000 Freight=74.4600
ShipName=B's Beverages ShipAddress=Fauntleroy Circus ShipCity=London ShipRegion=null ShipPostalCode=EC2 5NT ShipCountry=UK CustomerID=BSBEV CustomerName=B's Beverages Address=Fauntleroy Circus City=London Region=null PostalCode=EC2 5NT Country=UK Salesperson=Anne Dodsworth OrderID=10538 OrderDate=5/15/1997 RequiredDate=6/12/1997 ShippedDate=5/16/1997 ShipperName=Federal Shipping ProductID=70 ProductName=Outback Lager UnitPrice=15.0000 Quantity=7 Discount=0 ExtendedPrice=105.0000 Freight=4.8700
ShipName=B's Beverages ShipAddress=Fauntleroy Circus ShipCity=London ShipRegion=null ShipPostalCode=EC2 5NT ShipCountry=UK CustomerID=BSBEV CustomerName=B's Beverages Address=Fauntleroy Circus City=London Region=null PostalCode=EC2 5NT Country=UK Salesperson=Anne Dodsworth OrderID=10538 OrderDate=5/15/1997 RequiredDate=6/12/1997 ShippedDate=5/16/1997 ShipperName=Federal Shipping ProductID=72 ProductName=Mozzarella di Giovanni UnitPrice=34.8000 Quantity=1 Discount=0 ExtendedPrice=34.8000 Freight=4.8700
ShipName=B's Beverages ShipAddress=Fauntleroy Circus ShipCity=London ShipRegion=null ShipPostalCode=EC2 5NT ShipCountry=UK CustomerID=BSBEV CustomerName=B's Beverages Address=Fauntleroy Circus City=London Region=null PostalCode=EC2 5NT Country=UK Salesperson=Michael Suyama OrderID=10539 OrderDate=5/16/1997 RequiredDate=6/13/1997 ShippedDate=5/23/1997 ShipperName=Federal Shipping ProductID=13 ProductName=Konbu UnitPrice=6.0000 Quantity=8 Discount=0 ExtendedPrice=48.0000 Freight=12.3600
ShipName=B's Beverages ShipAddress=Fauntleroy Circus ShipCity=London ShipRegion=null ShipPostalCode=EC2 5NT ShipCountry=UK CustomerID=BSBEV CustomerName=B's Beverages Address=Fauntleroy Circus City=London Region=null PostalCode=EC2 5NT Country=UK Salesperson=Michael Suyama OrderID=10539 OrderDate=5/16/1997 RequiredDate=6/13/1997 ShippedDate=5/23/1997 ShipperName=Federal Shipping ProductID=21 ProductName=Sir Rodney's Scones UnitPrice=10.0000 Quantity=15 Discount=0 ExtendedPrice=150.0000 Freight=12.3600
ShipName=B's Beverages ShipAddress=Fauntleroy Circus ShipCity=London ShipRegion=null ShipPostalCode=EC2 5NT ShipCountry=UK CustomerID=BSBEV CustomerName=B's Beverages Address=Fauntleroy Circus City=London Region=null PostalCode=EC2 5NT Country=UK Salesperson=Michael Suyama OrderID=10539 OrderDate=5/16/1997 RequiredDate=6/13/1997 ShippedDate=5/23/1997 ShipperName=Federal Shipping ProductID=33 ProductName=Geitost UnitPrice=2.5000 Quantity=15 Discount=0 ExtendedPrice=37.5000 Freight=12.3600
ShipName=B's Beverages ShipAddress=Fauntleroy Circus ShipCity=London ShipRegion=null ShipPostalCode=EC2 5NT ShipCountry=UK CustomerID=BSBEV CustomerName=B's Beverages Address=Fauntleroy Circus City=London Region=null PostalCode=EC2 5NT Country=UK Salesperson=Michael Suyama OrderID=10539 OrderDate=5/16/1997 RequiredDate=6/13/1997 ShippedDate=5/23/1997 ShipperName=Federal Shipping ProductID=49 ProductName=Maxilaku UnitPrice=20.0000 Quantity=6 Discount=0 ExtendedPrice=120.0000 Freight=12.3600
ShipName=Seven Seas Imports ShipAddress=90 Wadhurst Rd. ShipCity=London ShipRegion=null ShipPostalCode=OX15 4NB ShipCountry=UK CustomerID=SEVES CustomerName=Seven Seas Imports Address=90 Wadhurst Rd. City=London Region=null PostalCode=OX15 4NB Country=UK Salesperson=Janet Leverling OrderID=10547 OrderDate=5/23/1997 RequiredDate=6/20/1997 ShippedDate=6/2/1997 ShipperName=United Package ProductID=32 ProductName=Mascarpone Fabioli UnitPrice=32.0000 Quantity=24 Discount=0.15 ExtendedPrice=652.8000 Freight=178.4300
ShipName=Seven Seas Imports ShipAddress=90 Wadhurst Rd. ShipCity=London ShipRegion=null ShipPostalCode=OX15 4NB ShipCountry=UK CustomerID=SEVES CustomerName=Seven Seas Imports Address=90 Wadhurst Rd. City=London Region=null PostalCode=OX15 4NB Country=UK Salesperson=Janet Leverling OrderID=10547 OrderDate=5/23/1997 RequiredDate=6/20/1997 ShippedDate=6/2/1997 ShipperName=United Package ProductID=36 ProductName=Inlagd Sill UnitPrice=19.0000 Quantity=60 Discount=0 ExtendedPrice=1140.0000 Freight=178.4300
ShipName=B's Beverages ShipAddress=Fauntleroy Circus ShipCity=London ShipRegion=null ShipPostalCode=EC2 5NT ShipCountry=UK CustomerID=BSBEV CustomerName=B's Beverages Address=Fauntleroy Circus City=London Region=null PostalCode=EC2 5NT Country=UK Salesperson=Margaret Peacock OrderID=10578 OrderDate=6/24/1997 RequiredDate=7/22/1997 ShippedDate=7/25/1997 ShipperName=Federal Shipping ProductID=35 ProductName=Steeleye Stout UnitPrice=18.0000 Quantity=20 Discount=0 ExtendedPrice=360.0000 Freight=29.6000
ShipName=B's Beverages ShipAddress=Fauntleroy Circus ShipCity=London ShipRegion=null ShipPostalCode=EC2 5NT ShipCountry=UK CustomerID=BSBEV CustomerName=B's Beverages Address=Fauntleroy Circus City=London Region=null PostalCode=EC2 5NT Country=UK Salesperson=Margaret Peacock OrderID=10578 OrderDate=6/24/1997 RequiredDate=7/22/1997 ShippedDate=7/25/1997 ShipperName=Federal Shipping ProductID=57 ProductName=Ravioli Angelo UnitPrice=19.5000 Quantity=6 Discount=0 ExtendedPrice=117.0000 Freight=29.6000
ShipName=B's Beverages ShipAddress=Fauntleroy Circus ShipCity=London ShipRegion=null ShipPostalCode=EC2 5NT ShipCountry=UK CustomerID=BSBEV CustomerName=B's Beverages Address=Fauntleroy Circus City=London Region=null PostalCode=EC2 5NT Country=UK Salesperson=Michael Suyama OrderID=10599 OrderDate=7/15/1997 RequiredDate=8/26/1997 ShippedDate=7/21/1997 ShipperName=Federal Shipping ProductID=62 ProductName=Tarte au sucre UnitPrice=49.3000 Quantity=10 Discount=0 ExtendedPrice=493.0000 Freight=29.9800
ShipName=Eastern Connection ShipAddress=35 King George ShipCity=London ShipRegion=null ShipPostalCode=WX3 6FW ShipCountry=UK CustomerID=EASTC CustomerName=Eastern Connection Address=35 King George City=London Region=null PostalCode=WX3 6FW Country=UK Salesperson=Margaret Peacock OrderID=10726 OrderDate=11/3/1997 RequiredDate=11/17/1997 ShippedDate=12/5/1997 ShipperName=Speedy Express ProductID=4 ProductName=Chef Anton's Cajun Seasoning UnitPrice=22.0000 Quantity=25 Discount=0 ExtendedPrice=550.0000 Freight=16.5600
ShipName=Eastern Connection ShipAddress=35 King George ShipCity=London ShipRegion=null ShipPostalCode=WX3 6FW ShipCountry=UK CustomerID=EASTC CustomerName=Eastern Connection Address=35 King George City=London Region=null PostalCode=WX3 6FW Country=UK Salesperson=Margaret Peacock OrderID=10726 OrderDate=11/3/1997 RequiredDate=11/17/1997 ShippedDate=12/5/1997 ShipperName=Speedy Express ProductID=11 ProductName=Queso Cabrales UnitPrice=21.0000 Quantity=5 Discount=0 ExtendedPrice=105.0000 Freight=16.5600
ShipName=North/South ShipAddress=South House 300 Queensbridge ShipCity=London ShipRegion=null ShipPostalCode=SW7 1RZ ShipCountry=UK CustomerID=NORTS CustomerName=North/South Address=South House 300 Queensbridge City=London Region=null PostalCode=SW7 1RZ Country=UK Salesperson=Andrew Fuller OrderID=10752 OrderDate=11/24/1997 RequiredDate=12/22/1997 ShippedDate=11/28/1997 ShipperName=Federal Shipping ProductID=1 ProductName=Chai UnitPrice=18.0000 Quantity=8 Discount=0 ExtendedPrice=144.0000 Freight=1.3900
ShipName=North/South ShipAddress=South House 300 Queensbridge ShipCity=London ShipRegion=null ShipPostalCode=SW7 1RZ ShipCountry=UK CustomerID=NORTS CustomerName=North/South Address=South House 300 Queensbridge City=London Region=null PostalCode=SW7 1RZ Country=UK Salesperson=Andrew Fuller OrderID=10752 OrderDate=11/24/1997 RequiredDate=12/22/1997 ShippedDate=11/28/1997 ShipperName=Federal Shipping ProductID=69 ProductName=Gudbrandsdalsost UnitPrice=36.0000 Quantity=3 Discount=0 ExtendedPrice=108.0000 Freight=1.3900
ShipName=Seven Seas Imports ShipAddress=90 Wadhurst Rd. ShipCity=London ShipRegion=null ShipPostalCode=OX15 4NB ShipCountry=UK CustomerID=SEVES CustomerName=Seven Seas Imports Address=90 Wadhurst Rd. City=London Region=null PostalCode=OX15 4NB Country=UK Salesperson=Nancy Davolio OrderID=10800 OrderDate=12/26/1997 RequiredDate=1/23/1998 ShippedDate=1/5/1998 ShipperName=Federal Shipping ProductID=11 ProductName=Queso Cabrales UnitPrice=21.0000 Quantity=50 Discount=0.1 ExtendedPrice=945.0000 Freight=137.4400
ShipName=Seven Seas Imports ShipAddress=90 Wadhurst Rd. ShipCity=London ShipRegion=null ShipPostalCode=OX15 4NB ShipCountry=UK CustomerID=SEVES CustomerName=Seven Seas Imports Address=90 Wadhurst Rd. City=London Region=null PostalCode=OX15 4NB Country=UK Salesperson=Nancy Davolio OrderID=10800 OrderDate=12/26/1997 RequiredDate=1/23/1998 ShippedDate=1/5/1998 ShipperName=Federal Shipping ProductID=51 ProductName=Manjimup Dried Apples UnitPrice=53.0000 Quantity=10 Discount=0.1 ExtendedPrice=477.0000 Freight=137.4400
ShipName=Seven Seas Imports ShipAddress=90 Wadhurst Rd. ShipCity=London ShipRegion=null ShipPostalCode=OX15 4NB ShipCountry=UK CustomerID=SEVES CustomerName=Seven Seas Imports Address=90 Wadhurst Rd. City=London Region=null PostalCode=OX15 4NB Country=UK Salesperson=Nancy Davolio OrderID=10800 OrderDate=12/26/1997 RequiredDate=1/23/1998 ShippedDate=1/5/1998 ShipperName=Federal Shipping ProductID=54 ProductName=Tourtière UnitPrice=7.4500 Quantity=7 Discount=0.1 ExtendedPrice=46.9400 Freight=137.4400
ShipName=Seven Seas Imports ShipAddress=90 Wadhurst Rd. ShipCity=London ShipRegion=null ShipPostalCode=OX15 4NB ShipCountry=UK CustomerID=SEVES CustomerName=Seven Seas Imports Address=90 Wadhurst Rd. City=London Region=null PostalCode=OX15 4NB Country=UK Salesperson=Michael Suyama OrderID=10804 OrderDate=12/30/1997 RequiredDate=1/27/1998 ShippedDate=1/7/1998 ShipperName=United Package ProductID=10 ProductName=Ikura UnitPrice=31.0000 Quantity=36 Discount=0 ExtendedPrice=1116.0000 Freight=27.3300
ShipName=Seven Seas Imports ShipAddress=90 Wadhurst Rd. ShipCity=London ShipRegion=null ShipPostalCode=OX15 4NB ShipCountry=UK CustomerID=SEVES CustomerName=Seven Seas Imports Address=90 Wadhurst Rd. City=London Region=null PostalCode=OX15 4NB Country=UK Salesperson=Michael Suyama OrderID=10804 OrderDate=12/30/1997 RequiredDate=1/27/1998 ShippedDate=1/7/1998 ShipperName=United Package ProductID=28 ProductName=Rössle Sauerkraut UnitPrice=45.6000 Quantity=24 Discount=0 ExtendedPrice=1094.4000 Freight=27.3300
ShipName=Seven Seas Imports ShipAddress=90 Wadhurst Rd. ShipCity=London ShipRegion=null ShipPostalCode=OX15 4NB ShipCountry=UK CustomerID=SEVES CustomerName=Seven Seas Imports Address=90 Wadhurst Rd. City=London Region=null PostalCode=OX15 4NB Country=UK Salesperson=Michael Suyama OrderID=10804 OrderDate=12/30/1997 RequiredDate=1/27/1998 ShippedDate=1/7/1998 ShipperName=United Package ProductID=49 ProductName=Maxilaku UnitPrice=20.0000 Quantity=4 Discount=0.15 ExtendedPrice=68.0000 Freight=27.3300
ShipName=Consolidated Holdings ShipAddress=Berkeley Gardens 12 Brewery ShipCity=London ShipRegion=null ShipPostalCode=WX1 6LT ShipCountry=UK CustomerID=CONSH CustomerName=Consolidated Holdings Address=Berkeley Gardens 12 Brewery City=London Region=null PostalCode=WX1 6LT Country=UK Salesperson=Robert King OrderID=10848 OrderDate=1/23/1998 RequiredDate=2/20/1998 ShippedDate=1/29/1998 ShipperName=United Package ProductID=5 ProductName=Chef Anton's Gumbo Mix UnitPrice=21.3500 Quantity=30 Discount=0 ExtendedPrice=640.5000 Freight=38.2400
ShipName=Consolidated Holdings ShipAddress=Berkeley Gardens 12 Brewery ShipCity=London ShipRegion=null ShipPostalCode=WX1 6LT ShipCountry=UK CustomerID=CONSH CustomerName=Consolidated Holdings Address=Berkeley Gardens 12 Brewery City=London Region=null PostalCode=WX1 6LT Country=UK Salesperson=Robert King OrderID=10848 OrderDate=1/23/1998 RequiredDate=2/20/1998 ShippedDate=1/29/1998 ShipperName=United Package ProductID=9 ProductName=Mishi Kobe Niku UnitPrice=97.0000 Quantity=3 Discount=0 ExtendedPrice=291.0000 Freight=38.2400
ShipName=Seven Seas Imports ShipAddress=90 Wadhurst Rd. ShipCity=London ShipRegion=null ShipPostalCode=OX15 4NB ShipCountry=UK CustomerID=SEVES CustomerName=Seven Seas Imports Address=90 Wadhurst Rd. City=London Region=null PostalCode=OX15 4NB Country=UK Salesperson=Steven Buchanan OrderID=10869 OrderDate=2/4/1998 RequiredDate=3/4/1998 ShippedDate=2/9/1998 ShipperName=Speedy Express ProductID=1 ProductName=Chai UnitPrice=18.0000 Quantity=40 Discount=0 ExtendedPrice=720.0000 Freight=143.2800
ShipName=Seven Seas Imports ShipAddress=90 Wadhurst Rd. ShipCity=London ShipRegion=null ShipPostalCode=OX15 4NB ShipCountry=UK CustomerID=SEVES CustomerName=Seven Seas Imports Address=90 Wadhurst Rd. City=London Region=null PostalCode=OX15 4NB Country=UK Salesperson=Steven Buchanan OrderID=10869 OrderDate=2/4/1998 RequiredDate=3/4/1998 ShippedDate=2/9/1998 ShipperName=Speedy Express ProductID=11 ProductName=Queso Cabrales UnitPrice=21.0000 Quantity=10 Discount=0 ExtendedPrice=210.0000 Freight=143.2800
ShipName=Seven Seas Imports ShipAddress=90 Wadhurst Rd. ShipCity=London ShipRegion=null ShipPostalCode=OX15 4NB ShipCountry=UK CustomerID=SEVES CustomerName=Seven Seas Imports Address=90 Wadhurst Rd. City=London Region=null PostalCode=OX15 4NB Country=UK Salesperson=Steven Buchanan OrderID=10869 OrderDate=2/4/1998 RequiredDate=3/4/1998 ShippedDate=2/9/1998 ShipperName=Speedy Express ProductID=23 ProductName=Tunnbröd UnitPrice=9.0000 Quantity=50 Discount=0 ExtendedPrice=450.0000 Freight=143.2800
ShipName=Seven Seas Imports ShipAddress=90 Wadhurst Rd. ShipCity=London ShipRegion=null ShipPostalCode=OX15 4NB ShipCountry=UK CustomerID=SEVES CustomerName=Seven Seas Imports Address=90 Wadhurst Rd. City=London Region=null PostalCode=OX15 4NB Country=UK Salesperson=Steven Buchanan OrderID=10869 OrderDate=2/4/1998 RequiredDate=3/4/1998 ShippedDate=2/9/1998 ShipperName=Speedy Express ProductID=68 ProductName=Scottish Longbreads UnitPrice=12.5000 Quantity=20 Discount=0 ExtendedPrice=250.0000 Freight=143.2800
ShipName=B's Beverages ShipAddress=Fauntleroy Circus ShipCity=London ShipRegion=null ShipPostalCode=EC2 5NT ShipCountry=UK CustomerID=BSBEV CustomerName=B's Beverages Address=Fauntleroy Circus City=London Region=null PostalCode=EC2 5NT Country=UK Salesperson=Margaret Peacock OrderID=10943 OrderDate=3/11/1998 RequiredDate=4/8/1998 ShippedDate=3/19/1998 ShipperName=United Package ProductID=13 ProductName=Konbu UnitPrice=6.0000 Quantity=15 Discount=0 ExtendedPrice=90.0000 Freight=2.1700
ShipName=B's Beverages ShipAddress=Fauntleroy Circus ShipCity=London ShipRegion=null ShipPostalCode=EC2 5NT ShipCountry=UK CustomerID=BSBEV CustomerName=B's Beverages Address=Fauntleroy Circus City=London Region=null PostalCode=EC2 5NT Country=UK Salesperson=Margaret Peacock OrderID=10943 OrderDate=3/11/1998 RequiredDate=4/8/1998 ShippedDate=3/19/1998 ShipperName=United Package ProductID=22 ProductName=Gustaf's Knäckebröd UnitPrice=21.0000 Quantity=21 Discount=0 ExtendedPrice=441.0000 Freight=2.1700
ShipName=B's Beverages ShipAddress=Fauntleroy Circus ShipCity=London ShipRegion=null ShipPostalCode=EC2 5NT ShipCountry=UK CustomerID=BSBEV CustomerName=B's Beverages Address=Fauntleroy Circus City=London Region=null PostalCode=EC2 5NT Country=UK Salesperson=Margaret Peacock OrderID=10943 OrderDate=3/11/1998 RequiredDate=4/8/1998 ShippedDate=3/19/1998 ShipperName=United Package ProductID=46 ProductName=Spegesild UnitPrice=12.0000 Quantity=15 Discount=0 ExtendedPrice=180.0000 Freight=2.1700
ShipName=B's Beverages ShipAddress=Fauntleroy Circus ShipCity=London ShipRegion=null ShipPostalCode=EC2 5NT ShipCountry=UK CustomerID=BSBEV CustomerName=B's Beverages Address=Fauntleroy Circus City=London Region=null PostalCode=EC2 5NT Country=UK Salesperson=Janet Leverling OrderID=10947 OrderDate=3/13/1998 RequiredDate=4/10/1998 ShippedDate=3/16/1998 ShipperName=United Package ProductID=59 ProductName=Raclette Courdavault UnitPrice=55.0000 Quantity=4 Discount=0 ExtendedPrice=220.0000 Freight=3.2600
ShipName=Eastern Connection ShipAddress=35 King George ShipCity=London ShipRegion=null ShipPostalCode=WX3 6FW ShipCountry=UK CustomerID=EASTC CustomerName=Eastern Connection Address=35 King George City=London Region=null PostalCode=WX3 6FW Country=UK Salesperson=Laura Callahan OrderID=10987 OrderDate=3/31/1998 RequiredDate=4/28/1998 ShippedDate=4/6/1998 ShipperName=Speedy Express ProductID=7 ProductName=Uncle Bob's Organic Dried Pears UnitPrice=30.0000 Quantity=60 Discount=0 ExtendedPrice=1800.0000 Freight=185.4800
ShipName=Eastern Connection ShipAddress=35 King George ShipCity=London ShipRegion=null ShipPostalCode=WX3 6FW ShipCountry=UK CustomerID=EASTC CustomerName=Eastern Connection Address=35 King George City=London Region=null PostalCode=WX3 6FW Country=UK Salesperson=Laura Callahan OrderID=10987 OrderDate=3/31/1998 RequiredDate=4/28/1998 ShippedDate=4/6/1998 ShipperName=Speedy Express ProductID=43 ProductName=Ipoh Coffee UnitPrice=46.0000 Quantity=6 Discount=0 ExtendedPrice=276.0000 Freight=185.4800
ShipName=Eastern Connection ShipAddress=35 King George ShipCity=London ShipRegion=null ShipPostalCode=WX3 6FW ShipCountry=UK CustomerID=EASTC CustomerName=Eastern Connection Address=35 King George City=London Region=null PostalCode=WX3 6FW Country=UK Salesperson=Laura Callahan OrderID=10987 OrderDate=3/31/1998 RequiredDate=4/28/1998 ShippedDate=4/6/1998 ShipperName=Speedy Express ProductID=72 ProductName=Mozzarella di Giovanni UnitPrice=34.8000 Quantity=20 Discount=0 ExtendedPrice=696.0000 Freight=185.4800
ShipName=B's Beverages ShipAddress=Fauntleroy Circus ShipCity=London ShipRegion=null ShipPostalCode=EC2 5NT ShipCountry=UK CustomerID=BSBEV CustomerName=B's Beverages Address=Fauntleroy Circus City=London Region=null PostalCode=EC2 5NT Country=UK Salesperson=Nancy Davolio OrderID=11023 OrderDate=4/14/1998 RequiredDate=4/28/1998 ShippedDate=4/24/1998 ShipperName=United Package ProductID=7 ProductName=Uncle Bob's Organic Dried Pears UnitPrice=30.0000 Quantity=4 Discount=0 ExtendedPrice=120.0000 Freight=123.8300
ShipName=B's Beverages ShipAddress=Fauntleroy Circus ShipCity=London ShipRegion=null ShipPostalCode=EC2 5NT ShipCountry=UK CustomerID=BSBEV CustomerName=B's Beverages Address=Fauntleroy Circus City=London Region=null PostalCode=EC2 5NT Country=UK Salesperson=Nancy Davolio OrderID=11023 OrderDate=4/14/1998 RequiredDate=4/28/1998 ShippedDate=4/24/1998 ShipperName=United Package ProductID=43 ProductName=Ipoh Coffee UnitPrice=46.0000 Quantity=30 Discount=0 ExtendedPrice=1380.0000 Freight=123.8300
ShipName=Eastern Connection ShipAddress=35 King George ShipCity=London ShipRegion=null ShipPostalCode=WX3 6FW ShipCountry=UK CustomerID=EASTC CustomerName=Eastern Connection Address=35 King George City=London Region=null PostalCode=WX3 6FW Country=UK Salesperson=Margaret Peacock OrderID=11024 OrderDate=4/15/1998 RequiredDate=5/13/1998 ShippedDate=4/20/1998 ShipperName=Speedy Express ProductID=26 ProductName=Gumbär Gummibärchen UnitPrice=31.2300 Quantity=12 Discount=0 ExtendedPrice=374.7600 Freight=74.3600
ShipName=Eastern Connection ShipAddress=35 King George ShipCity=London ShipRegion=null ShipPostalCode=WX3 6FW ShipCountry=UK CustomerID=EASTC CustomerName=Eastern Connection Address=35 King George City=London Region=null PostalCode=WX3 6FW Country=UK Salesperson=Margaret Peacock OrderID=11024 OrderDate=4/15/1998 RequiredDate=5/13/1998 ShippedDate=4/20/1998 ShipperName=Speedy Express ProductID=33 ProductName=Geitost UnitPrice=2.5000 Quantity=30 Discount=0 ExtendedPrice=75.0000 Freight=74.3600
ShipName=Eastern Connection ShipAddress=35 King George ShipCity=London ShipRegion=null ShipPostalCode=WX3 6FW ShipCountry=UK CustomerID=EASTC CustomerName=Eastern Connection Address=35 King George City=London Region=null PostalCode=WX3 6FW Country=UK Salesperson=Margaret Peacock OrderID=11024 OrderDate=4/15/1998 RequiredDate=5/13/1998 ShippedDate=4/20/1998 ShipperName=Speedy Express ProductID=65 ProductName=Louisiana Fiery Hot Pepper Sauce UnitPrice=21.0500 Quantity=21 Discount=0 ExtendedPrice=442.0500 Freight=74.3600
ShipName=Eastern Connection ShipAddress=35 King George ShipCity=London ShipRegion=null ShipPostalCode=WX3 6FW ShipCountry=UK CustomerID=EASTC CustomerName=Eastern Connection Address=35 King George City=London Region=null PostalCode=WX3 6FW Country=UK Salesperson=Margaret Peacock OrderID=11024 OrderDate=4/15/1998 RequiredDate=5/13/1998 ShippedDate=4/20/1998 ShipperName=Speedy Express ProductID=71 ProductName=Flotemysost UnitPrice=21.5000 Quantity=50 Discount=0 ExtendedPrice=1075.0000 Freight=74.3600
ShipName=Eastern Connection ShipAddress=35 King George ShipCity=London ShipRegion=null ShipPostalCode=WX3 6FW ShipCountry=UK CustomerID=EASTC CustomerName=Eastern Connection Address=35 King George City=London Region=null PostalCode=WX3 6FW Country=UK Salesperson=Robert King OrderID=11047 OrderDate=4/24/1998 RequiredDate=5/22/1998 ShippedDate=5/1/1998 ShipperName=Federal Shipping ProductID=1 ProductName=Chai UnitPrice=18.0000 Quantity=25 Discount=0.25 ExtendedPrice=337.5000 Freight=46.6200
ShipName=Eastern Connection ShipAddress=35 King George ShipCity=London ShipRegion=null ShipPostalCode=WX3 6FW ShipCountry=UK CustomerID=EASTC CustomerName=Eastern Connection Address=35 King George City=London Region=null PostalCode=WX3 6FW Country=UK Salesperson=Robert King OrderID=11047 OrderDate=4/24/1998 RequiredDate=5/22/1998 ShippedDate=5/1/1998 ShipperName=Federal Shipping ProductID=5 ProductName=Chef Anton's Gumbo Mix UnitPrice=21.3500 Quantity=30 Discount=0.25 ExtendedPrice=480.3800 Freight=46.6200
ShipName=Eastern Connection ShipAddress=35 King George ShipCity=London ShipRegion=null ShipPostalCode=WX3 6FW ShipCountry=UK CustomerID=EASTC CustomerName=Eastern Connection Address=35 King George City=London Region=null PostalCode=WX3 6FW Country=UK Salesperson=Laura Callahan OrderID=11056 OrderDate=4/28/1998 RequiredDate=5/12/1998 ShippedDate=5/1/1998 ShipperName=United Package ProductID=7 ProductName=Uncle Bob's Organic Dried Pears UnitPrice=30.0000 Quantity=40 Discount=0 ExtendedPrice=1200.0000 Freight=278.9600
ShipName=Eastern Connection ShipAddress=35 King George ShipCity=London ShipRegion=null ShipPostalCode=WX3 6FW ShipCountry=UK CustomerID=EASTC CustomerName=Eastern Connection Address=35 King George City=London Region=null PostalCode=WX3 6FW Country=UK Salesperson=Laura Callahan OrderID=11056 OrderDate=4/28/1998 RequiredDate=5/12/1998 ShippedDate=5/1/1998 ShipperName=United Package ProductID=55 ProductName=Pâté chinois UnitPrice=24.0000 Quantity=35 Discount=0 ExtendedPrice=840.0000 Freight=278.9600
ShipName=Eastern Connection ShipAddress=35 King George ShipCity=London ShipRegion=null ShipPostalCode=WX3 6FW ShipCountry=UK CustomerID=EASTC CustomerName=Eastern Connection Address=35 King George City=London Region=null PostalCode=WX3 6FW Country=UK Salesperson=Laura Callahan OrderID=11056 OrderDate=4/28/1998 RequiredDate=5/12/1998 ShippedDate=5/1/1998 ShipperName=United Package ProductID=60 ProductName=Camembert Pierrot UnitPrice=34.0000 Quantity=50 Discount=0 ExtendedPrice=1700.0000 Freight=278.9600
ShipName=North/South ShipAddress=South House 300 Queensbridge ShipCity=London ShipRegion=null ShipPostalCode=SW7 1RZ ShipCountry=UK CustomerID=NORTS CustomerName=North/South Address=South House 300 Queensbridge City=London Region=null PostalCode=SW7 1RZ Country=UK Salesperson=Janet Leverling OrderID=11057 OrderDate=4/29/1998 RequiredDate=5/27/1998 ShippedDate=5/1/1998 ShipperName=Federal Shipping ProductID=70 ProductName=Outback Lager UnitPrice=15.0000 Quantity=3 Discount=0 ExtendedPrice=45.0000 Freight=4.1300
This sample uses SELECT to query QuarterlyOrders.
Public Sub LinqToSqlView03()
Dim q = From qo In db.Quarterly_Orders _
Select qo
ObjectDumper.Write(q, 1)
End Sub
Result:
CustomerID=ALFKI CompanyName=Alfreds Futterkiste City=Berlin Country=Germany
CustomerID=ANATR CompanyName=Ana Trujillo Emparedados y helados City=México D.F. Country=Mexico
CustomerID=ANTON CompanyName=Antonio Moreno Taquería City=México D.F. Country=Mexico
CustomerID=AROUT CompanyName=Around the Horn City=London Country=UK
CustomerID=BERGS CompanyName=Berglunds snabbköp City=Luleå Country=Sweden
CustomerID=BLAUS CompanyName=Blauer See Delikatessen City=Mannheim Country=Germany
CustomerID=BLONP CompanyName=Blondesddsl père et fils City=Strasbourg Country=France
CustomerID=BOLID CompanyName=Bólido Comidas preparadas City=Madrid Country=Spain
CustomerID=BONAP CompanyName=Bon app' City=Marseille Country=France
CustomerID=BOTTM CompanyName=Bottom-Dollar Markets City=Tsawassen Country=Canada
CustomerID=BSBEV CompanyName=B's Beverages City=London Country=UK
CustomerID=CACTU CompanyName=Cactus Comidas para llevar City=Buenos Aires Country=Argentina
CustomerID=CHOPS CompanyName=Chop-suey Chinese City=Bern Country=Switzerland
CustomerID=COMMI CompanyName=Comércio Mineiro City=Sao Paulo Country=Brazil
CustomerID=CONSH CompanyName=Consolidated Holdings City=London Country=UK
CustomerID=DRACD CompanyName=Drachenblut Delikatessen City=Aachen Country=Germany
CustomerID=DUMON CompanyName=Du monde entier City=Nantes Country=France
CustomerID=EASTC CompanyName=Eastern Connection City=London Country=UK
CustomerID=ERNSH CompanyName=Ernst Handel City=Graz Country=Austria
CustomerID=FAMIA CompanyName=Familia Arquibaldo City=Sao Paulo Country=Brazil
CustomerID=FOLIG CompanyName=Folies gourmandes City=Lille Country=France
CustomerID=FOLKO CompanyName=Folk och fä HB City=Bräcke Country=Sweden
CustomerID=FRANK CompanyName=Frankenversand City=München Country=Germany
CustomerID=FRANR CompanyName=France restauration City=Nantes Country=France
CustomerID=FRANS CompanyName=Franchi S.p.A. City=Torino Country=Italy
CustomerID=FURIB CompanyName=Furia Bacalhau e Frutos do Mar City=Lisboa Country=Portugal
CustomerID=GALED CompanyName=Galería del gastrónomo City=Barcelona Country=Spain
CustomerID=GODOS CompanyName=Godos Cocina Típica City=Sevilla Country=Spain
CustomerID=GOURL CompanyName=Gourmet Lanchonetes City=Campinas Country=Brazil
CustomerID=GREAL CompanyName=Great Lakes Food Market City=Eugene Country=USA
CustomerID=GROSR CompanyName=GROSELLA-Restaurante City=Caracas Country=Venezuela
CustomerID=HANAR CompanyName=Hanari Carnes City=Rio de Janeiro Country=Brazil
CustomerID=HILAA CompanyName=HILARION-Abastos City=San Cristóbal Country=Venezuela
CustomerID=HUNGC CompanyName=Hungry Coyote Import Store City=Elgin Country=USA
CustomerID=HUNGO CompanyName=Hungry Owl All-Night Grocers City=Cork Country=Ireland
CustomerID=ISLAT CompanyName=Island Trading City=Cowes Country=UK
CustomerID=KOENE CompanyName=Königlich Essen City=Brandenburg Country=Germany
CustomerID=LAMAI CompanyName=La maison d'Asie City=Toulouse Country=France
CustomerID=LAUGB CompanyName=Laughing Bacchus Wine Cellars City=Vancouver Country=Canada
CustomerID=LAZYK CompanyName=Lazy K Kountry Store City=Walla Walla Country=USA
CustomerID=LEHMS CompanyName=Lehmanns Marktstand City=Frankfurt a.M. Country=Germany
CustomerID=LETSS CompanyName=Let's Stop N Shop City=San Francisco Country=USA
CustomerID=LILAS CompanyName=LILA-Supermercado City=Barquisimeto Country=Venezuela
CustomerID=LINOD CompanyName=LINO-Delicateses City=I. de Margarita Country=Venezuela
CustomerID=LONEP CompanyName=Lonesome Pine Restaurant City=Portland Country=USA
CustomerID=MAGAA CompanyName=Magazzini Alimentari Riuniti City=Bergamo Country=Italy
CustomerID=MAISD CompanyName=Maison Dewey City=Bruxelles Country=Belgium
CustomerID=MEREP CompanyName=Mère Paillarde City=Montréal Country=Canada
CustomerID=MORGK CompanyName=Morgenstern Gesundkost City=Leipzig Country=Germany
CustomerID=NORTS CompanyName=North/South City=London Country=UK
CustomerID=OCEAN CompanyName=Océano Atlántico Ltda. City=Buenos Aires Country=Argentina
CustomerID=OLDWO CompanyName=Old World Delicatessen City=Anchorage Country=USA
CustomerID=OTTIK CompanyName=Ottilies Käseladen City=Köln Country=Germany
CustomerID=PERIC CompanyName=Pericles Comidas clásicas City=México D.F. Country=Mexico
CustomerID=PICCO CompanyName=Piccolo und mehr City=Salzburg Country=Austria
CustomerID=PRINI CompanyName=Princesa Isabel Vinhos City=Lisboa Country=Portugal
CustomerID=QUEDE CompanyName=Que Delícia City=Rio de Janeiro Country=Brazil
CustomerID=QUEEN CompanyName=Queen Cozinha City=Sao Paulo Country=Brazil
CustomerID=QUICK CompanyName=QUICK-Stop City=Cunewalde Country=Germany
CustomerID=RANCH CompanyName=Rancho grande City=Buenos Aires Country=Argentina
CustomerID=RATTC CompanyName=Rattlesnake Canyon Grocery City=Albuquerque Country=USA
CustomerID=REGGC CompanyName=Reggiani Caseifici City=Reggio Emilia Country=Italy
CustomerID=RICAR CompanyName=Ricardo Adocicados City=Rio de Janeiro Country=Brazil
CustomerID=RICSU CompanyName=Richter Supermarkt City=Genève Country=Switzerland
CustomerID=SANTG CompanyName=Santé Gourmet City=Stavern Country=Norway
CustomerID=SAVEA CompanyName=Save-a-lot Markets City=Boise Country=USA
CustomerID=SEVES CompanyName=Seven Seas Imports City=London Country=UK
CustomerID=SIMOB CompanyName=Simons bistro City=Kobenhavn Country=Denmark
CustomerID=SPECD CompanyName=Spécialités du monde City=Paris Country=France
CustomerID=SPLIR CompanyName=Split Rail Beer & Ale City=Lander Country=USA
CustomerID=SUPRD CompanyName=Suprêmes délices City=Charleroi Country=Belgium
CustomerID=THEBI CompanyName=The Big Cheese City=Portland Country=USA
CustomerID=THECR CompanyName=The Cracker Box City=Butte Country=USA
CustomerID=TOMSP CompanyName=Toms Spezialitäten City=Münster Country=Germany
CustomerID=TORTU CompanyName=Tortuga Restaurante City=México D.F. Country=Mexico
CustomerID=TRADH CompanyName=Tradição Hipermercados City=Sao Paulo Country=Brazil
CustomerID=TRAIH CompanyName=Trail's Head Gourmet Provisioners City=Kirkland Country=USA
CustomerID=VAFFE CompanyName=Vaffeljernet City=Århus Country=Denmark
CustomerID=VICTE CompanyName=Victuailles en stock City=Lyon Country=France
CustomerID=VINET CompanyName=Vins et alcools Chevalier City=Reims Country=France
CustomerID=WANDK CompanyName=Die Wandernde Kuh City=Stuttgart Country=Germany
CustomerID=WARTH CompanyName=Wartian Herkku City=Oulu Country=Finland
CustomerID=WELLI CompanyName=Wellington Importadora City=Resende Country=Brazil
CustomerID=WHITC CompanyName=White Clover Markets City=Seattle Country=USA
CustomerID=WILMK CompanyName=Wilman Kala City=Helsinki Country=Finland
CustomerID=WOLZA CompanyName=Wolski Zajazd City=Warszawa Country=Poland
