LINQ To SQL Samples - InheritanceOn This Page |
This sample returns all contacts where the city is London.
Public Sub LinqToSqlInheritance01()
Dim cons = From c In newDB.Contacts _
Select c
For Each con In cons
Console.WriteLine("Company name: {0}", con.CompanyName)
Console.WriteLine("Phone: {0}", con.Phone)
Console.WriteLine("This is a {0}", con.GetType())
Console.WriteLine()
Next
End Sub
Result:
Company name: Alfreds Futterkiste
Phone: 030-0074321
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Ana Trujillo Emparedados y helados
Phone: (5) 555-4729
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Antonio Moreno Taquería
Phone: (5) 555-3932
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Around the Horn
Phone: (171) 555-7788
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Berglunds snabbköp
Phone: 0921-12 34 65
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Blauer See Delikatessen
Phone: 0621-08460
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Blondesddsl père et fils
Phone: 88.60.15.31
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Bólido Comidas preparadas
Phone: (91) 555 22 82
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Bon app'
Phone: 91.24.45.40
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Bottom-Dollar Markets
Phone: (604) 555-4729
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: B's Beverages
Phone: (171) 555-1212
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Cactus Comidas para llevar
Phone: (1) 135-5555
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Centro comercial Moctezuma
Phone: (5) 555-3392
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Chop-suey Chinese
Phone: 0452-076545
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Comércio Mineiro
Phone: (11) 555-7647
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Consolidated Holdings
Phone: (171) 555-2282
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Drachenblut Delikatessen
Phone: 0241-039123
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Du monde entier
Phone: 40.67.88.88
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Eastern Connection
Phone: (171) 555-0297
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Ernst Handel
Phone: 7675-3425
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Familia Arquibaldo
Phone: (11) 555-9857
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: FISSA Fabrica Inter. Salchichas S.A.
Phone: (91) 555 94 44
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Folies gourmandes
Phone: 20.16.10.16
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Folk och fä HB
Phone: 0695-34 67 21
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Frankenversand
Phone: 089-0877310
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: France restauration
Phone: 40.32.21.21
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Franchi S.p.A.
Phone: 011-4988260
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Furia Bacalhau e Frutos do Mar
Phone: (1) 354-2534
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Galería del gastrónomo
Phone: (93) 203 4560
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Godos Cocina Típica
Phone: (95) 555 82 82
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Gourmet Lanchonetes
Phone: (11) 555-9482
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Great Lakes Food Market
Phone: (503) 555-7555
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: GROSELLA-Restaurante
Phone: (2) 283-2951
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Hanari Carnes
Phone: (21) 555-0091
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: HILARION-Abastos
Phone: (5) 555-1340
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Hungry Coyote Import Store
Phone: (503) 555-6874
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Hungry Owl All-Night Grocers
Phone: 2967 542
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Island Trading
Phone: (198) 555-8888
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Königlich Essen
Phone: 0555-09876
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: La corne d'abondance
Phone: 30.59.84.10
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: La maison d'Asie
Phone: 61.77.61.10
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Laughing Bacchus Wine Cellars
Phone: (604) 555-3392
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Lazy K Kountry Store
Phone: (509) 555-7969
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Lehmanns Marktstand
Phone: 069-0245984
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Let's Stop N Shop
Phone: (415) 555-5938
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: LILA-Supermercado
Phone: (9) 331-6954
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: LINO-Delicateses
Phone: (8) 34-56-12
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Lonesome Pine Restaurant
Phone: (503) 555-9573
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Magazzini Alimentari Riuniti
Phone: 035-640230
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Maison Dewey
Phone: (02) 201 24 67
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Mère Paillarde
Phone: (514) 555-8054
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Morgenstern Gesundkost
Phone: 0342-023176
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: North/South
Phone: (171) 555-7733
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Océano Atlántico Ltda.
Phone: (1) 135-5333
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Old World Delicatessen
Phone: (907) 555-7584
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Ottilies Käseladen
Phone: 0221-0644327
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Paris spécialités
Phone: (1) 42.34.22.66
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Pericles Comidas clásicas
Phone: (5) 552-3745
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Piccolo und mehr
Phone: 6562-9722
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Princesa Isabel Vinhos
Phone: (1) 356-5634
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Que Delícia
Phone: (21) 555-4252
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Queen Cozinha
Phone: (11) 555-1189
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: QUICK-Stop
Phone: 0372-035188
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Rancho grande
Phone: (1) 123-5555
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Rattlesnake Canyon Grocery
Phone: (505) 555-5939
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Reggiani Caseifici
Phone: 0522-556721
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Ricardo Adocicados
Phone: (21) 555-3412
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Richter Supermarkt
Phone: 0897-034214
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Romero y tomillo
Phone: (91) 745 6200
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Santé Gourmet
Phone: 07-98 92 35
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Save-a-lot Markets
Phone: (208) 555-8097
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Seven Seas Imports
Phone: (171) 555-1717
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Simons bistro
Phone: 31 12 34 56
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Spécialités du monde
Phone: (1) 47.55.60.10
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Split Rail Beer & Ale
Phone: (307) 555-4680
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Suprêmes délices
Phone: (071) 23 67 22 20
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: The Big Cheese
Phone: (503) 555-3612
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: The Cracker Box
Phone: (406) 555-5834
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Toms Spezialitäten
Phone: 0251-031259
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Tortuga Restaurante
Phone: (5) 555-2933
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Tradição Hipermercados
Phone: (11) 555-2167
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Trail's Head Gourmet Provisioners
Phone: (206) 555-8257
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Vaffeljernet
Phone: 86 21 32 43
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Victuailles en stock
Phone: 78.32.54.86
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Vins et alcools Chevalier
Phone: 26.47.15.10
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Die Wandernde Kuh
Phone: 0711-020361
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Wartian Herkku
Phone: 981-443655
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Wellington Importadora
Phone: (14) 555-8122
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: White Clover Markets
Phone: (206) 555-4112
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Wilman Kala
Phone: 90-224 8858
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Wolski Zajazd
Phone: (26) 642-7012
This is a SampleQueries.NorthwindInheritance+CustomerContact
Company name: Exotic Liquids
Phone: (171) 555-2222
This is a SampleQueries.NorthwindInheritance+SupplierContact
Company name: New Orleans Cajun Delights
Phone: (100) 555-4822
This is a SampleQueries.NorthwindInheritance+SupplierContact
Company name: Grandma Kelly's Homestead
Phone: (313) 555-5735
This is a SampleQueries.NorthwindInheritance+SupplierContact
Company name: Tokyo Traders
Phone: (03) 3555-5011
This is a SampleQueries.NorthwindInheritance+SupplierContact
Company name: Cooperativa de Quesos 'Las Cabras'
Phone: (98) 598 76 54
This is a SampleQueries.NorthwindInheritance+SupplierContact
Company name: Mayumi's
Phone: (06) 431-7877
This is a SampleQueries.NorthwindInheritance+SupplierContact
Company name: Pavlova, Ltd.
Phone: (03) 444-2343
This is a SampleQueries.NorthwindInheritance+SupplierContact
Company name: Specialty Biscuits, Ltd.
Phone: (161) 555-4448
This is a SampleQueries.NorthwindInheritance+SupplierContact
Company name: PB Knäckebröd AB
Phone: 031-987 65 43
This is a SampleQueries.NorthwindInheritance+SupplierContact
Company name: Refrescos Americanas LTDA
Phone: (11) 555 4640
This is a SampleQueries.NorthwindInheritance+SupplierContact
Company name: Heli Süßwaren GmbH & Co. KG
Phone: (010) 9984510
This is a SampleQueries.NorthwindInheritance+SupplierContact
Company name: Plutzer Lebensmittelgroßmärkte AG
Phone: (069) 992755
This is a SampleQueries.NorthwindInheritance+SupplierContact
Company name: Nord-Ost-Fisch Handelsgesellschaft mbH
Phone: (04721) 8713
This is a SampleQueries.NorthwindInheritance+SupplierContact
Company name: Formaggi Fortini s.r.l.
Phone: (0544) 60323
This is a SampleQueries.NorthwindInheritance+SupplierContact
Company name: Norske Meierier
Phone: (0)2-953010
This is a SampleQueries.NorthwindInheritance+SupplierContact
Company name: Bigfoot Breweries
Phone: (503) 555-9931
This is a SampleQueries.NorthwindInheritance+SupplierContact
Company name: Svensk Sjöföda AB
Phone: 08-123 45 67
This is a SampleQueries.NorthwindInheritance+SupplierContact
Company name: Aux joyeux ecclésiastiques
Phone: (1) 03.83.00.68
This is a SampleQueries.NorthwindInheritance+SupplierContact
Company name: New England Seafood Cannery
Phone: (617) 555-3267
This is a SampleQueries.NorthwindInheritance+SupplierContact
Company name: Leka Trading
Phone: 555-8787
This is a SampleQueries.NorthwindInheritance+SupplierContact
Company name: Lyngbysild
Phone: 43844108
This is a SampleQueries.NorthwindInheritance+SupplierContact
Company name: Zaanse Snoepfabriek
Phone: (12345) 1212
This is a SampleQueries.NorthwindInheritance+SupplierContact
Company name: Karkki Oy
Phone: (953) 10956
This is a SampleQueries.NorthwindInheritance+SupplierContact
Company name: G'day, Mate
Phone: (02) 555-5914
This is a SampleQueries.NorthwindInheritance+SupplierContact
Company name: Ma Maison
Phone: (514) 555-9022
This is a SampleQueries.NorthwindInheritance+SupplierContact
Company name: Pasta Buttini s.r.l.
Phone: (089) 6547665
This is a SampleQueries.NorthwindInheritance+SupplierContact
Company name: Escargots Nouveaux
Phone: 85.57.00.07
This is a SampleQueries.NorthwindInheritance+SupplierContact
Company name: Gai pâturage
Phone: 38.76.98.06
This is a SampleQueries.NorthwindInheritance+SupplierContact
Company name: Forêts d'érables
Phone: (514) 555-2955
This is a SampleQueries.NorthwindInheritance+SupplierContact
Company name: Northwind
Phone: (206) 555-9857
This is a SampleQueries.NorthwindInheritance+EmployeeContact
Company name: Northwind
Phone: (206) 555-9482
This is a SampleQueries.NorthwindInheritance+EmployeeContact
Company name: Northwind
Phone: (206) 555-3412
This is a SampleQueries.NorthwindInheritance+EmployeeContact
Company name: Northwind
Phone: (206) 555-8122
This is a SampleQueries.NorthwindInheritance+EmployeeContact
Company name: Northwind
Phone: (71) 555-4848
This is a SampleQueries.NorthwindInheritance+EmployeeContact
Company name: Northwind
Phone: (71) 555-7773
This is a SampleQueries.NorthwindInheritance+EmployeeContact
Company name: Northwind
Phone: (71) 555-5598
This is a SampleQueries.NorthwindInheritance+EmployeeContact
Company name: Northwind
Phone: (206) 555-1189
This is a SampleQueries.NorthwindInheritance+EmployeeContact
Company name: Northwind
Phone: (71) 555-4444
This is a SampleQueries.NorthwindInheritance+EmployeeContact
Company name: Speedy Express
Phone: (503) 555-9831
This is a SampleQueries.NorthwindInheritance+ShipperContact
Company name: United Package
Phone: (503) 555-3199
This is a SampleQueries.NorthwindInheritance+ShipperContact
Company name: Federal Shipping
Phone: (503) 555-9931
This is a SampleQueries.NorthwindInheritance+ShipperContact
Company name: Unknown
Phone: 123-456-7880
This is a SampleQueries.NorthwindInheritance+BaseContact
This sample uses OfType to return all customer contacts.
Public Sub LinqToSqlInheritance02()
Dim cons = From c In newDB.Contacts.OfType(Of CustomerContact)() _
Select c
ObjectDumper.Write(cons, 0)
End Sub
Result:
ContactName=Maria Anders ContactTitle=Sales Representative Address=Obere Str. 57 City=Berlin Region=null PostalCode=12209 Country=Germany Fax=030-0076545 ContactID=1 ContactType=Customer CompanyName=Alfreds Futterkiste Phone=030-0074321
ContactName=Ana Trujillo ContactTitle=Owner Address=Avda. de la Constitución 2222 City=México D.F. Region=null PostalCode=05021 Country=Mexico Fax=(5) 555-3745 ContactID=2 ContactType=Customer CompanyName=Ana Trujillo Emparedados y helados Phone=(5) 555-4729
ContactName=Antonio Moreno ContactTitle=Owner Address=Mataderos 2312 City=México D.F. Region=null PostalCode=05023 Country=Mexico Fax=null ContactID=3 ContactType=Customer CompanyName=Antonio Moreno Taquería Phone=(5) 555-3932
ContactName=Thomas Hardy ContactTitle=Sales Representative Address=120 Hanover Sq. City=London Region=null PostalCode=WA1 1DP Country=UK Fax=(171) 555-6750 ContactID=4 ContactType=Customer CompanyName=Around the Horn Phone=(171) 555-7788
ContactName=Christina Berglund ContactTitle=Order Administrator Address=Berguvsvägen 8 City=Luleå Region=null PostalCode=S-958 22 Country=Sweden Fax=0921-12 34 67 ContactID=5 ContactType=Customer CompanyName=Berglunds snabbköp Phone=0921-12 34 65
ContactName=Hanna Moos ContactTitle=Sales Representative Address=Forsterstr. 57 City=Mannheim Region=null PostalCode=68306 Country=Germany Fax=0621-08924 ContactID=6 ContactType=Customer CompanyName=Blauer See Delikatessen Phone=0621-08460
ContactName=Frédérique Citeaux ContactTitle=Marketing Manager Address=24, place Kléber City=Strasbourg Region=null PostalCode=67000 Country=France Fax=88.60.15.32 ContactID=7 ContactType=Customer CompanyName=Blondesddsl père et fils Phone=88.60.15.31
ContactName=Martín Sommer ContactTitle=Owner Address=C/ Araquil, 67 City=Madrid Region=null PostalCode=28023 Country=Spain Fax=(91) 555 91 99 ContactID=8 ContactType=Customer CompanyName=Bólido Comidas preparadas Phone=(91) 555 22 82
ContactName=Laurence Lebihan ContactTitle=Owner Address=12, rue des Bouchers City=Marseille Region=null PostalCode=13008 Country=France Fax=91.24.45.41 ContactID=9 ContactType=Customer CompanyName=Bon app' Phone=91.24.45.40
ContactName=Elizabeth Lincoln ContactTitle=Accounting Manager Address=23 Tsawassen Blvd. City=Tsawassen Region=BC PostalCode=T2F 8M4 Country=Canada Fax=(604) 555-3745 ContactID=10 ContactType=Customer CompanyName=Bottom-Dollar Markets Phone=(604) 555-4729
ContactName=Victoria Ashworth ContactTitle=Sales Representative Address=Fauntleroy Circus City=London Region=null PostalCode=EC2 5NT Country=UK Fax=null ContactID=11 ContactType=Customer CompanyName=B's Beverages Phone=(171) 555-1212
ContactName=Patricio Simpson ContactTitle=Sales Agent Address=Cerrito 333 City=Buenos Aires Region=null PostalCode=1010 Country=Argentina Fax=(1) 135-4892 ContactID=12 ContactType=Customer CompanyName=Cactus Comidas para llevar Phone=(1) 135-5555
ContactName=Francisco Chang ContactTitle=Marketing Manager Address=Sierras de Granada 9993 City=México D.F. Region=null PostalCode=05022 Country=Mexico Fax=(5) 555-7293 ContactID=13 ContactType=Customer CompanyName=Centro comercial Moctezuma Phone=(5) 555-3392
ContactName=Yang Wang ContactTitle=Owner Address=Hauptstr. 29 City=Bern Region=null PostalCode=3012 Country=Switzerland Fax=null ContactID=14 ContactType=Customer CompanyName=Chop-suey Chinese Phone=0452-076545
ContactName=Pedro Afonso ContactTitle=Sales Associate Address=Av. dos Lusíadas, 23 City=Sao Paulo Region=SP PostalCode=05432-043 Country=Brazil Fax=null ContactID=15 ContactType=Customer CompanyName=Comércio Mineiro Phone=(11) 555-7647
ContactName=Elizabeth Brown ContactTitle=Sales Representative Address=Berkeley Gardens 12 Brewery City=London Region=null PostalCode=WX1 6LT Country=UK Fax=(171) 555-9199 ContactID=16 ContactType=Customer CompanyName=Consolidated Holdings Phone=(171) 555-2282
ContactName=Sven Ottlieb ContactTitle=Order Administrator Address=Walserweg 21 City=Aachen Region=null PostalCode=52066 Country=Germany Fax=0241-059428 ContactID=17 ContactType=Customer CompanyName=Drachenblut Delikatessen Phone=0241-039123
ContactName=Janine Labrune ContactTitle=Owner Address=67, rue des Cinquante Otages City=Nantes Region=null PostalCode=44000 Country=France Fax=40.67.89.89 ContactID=18 ContactType=Customer CompanyName=Du monde entier Phone=40.67.88.88
ContactName=Ann Devon ContactTitle=Sales Agent Address=35 King George City=London Region=null PostalCode=WX3 6FW Country=UK Fax=(171) 555-3373 ContactID=19 ContactType=Customer CompanyName=Eastern Connection Phone=(171) 555-0297
ContactName=Roland Mendel ContactTitle=Sales Manager Address=Kirchgasse 6 City=Graz Region=null PostalCode=8010 Country=Austria Fax=7675-3426 ContactID=20 ContactType=Customer CompanyName=Ernst Handel Phone=7675-3425
ContactName=Aria Cruz ContactTitle=Marketing Assistant Address=Rua Orós, 92 City=Sao Paulo Region=SP PostalCode=05442-030 Country=Brazil Fax=null ContactID=21 ContactType=Customer CompanyName=Familia Arquibaldo Phone=(11) 555-9857
ContactName=Diego Roel ContactTitle=Accounting Manager Address=C/ Moralzarzal, 86 City=Madrid Region=null PostalCode=28034 Country=Spain Fax=(91) 555 55 93 ContactID=22 ContactType=Customer CompanyName=FISSA Fabrica Inter. Salchichas S.A. Phone=(91) 555 94 44
ContactName=Martine Rancé ContactTitle=Assistant Sales Agent Address=184, chaussée de Tournai City=Lille Region=null PostalCode=59000 Country=France Fax=20.16.10.17 ContactID=23 ContactType=Customer CompanyName=Folies gourmandes Phone=20.16.10.16
ContactName=Maria Larsson ContactTitle=Owner Address=Åkergatan 24 City=Bräcke Region=null PostalCode=S-844 67 Country=Sweden Fax=null ContactID=24 ContactType=Customer CompanyName=Folk och fä HB Phone=0695-34 67 21
ContactName=Peter Franken ContactTitle=Marketing Manager Address=Berliner Platz 43 City=München Region=null PostalCode=80805 Country=Germany Fax=089-0877451 ContactID=25 ContactType=Customer CompanyName=Frankenversand Phone=089-0877310
ContactName=Carine Schmitt ContactTitle=Marketing Manager Address=54, rue Royale City=Nantes Region=null PostalCode=44000 Country=France Fax=40.32.21.20 ContactID=26 ContactType=Customer CompanyName=France restauration Phone=40.32.21.21
ContactName=Paolo Accorti ContactTitle=Sales Representative Address=Via Monte Bianco 34 City=Torino Region=null PostalCode=10100 Country=Italy Fax=011-4988261 ContactID=27 ContactType=Customer CompanyName=Franchi S.p.A. Phone=011-4988260
ContactName=Lino Rodriguez ContactTitle=Sales Manager Address=Jardim das rosas n. 32 City=Lisboa Region=null PostalCode=1675 Country=Portugal Fax=(1) 354-2535 ContactID=28 ContactType=Customer CompanyName=Furia Bacalhau e Frutos do Mar Phone=(1) 354-2534
ContactName=Eduardo Saavedra ContactTitle=Marketing Manager Address=Rambla de Cataluña, 23 City=Barcelona Region=null PostalCode=08022 Country=Spain Fax=(93) 203 4561 ContactID=29 ContactType=Customer CompanyName=Galería del gastrónomo Phone=(93) 203 4560
ContactName=José Pedro Freyre ContactTitle=Sales Manager Address=C/ Romero, 33 City=Sevilla Region=null PostalCode=41101 Country=Spain Fax=null ContactID=30 ContactType=Customer CompanyName=Godos Cocina Típica Phone=(95) 555 82 82
ContactName=André Fonseca ContactTitle=Sales Associate Address=Av. Brasil, 442 City=Campinas Region=SP PostalCode=04876-786 Country=Brazil Fax=null ContactID=31 ContactType=Customer CompanyName=Gourmet Lanchonetes Phone=(11) 555-9482
ContactName=Howard Snyder ContactTitle=Marketing Manager Address=2732 Baker Blvd. City=Eugene Region=OR PostalCode=97403 Country=USA Fax=null ContactID=32 ContactType=Customer CompanyName=Great Lakes Food Market Phone=(503) 555-7555
ContactName=Manuel Pereira ContactTitle=Owner Address=5ª Ave. Los Palos Grandes City=Caracas Region=DF PostalCode=1081 Country=Venezuela Fax=(2) 283-3397 ContactID=33 ContactType=Customer CompanyName=GROSELLA-Restaurante Phone=(2) 283-2951
ContactName=Mario Pontes ContactTitle=Accounting Manager Address=Rua do Paço, 67 City=Rio de Janeiro Region=RJ PostalCode=05454-876 Country=Brazil Fax=(21) 555-8765 ContactID=34 ContactType=Customer CompanyName=Hanari Carnes Phone=(21) 555-0091
ContactName=Carlos Hernández ContactTitle=Sales Representative Address=Carrera 22 con Ave. Carlos Soublette #8-35 City=San Cristóbal Region=Táchira PostalCode=5022 Country=Venezuela Fax=(5) 555-1948 ContactID=35 ContactType=Customer CompanyName=HILARION-Abastos Phone=(5) 555-1340
ContactName=Yoshi Latimer ContactTitle=Sales Representative Address=City Center Plaza 516 Main St. City=Elgin Region=OR PostalCode=97827 Country=USA Fax=(503) 555-2376 ContactID=36 ContactType=Customer CompanyName=Hungry Coyote Import Store Phone=(503) 555-6874
ContactName=Patricia McKenna ContactTitle=Sales Associate Address=8 Johnstown Road City=Cork Region=Co. Cork PostalCode=null Country=Ireland Fax=2967 3333 ContactID=37 ContactType=Customer CompanyName=Hungry Owl All-Night Grocers Phone=2967 542
ContactName=Helen Bennett ContactTitle=Marketing Manager Address=Garden House Crowther Way City=Cowes Region=Isle of Wight PostalCode=PO31 7PJ Country=UK Fax=null ContactID=38 ContactType=Customer CompanyName=Island Trading Phone=(198) 555-8888
ContactName=Philip Cramer ContactTitle=Sales Associate Address=Maubelstr. 90 City=Brandenburg Region=null PostalCode=14776 Country=Germany Fax=null ContactID=39 ContactType=Customer CompanyName=Königlich Essen Phone=0555-09876
ContactName=Daniel Tonini ContactTitle=Sales Representative Address=67, avenue de l'Europe City=Versailles Region=null PostalCode=78000 Country=France Fax=30.59.85.11 ContactID=40 ContactType=Customer CompanyName=La corne d'abondance Phone=30.59.84.10
ContactName=Annette Roulet ContactTitle=Sales Manager Address=1 rue Alsace-Lorraine City=Toulouse Region=null PostalCode=31000 Country=France Fax=61.77.61.11 ContactID=41 ContactType=Customer CompanyName=La maison d'Asie Phone=61.77.61.10
ContactName=Yoshi Tannamuri ContactTitle=Marketing Assistant Address=1900 Oak St. City=Vancouver Region=BC PostalCode=V3F 2K1 Country=Canada Fax=(604) 555-7293 ContactID=42 ContactType=Customer CompanyName=Laughing Bacchus Wine Cellars Phone=(604) 555-3392
ContactName=John Steel ContactTitle=Marketing Manager Address=12 Orchestra Terrace City=Walla Walla Region=WA PostalCode=99362 Country=USA Fax=(509) 555-6221 ContactID=43 ContactType=Customer CompanyName=Lazy K Kountry Store Phone=(509) 555-7969
ContactName=Renate Messner ContactTitle=Sales Representative Address=Magazinweg 7 City=Frankfurt a.M. Region=null PostalCode=60528 Country=Germany Fax=069-0245874 ContactID=44 ContactType=Customer CompanyName=Lehmanns Marktstand Phone=069-0245984
ContactName=Jaime Yorres ContactTitle=Owner Address=87 Polk St. Suite 5 City=San Francisco Region=CA PostalCode=94117 Country=USA Fax=null ContactID=45 ContactType=Customer CompanyName=Let's Stop N Shop Phone=(415) 555-5938
ContactName=Carlos González ContactTitle=Accounting Manager Address=Carrera 52 con Ave. Bolívar #65-98 Llano Largo City=Barquisimeto Region=Lara PostalCode=3508 Country=Venezuela Fax=(9) 331-7256 ContactID=46 ContactType=Customer CompanyName=LILA-Supermercado Phone=(9) 331-6954
ContactName=Felipe Izquierdo ContactTitle=Owner Address=Ave. 5 de Mayo Porlamar City=I. de Margarita Region=Nueva Esparta PostalCode=4980 Country=Venezuela Fax=(8) 34-93-93 ContactID=47 ContactType=Customer CompanyName=LINO-Delicateses Phone=(8) 34-56-12
ContactName=Fran Wilson ContactTitle=Sales Manager Address=89 Chiaroscuro Rd. City=Portland Region=OR PostalCode=97219 Country=USA Fax=(503) 555-9646 ContactID=48 ContactType=Customer CompanyName=Lonesome Pine Restaurant Phone=(503) 555-9573
ContactName=Giovanni Rovelli ContactTitle=Marketing Manager Address=Via Ludovico il Moro 22 City=Bergamo Region=null PostalCode=24100 Country=Italy Fax=035-640231 ContactID=49 ContactType=Customer CompanyName=Magazzini Alimentari Riuniti Phone=035-640230
ContactName=Catherine Dewey ContactTitle=Sales Agent Address=Rue Joseph-Bens 532 City=Bruxelles Region=null PostalCode=B-1180 Country=Belgium Fax=(02) 201 24 68 ContactID=50 ContactType=Customer CompanyName=Maison Dewey Phone=(02) 201 24 67
ContactName=Jean Fresnière ContactTitle=Marketing Assistant Address=43 rue St. Laurent City=Montréal Region=Québec PostalCode=H1J 1C3 Country=Canada Fax=(514) 555-8055 ContactID=51 ContactType=Customer CompanyName=Mère Paillarde Phone=(514) 555-8054
ContactName=Alexander Feuer ContactTitle=Marketing Assistant Address=Heerstr. 22 City=Leipzig Region=null PostalCode=04179 Country=Germany Fax=null ContactID=52 ContactType=Customer CompanyName=Morgenstern Gesundkost Phone=0342-023176
ContactName=Simon Crowther ContactTitle=Sales Associate Address=South House 300 Queensbridge City=London Region=null PostalCode=SW7 1RZ Country=UK Fax=(171) 555-2530 ContactID=53 ContactType=Customer CompanyName=North/South Phone=(171) 555-7733
ContactName=Yvonne Moncada ContactTitle=Sales Agent Address=Ing. Gustavo Moncada 8585 Piso 20-A City=Buenos Aires Region=null PostalCode=1010 Country=Argentina Fax=(1) 135-5535 ContactID=54 ContactType=Customer CompanyName=Océano Atlántico Ltda. Phone=(1) 135-5333
ContactName=Rene Phillips ContactTitle=Sales Representative Address=2743 Bering St. City=Anchorage Region=AK PostalCode=99508 Country=USA Fax=(907) 555-2880 ContactID=55 ContactType=Customer CompanyName=Old World Delicatessen Phone=(907) 555-7584
ContactName=Henriette Pfalzheim ContactTitle=Owner Address=Mehrheimerstr. 369 City=Köln Region=null PostalCode=50739 Country=Germany Fax=0221-0765721 ContactID=56 ContactType=Customer CompanyName=Ottilies Käseladen Phone=0221-0644327
ContactName=Marie Bertrand ContactTitle=Owner Address=265, boulevard Charonne City=Paris Region=null PostalCode=75012 Country=France Fax=(1) 42.34.22.77 ContactID=57 ContactType=Customer CompanyName=Paris spécialités Phone=(1) 42.34.22.66
ContactName=Guillermo Fernández ContactTitle=Sales Representative Address=Calle Dr. Jorge Cash 321 City=México D.F. Region=null PostalCode=05033 Country=Mexico Fax=(5) 545-3745 ContactID=58 ContactType=Customer CompanyName=Pericles Comidas clásicas Phone=(5) 552-3745
ContactName=Georg Pipps ContactTitle=Sales Manager Address=Geislweg 14 City=Salzburg Region=null PostalCode=5020 Country=Austria Fax=6562-9723 ContactID=59 ContactType=Customer CompanyName=Piccolo und mehr Phone=6562-9722
ContactName=Isabel de Castro ContactTitle=Sales Representative Address=Estrada da saúde n. 58 City=Lisboa Region=null PostalCode=1756 Country=Portugal Fax=null ContactID=60 ContactType=Customer CompanyName=Princesa Isabel Vinhos Phone=(1) 356-5634
ContactName=Bernardo Batista ContactTitle=Accounting Manager Address=Rua da Panificadora, 12 City=Rio de Janeiro Region=RJ PostalCode=02389-673 Country=Brazil Fax=(21) 555-4545 ContactID=61 ContactType=Customer CompanyName=Que Delícia Phone=(21) 555-4252
ContactName=Lúcia Carvalho ContactTitle=Marketing Assistant Address=Alameda dos Canàrios, 891 City=Sao Paulo Region=SP PostalCode=05487-020 Country=Brazil Fax=null ContactID=62 ContactType=Customer CompanyName=Queen Cozinha Phone=(11) 555-1189
ContactName=Horst Kloss ContactTitle=Accounting Manager Address=Taucherstraße 10 City=Cunewalde Region=null PostalCode=01307 Country=Germany Fax=null ContactID=63 ContactType=Customer CompanyName=QUICK-Stop Phone=0372-035188
ContactName=Sergio Gutiérrez ContactTitle=Sales Representative Address=Av. del Libertador 900 City=Buenos Aires Region=null PostalCode=1010 Country=Argentina Fax=(1) 123-5556 ContactID=64 ContactType=Customer CompanyName=Rancho grande Phone=(1) 123-5555
ContactName=Paula Wilson ContactTitle=Assistant Sales Representative Address=2817 Milton Dr. City=Albuquerque Region=NM PostalCode=87110 Country=USA Fax=(505) 555-3620 ContactID=65 ContactType=Customer CompanyName=Rattlesnake Canyon Grocery Phone=(505) 555-5939
ContactName=Maurizio Moroni ContactTitle=Sales Associate Address=Strada Provinciale 124 City=Reggio Emilia Region=null PostalCode=42100 Country=Italy Fax=0522-556722 ContactID=66 ContactType=Customer CompanyName=Reggiani Caseifici Phone=0522-556721
ContactName=Janete Limeira ContactTitle=Assistant Sales Agent Address=Av. Copacabana, 267 City=Rio de Janeiro Region=RJ PostalCode=02389-890 Country=Brazil Fax=null ContactID=67 ContactType=Customer CompanyName=Ricardo Adocicados Phone=(21) 555-3412
ContactName=Michael Holz ContactTitle=Sales Manager Address=Grenzacherweg 237 City=Genève Region=null PostalCode=1203 Country=Switzerland Fax=null ContactID=68 ContactType=Customer CompanyName=Richter Supermarkt Phone=0897-034214
ContactName=Alejandra Camino ContactTitle=Accounting Manager Address=Gran Vía, 1 City=Madrid Region=null PostalCode=28001 Country=Spain Fax=(91) 745 6210 ContactID=69 ContactType=Customer CompanyName=Romero y tomillo Phone=(91) 745 6200
ContactName=Jonas Bergulfsen ContactTitle=Owner Address=Erling Skakkes gate 78 City=Stavern Region=null PostalCode=4110 Country=Norway Fax=07-98 92 47 ContactID=70 ContactType=Customer CompanyName=Santé Gourmet Phone=07-98 92 35
ContactName=Jose Pavarotti ContactTitle=Sales Representative Address=187 Suffolk Ln. City=Boise Region=ID PostalCode=83720 Country=USA Fax=null ContactID=71 ContactType=Customer CompanyName=Save-a-lot Markets Phone=(208) 555-8097
ContactName=Hari Kumar ContactTitle=Sales Manager Address=90 Wadhurst Rd. City=London Region=null PostalCode=OX15 4NB Country=UK Fax=(171) 555-5646 ContactID=72 ContactType=Customer CompanyName=Seven Seas Imports Phone=(171) 555-1717
ContactName=Jytte Petersen ContactTitle=Owner Address=Vinbæltet 34 City=Kobenhavn Region=null PostalCode=1734 Country=Denmark Fax=31 13 35 57 ContactID=73 ContactType=Customer CompanyName=Simons bistro Phone=31 12 34 56
ContactName=Dominique Perrier ContactTitle=Marketing Manager Address=25, rue Lauriston City=Paris Region=null PostalCode=75016 Country=France Fax=(1) 47.55.60.20 ContactID=74 ContactType=Customer CompanyName=Spécialités du monde Phone=(1) 47.55.60.10
ContactName=Art Braunschweiger ContactTitle=Sales Manager Address=P.O. Box 555 City=Lander Region=WY PostalCode=82520 Country=USA Fax=(307) 555-6525 ContactID=75 ContactType=Customer CompanyName=Split Rail Beer & Ale Phone=(307) 555-4680
ContactName=Pascale Cartrain ContactTitle=Accounting Manager Address=Boulevard Tirou, 255 City=Charleroi Region=null PostalCode=B-6000 Country=Belgium Fax=(071) 23 67 22 21 ContactID=76 ContactType=Customer CompanyName=Suprêmes délices Phone=(071) 23 67 22 20
ContactName=Liz Nixon ContactTitle=Marketing Manager Address=89 Jefferson Way Suite 2 City=Portland Region=OR PostalCode=97201 Country=USA Fax=null ContactID=77 ContactType=Customer CompanyName=The Big Cheese Phone=(503) 555-3612
ContactName=Liu Wong ContactTitle=Marketing Assistant Address=55 Grizzly Peak Rd. City=Butte Region=MT PostalCode=59801 Country=USA Fax=(406) 555-8083 ContactID=78 ContactType=Customer CompanyName=The Cracker Box Phone=(406) 555-5834
ContactName=Karin Josephs ContactTitle=Marketing Manager Address=Luisenstr. 48 City=Münster Region=null PostalCode=44087 Country=Germany Fax=0251-035695 ContactID=79 ContactType=Customer CompanyName=Toms Spezialitäten Phone=0251-031259
ContactName=Miguel Angel Paolino ContactTitle=Owner Address=Avda. Azteca 123 City=México D.F. Region=null PostalCode=05033 Country=Mexico Fax=null ContactID=80 ContactType=Customer CompanyName=Tortuga Restaurante Phone=(5) 555-2933
ContactName=Anabela Domingues ContactTitle=Sales Representative Address=Av. Inês de Castro, 414 City=Sao Paulo Region=SP PostalCode=05634-030 Country=Brazil Fax=(11) 555-2168 ContactID=81 ContactType=Customer CompanyName=Tradição Hipermercados Phone=(11) 555-2167
ContactName=Helvetius Nagy ContactTitle=Sales Associate Address=722 DaVinci Blvd. City=Kirkland Region=WA PostalCode=98034 Country=USA Fax=(206) 555-2174 ContactID=82 ContactType=Customer CompanyName=Trail's Head Gourmet Provisioners Phone=(206) 555-8257
ContactName=Palle Ibsen ContactTitle=Sales Manager Address=Smagsloget 45 City=Århus Region=null PostalCode=8200 Country=Denmark Fax=86 22 33 44 ContactID=83 ContactType=Customer CompanyName=Vaffeljernet Phone=86 21 32 43
ContactName=Mary Saveley ContactTitle=Sales Agent Address=2, rue du Commerce City=Lyon Region=null PostalCode=69004 Country=France Fax=78.32.54.87 ContactID=84 ContactType=Customer CompanyName=Victuailles en stock Phone=78.32.54.86
ContactName=Paul Henriot ContactTitle=Accounting Manager Address=59 rue de l'Abbaye City=Reims Region=null PostalCode=51100 Country=France Fax=26.47.15.11 ContactID=85 ContactType=Customer CompanyName=Vins et alcools Chevalier Phone=26.47.15.10
ContactName=Rita Müller ContactTitle=Sales Representative Address=Adenauerallee 900 City=Stuttgart Region=null PostalCode=70563 Country=Germany Fax=0711-035428 ContactID=86 ContactType=Customer CompanyName=Die Wandernde Kuh Phone=0711-020361
ContactName=Pirkko Koskitalo ContactTitle=Accounting Manager Address=Torikatu 38 City=Oulu Region=null PostalCode=90110 Country=Finland Fax=981-443655 ContactID=87 ContactType=Customer CompanyName=Wartian Herkku Phone=981-443655
ContactName=Paula Parente ContactTitle=Sales Manager Address=Rua do Mercado, 12 City=Resende Region=SP PostalCode=08737-363 Country=Brazil Fax=null ContactID=88 ContactType=Customer CompanyName=Wellington Importadora Phone=(14) 555-8122
ContactName=Karl Jablonski ContactTitle=Owner Address=305 - 14th Ave. S. Suite 3B City=Seattle Region=WA PostalCode=98128 Country=USA Fax=(206) 555-4115 ContactID=89 ContactType=Customer CompanyName=White Clover Markets Phone=(206) 555-4112
ContactName=Matti Karttunen ContactTitle=Owner/Marketing Assistant Address=Keskuskatu 45 City=Helsinki Region=null PostalCode=21240 Country=Finland Fax=90-224 8858 ContactID=90 ContactType=Customer CompanyName=Wilman Kala Phone=90-224 8858
ContactName=Zbyszek Piestrzeniewicz ContactTitle=Owner Address=ul. Filtrowa 68 City=Warszawa Region=null PostalCode=01-012 Country=Poland Fax=(26) 642-7012 ContactID=91 ContactType=Customer CompanyName=Wolski Zajazd Phone=(26) 642-7012
This sample uses IS to return all shipper contacts.
Public Sub LinqToSqlInheritance03()
Dim cons = From c In newDB.Contacts _
Where TypeOf c Is ShipperContact _
Select c
ObjectDumper.Write(cons, 0)
End Sub
Result:
ContactID=130 ContactType=Shipper CompanyName=Speedy Express Phone=(503) 555-9831
ContactID=131 ContactType=Shipper CompanyName=United Package Phone=(503) 555-3199
ContactID=132 ContactType=Shipper CompanyName=Federal Shipping Phone=(503) 555-9931
This sample uses CType to return FullContact or null.
Public Sub LinqToSqlInheritance04()
Dim cons = From c In newDB.Contacts _
Select CType(c, FullContact)
ObjectDumper.Write(cons, 0)
End Sub
Result:
ContactName=Maria Anders ContactTitle=Sales Representative Address=Obere Str. 57 City=Berlin Region=null PostalCode=12209 Country=Germany Fax=030-0076545 ContactID=1 ContactType=Customer CompanyName=Alfreds Futterkiste Phone=030-0074321
ContactName=Ana Trujillo ContactTitle=Owner Address=Avda. de la Constitución 2222 City=México D.F. Region=null PostalCode=05021 Country=Mexico Fax=(5) 555-3745 ContactID=2 ContactType=Customer CompanyName=Ana Trujillo Emparedados y helados Phone=(5) 555-4729
ContactName=Antonio Moreno ContactTitle=Owner Address=Mataderos 2312 City=México D.F. Region=null PostalCode=05023 Country=Mexico Fax=null ContactID=3 ContactType=Customer CompanyName=Antonio Moreno Taquería Phone=(5) 555-3932
ContactName=Thomas Hardy ContactTitle=Sales Representative Address=120 Hanover Sq. City=London Region=null PostalCode=WA1 1DP Country=UK Fax=(171) 555-6750 ContactID=4 ContactType=Customer CompanyName=Around the Horn Phone=(171) 555-7788
ContactName=Christina Berglund ContactTitle=Order Administrator Address=Berguvsvägen 8 City=Luleå Region=null PostalCode=S-958 22 Country=Sweden Fax=0921-12 34 67 ContactID=5 ContactType=Customer CompanyName=Berglunds snabbköp Phone=0921-12 34 65
ContactName=Hanna Moos ContactTitle=Sales Representative Address=Forsterstr. 57 City=Mannheim Region=null PostalCode=68306 Country=Germany Fax=0621-08924 ContactID=6 ContactType=Customer CompanyName=Blauer See Delikatessen Phone=0621-08460
ContactName=Frédérique Citeaux ContactTitle=Marketing Manager Address=24, place Kléber City=Strasbourg Region=null PostalCode=67000 Country=France Fax=88.60.15.32 ContactID=7 ContactType=Customer CompanyName=Blondesddsl père et fils Phone=88.60.15.31
ContactName=Martín Sommer ContactTitle=Owner Address=C/ Araquil, 67 City=Madrid Region=null PostalCode=28023 Country=Spain Fax=(91) 555 91 99 ContactID=8 ContactType=Customer CompanyName=Bólido Comidas preparadas Phone=(91) 555 22 82
ContactName=Laurence Lebihan ContactTitle=Owner Address=12, rue des Bouchers City=Marseille Region=null PostalCode=13008 Country=France Fax=91.24.45.41 ContactID=9 ContactType=Customer CompanyName=Bon app' Phone=91.24.45.40
ContactName=Elizabeth Lincoln ContactTitle=Accounting Manager Address=23 Tsawassen Blvd. City=Tsawassen Region=BC PostalCode=T2F 8M4 Country=Canada Fax=(604) 555-3745 ContactID=10 ContactType=Customer CompanyName=Bottom-Dollar Markets Phone=(604) 555-4729
ContactName=Victoria Ashworth ContactTitle=Sales Representative Address=Fauntleroy Circus City=London Region=null PostalCode=EC2 5NT Country=UK Fax=null ContactID=11 ContactType=Customer CompanyName=B's Beverages Phone=(171) 555-1212
ContactName=Patricio Simpson ContactTitle=Sales Agent Address=Cerrito 333 City=Buenos Aires Region=null PostalCode=1010 Country=Argentina Fax=(1) 135-4892 ContactID=12 ContactType=Customer CompanyName=Cactus Comidas para llevar Phone=(1) 135-5555
ContactName=Francisco Chang ContactTitle=Marketing Manager Address=Sierras de Granada 9993 City=México D.F. Region=null PostalCode=05022 Country=Mexico Fax=(5) 555-7293 ContactID=13 ContactType=Customer CompanyName=Centro comercial Moctezuma Phone=(5) 555-3392
ContactName=Yang Wang ContactTitle=Owner Address=Hauptstr. 29 City=Bern Region=null PostalCode=3012 Country=Switzerland Fax=null ContactID=14 ContactType=Customer CompanyName=Chop-suey Chinese Phone=0452-076545
ContactName=Pedro Afonso ContactTitle=Sales Associate Address=Av. dos Lusíadas, 23 City=Sao Paulo Region=SP PostalCode=05432-043 Country=Brazil Fax=null ContactID=15 ContactType=Customer CompanyName=Comércio Mineiro Phone=(11) 555-7647
ContactName=Elizabeth Brown ContactTitle=Sales Representative Address=Berkeley Gardens 12 Brewery City=London Region=null PostalCode=WX1 6LT Country=UK Fax=(171) 555-9199 ContactID=16 ContactType=Customer CompanyName=Consolidated Holdings Phone=(171) 555-2282
ContactName=Sven Ottlieb ContactTitle=Order Administrator Address=Walserweg 21 City=Aachen Region=null PostalCode=52066 Country=Germany Fax=0241-059428 ContactID=17 ContactType=Customer CompanyName=Drachenblut Delikatessen Phone=0241-039123
ContactName=Janine Labrune ContactTitle=Owner Address=67, rue des Cinquante Otages City=Nantes Region=null PostalCode=44000 Country=France Fax=40.67.89.89 ContactID=18 ContactType=Customer CompanyName=Du monde entier Phone=40.67.88.88
ContactName=Ann Devon ContactTitle=Sales Agent Address=35 King George City=London Region=null PostalCode=WX3 6FW Country=UK Fax=(171) 555-3373 ContactID=19 ContactType=Customer CompanyName=Eastern Connection Phone=(171) 555-0297
ContactName=Roland Mendel ContactTitle=Sales Manager Address=Kirchgasse 6 City=Graz Region=null PostalCode=8010 Country=Austria Fax=7675-3426 ContactID=20 ContactType=Customer CompanyName=Ernst Handel Phone=7675-3425
ContactName=Aria Cruz ContactTitle=Marketing Assistant Address=Rua Orós, 92 City=Sao Paulo Region=SP PostalCode=05442-030 Country=Brazil Fax=null ContactID=21 ContactType=Customer CompanyName=Familia Arquibaldo Phone=(11) 555-9857
ContactName=Diego Roel ContactTitle=Accounting Manager Address=C/ Moralzarzal, 86 City=Madrid Region=null PostalCode=28034 Country=Spain Fax=(91) 555 55 93 ContactID=22 ContactType=Customer CompanyName=FISSA Fabrica Inter. Salchichas S.A. Phone=(91) 555 94 44
ContactName=Martine Rancé ContactTitle=Assistant Sales Agent Address=184, chaussée de Tournai City=Lille Region=null PostalCode=59000 Country=France Fax=20.16.10.17 ContactID=23 ContactType=Customer CompanyName=Folies gourmandes Phone=20.16.10.16
ContactName=Maria Larsson ContactTitle=Owner Address=Åkergatan 24 City=Bräcke Region=null PostalCode=S-844 67 Country=Sweden Fax=null ContactID=24 ContactType=Customer CompanyName=Folk och fä HB Phone=0695-34 67 21
ContactName=Peter Franken ContactTitle=Marketing Manager Address=Berliner Platz 43 City=München Region=null PostalCode=80805 Country=Germany Fax=089-0877451 ContactID=25 ContactType=Customer CompanyName=Frankenversand Phone=089-0877310
ContactName=Carine Schmitt ContactTitle=Marketing Manager Address=54, rue Royale City=Nantes Region=null PostalCode=44000 Country=France Fax=40.32.21.20 ContactID=26 ContactType=Customer CompanyName=France restauration Phone=40.32.21.21
ContactName=Paolo Accorti ContactTitle=Sales Representative Address=Via Monte Bianco 34 City=Torino Region=null PostalCode=10100 Country=Italy Fax=011-4988261 ContactID=27 ContactType=Customer CompanyName=Franchi S.p.A. Phone=011-4988260
ContactName=Lino Rodriguez ContactTitle=Sales Manager Address=Jardim das rosas n. 32 City=Lisboa Region=null PostalCode=1675 Country=Portugal Fax=(1) 354-2535 ContactID=28 ContactType=Customer CompanyName=Furia Bacalhau e Frutos do Mar Phone=(1) 354-2534
ContactName=Eduardo Saavedra ContactTitle=Marketing Manager Address=Rambla de Cataluña, 23 City=Barcelona Region=null PostalCode=08022 Country=Spain Fax=(93) 203 4561 ContactID=29 ContactType=Customer CompanyName=Galería del gastrónomo Phone=(93) 203 4560
ContactName=José Pedro Freyre ContactTitle=Sales Manager Address=C/ Romero, 33 City=Sevilla Region=null PostalCode=41101 Country=Spain Fax=null ContactID=30 ContactType=Customer CompanyName=Godos Cocina Típica Phone=(95) 555 82 82
ContactName=André Fonseca ContactTitle=Sales Associate Address=Av. Brasil, 442 City=Campinas Region=SP PostalCode=04876-786 Country=Brazil Fax=null ContactID=31 ContactType=Customer CompanyName=Gourmet Lanchonetes Phone=(11) 555-9482
ContactName=Howard Snyder ContactTitle=Marketing Manager Address=2732 Baker Blvd. City=Eugene Region=OR PostalCode=97403 Country=USA Fax=null ContactID=32 ContactType=Customer CompanyName=Great Lakes Food Market Phone=(503) 555-7555
ContactName=Manuel Pereira ContactTitle=Owner Address=5ª Ave. Los Palos Grandes City=Caracas Region=DF PostalCode=1081 Country=Venezuela Fax=(2) 283-3397 ContactID=33 ContactType=Customer CompanyName=GROSELLA-Restaurante Phone=(2) 283-2951
ContactName=Mario Pontes ContactTitle=Accounting Manager Address=Rua do Paço, 67 City=Rio de Janeiro Region=RJ PostalCode=05454-876 Country=Brazil Fax=(21) 555-8765 ContactID=34 ContactType=Customer CompanyName=Hanari Carnes Phone=(21) 555-0091
ContactName=Carlos Hernández ContactTitle=Sales Representative Address=Carrera 22 con Ave. Carlos Soublette #8-35 City=San Cristóbal Region=Táchira PostalCode=5022 Country=Venezuela Fax=(5) 555-1948 ContactID=35 ContactType=Customer CompanyName=HILARION-Abastos Phone=(5) 555-1340
ContactName=Yoshi Latimer ContactTitle=Sales Representative Address=City Center Plaza 516 Main St. City=Elgin Region=OR PostalCode=97827 Country=USA Fax=(503) 555-2376 ContactID=36 ContactType=Customer CompanyName=Hungry Coyote Import Store Phone=(503) 555-6874
ContactName=Patricia McKenna ContactTitle=Sales Associate Address=8 Johnstown Road City=Cork Region=Co. Cork PostalCode=null Country=Ireland Fax=2967 3333 ContactID=37 ContactType=Customer CompanyName=Hungry Owl All-Night Grocers Phone=2967 542
ContactName=Helen Bennett ContactTitle=Marketing Manager Address=Garden House Crowther Way City=Cowes Region=Isle of Wight PostalCode=PO31 7PJ Country=UK Fax=null ContactID=38 ContactType=Customer CompanyName=Island Trading Phone=(198) 555-8888
ContactName=Philip Cramer ContactTitle=Sales Associate Address=Maubelstr. 90 City=Brandenburg Region=null PostalCode=14776 Country=Germany Fax=null ContactID=39 ContactType=Customer CompanyName=Königlich Essen Phone=0555-09876
ContactName=Daniel Tonini ContactTitle=Sales Representative Address=67, avenue de l'Europe City=Versailles Region=null PostalCode=78000 Country=France Fax=30.59.85.11 ContactID=40 ContactType=Customer CompanyName=La corne d'abondance Phone=30.59.84.10
ContactName=Annette Roulet ContactTitle=Sales Manager Address=1 rue Alsace-Lorraine City=Toulouse Region=null PostalCode=31000 Country=France Fax=61.77.61.11 ContactID=41 ContactType=Customer CompanyName=La maison d'Asie Phone=61.77.61.10
ContactName=Yoshi Tannamuri ContactTitle=Marketing Assistant Address=1900 Oak St. City=Vancouver Region=BC PostalCode=V3F 2K1 Country=Canada Fax=(604) 555-7293 ContactID=42 ContactType=Customer CompanyName=Laughing Bacchus Wine Cellars Phone=(604) 555-3392
ContactName=John Steel ContactTitle=Marketing Manager Address=12 Orchestra Terrace City=Walla Walla Region=WA PostalCode=99362 Country=USA Fax=(509) 555-6221 ContactID=43 ContactType=Customer CompanyName=Lazy K Kountry Store Phone=(509) 555-7969
ContactName=Renate Messner ContactTitle=Sales Representative Address=Magazinweg 7 City=Frankfurt a.M. Region=null PostalCode=60528 Country=Germany Fax=069-0245874 ContactID=44 ContactType=Customer CompanyName=Lehmanns Marktstand Phone=069-0245984
ContactName=Jaime Yorres ContactTitle=Owner Address=87 Polk St. Suite 5 City=San Francisco Region=CA PostalCode=94117 Country=USA Fax=null ContactID=45 ContactType=Customer CompanyName=Let's Stop N Shop Phone=(415) 555-5938
ContactName=Carlos González ContactTitle=Accounting Manager Address=Carrera 52 con Ave. Bolívar #65-98 Llano Largo City=Barquisimeto Region=Lara PostalCode=3508 Country=Venezuela Fax=(9) 331-7256 ContactID=46 ContactType=Customer CompanyName=LILA-Supermercado Phone=(9) 331-6954
ContactName=Felipe Izquierdo ContactTitle=Owner Address=Ave. 5 de Mayo Porlamar City=I. de Margarita Region=Nueva Esparta PostalCode=4980 Country=Venezuela Fax=(8) 34-93-93 ContactID=47 ContactType=Customer CompanyName=LINO-Delicateses Phone=(8) 34-56-12
ContactName=Fran Wilson ContactTitle=Sales Manager Address=89 Chiaroscuro Rd. City=Portland Region=OR PostalCode=97219 Country=USA Fax=(503) 555-9646 ContactID=48 ContactType=Customer CompanyName=Lonesome Pine Restaurant Phone=(503) 555-9573
ContactName=Giovanni Rovelli ContactTitle=Marketing Manager Address=Via Ludovico il Moro 22 City=Bergamo Region=null PostalCode=24100 Country=Italy Fax=035-640231 ContactID=49 ContactType=Customer CompanyName=Magazzini Alimentari Riuniti Phone=035-640230
ContactName=Catherine Dewey ContactTitle=Sales Agent Address=Rue Joseph-Bens 532 City=Bruxelles Region=null PostalCode=B-1180 Country=Belgium Fax=(02) 201 24 68 ContactID=50 ContactType=Customer CompanyName=Maison Dewey Phone=(02) 201 24 67
ContactName=Jean Fresnière ContactTitle=Marketing Assistant Address=43 rue St. Laurent City=Montréal Region=Québec PostalCode=H1J 1C3 Country=Canada Fax=(514) 555-8055 ContactID=51 ContactType=Customer CompanyName=Mère Paillarde Phone=(514) 555-8054
ContactName=Alexander Feuer ContactTitle=Marketing Assistant Address=Heerstr. 22 City=Leipzig Region=null PostalCode=04179 Country=Germany Fax=null ContactID=52 ContactType=Customer CompanyName=Morgenstern Gesundkost Phone=0342-023176
ContactName=Simon Crowther ContactTitle=Sales Associate Address=South House 300 Queensbridge City=London Region=null PostalCode=SW7 1RZ Country=UK Fax=(171) 555-2530 ContactID=53 ContactType=Customer CompanyName=North/South Phone=(171) 555-7733
ContactName=Yvonne Moncada ContactTitle=Sales Agent Address=Ing. Gustavo Moncada 8585 Piso 20-A City=Buenos Aires Region=null PostalCode=1010 Country=Argentina Fax=(1) 135-5535 ContactID=54 ContactType=Customer CompanyName=Océano Atlántico Ltda. Phone=(1) 135-5333
ContactName=Rene Phillips ContactTitle=Sales Representative Address=2743 Bering St. City=Anchorage Region=AK PostalCode=99508 Country=USA Fax=(907) 555-2880 ContactID=55 ContactType=Customer CompanyName=Old World Delicatessen Phone=(907) 555-7584
ContactName=Henriette Pfalzheim ContactTitle=Owner Address=Mehrheimerstr. 369 City=Köln Region=null PostalCode=50739 Country=Germany Fax=0221-0765721 ContactID=56 ContactType=Customer CompanyName=Ottilies Käseladen Phone=0221-0644327
ContactName=Marie Bertrand ContactTitle=Owner Address=265, boulevard Charonne City=Paris Region=null PostalCode=75012 Country=France Fax=(1) 42.34.22.77 ContactID=57 ContactType=Customer CompanyName=Paris spécialités Phone=(1) 42.34.22.66
ContactName=Guillermo Fernández ContactTitle=Sales Representative Address=Calle Dr. Jorge Cash 321 City=México D.F. Region=null PostalCode=05033 Country=Mexico Fax=(5) 545-3745 ContactID=58 ContactType=Customer CompanyName=Pericles Comidas clásicas Phone=(5) 552-3745
ContactName=Georg Pipps ContactTitle=Sales Manager Address=Geislweg 14 City=Salzburg Region=null PostalCode=5020 Country=Austria Fax=6562-9723 ContactID=59 ContactType=Customer CompanyName=Piccolo und mehr Phone=6562-9722
ContactName=Isabel de Castro ContactTitle=Sales Representative Address=Estrada da saúde n. 58 City=Lisboa Region=null PostalCode=1756 Country=Portugal Fax=null ContactID=60 ContactType=Customer CompanyName=Princesa Isabel Vinhos Phone=(1) 356-5634
ContactName=Bernardo Batista ContactTitle=Accounting Manager Address=Rua da Panificadora, 12 City=Rio de Janeiro Region=RJ PostalCode=02389-673 Country=Brazil Fax=(21) 555-4545 ContactID=61 ContactType=Customer CompanyName=Que Delícia Phone=(21) 555-4252
ContactName=Lúcia Carvalho ContactTitle=Marketing Assistant Address=Alameda dos Canàrios, 891 City=Sao Paulo Region=SP PostalCode=05487-020 Country=Brazil Fax=null ContactID=62 ContactType=Customer CompanyName=Queen Cozinha Phone=(11) 555-1189
ContactName=Horst Kloss ContactTitle=Accounting Manager Address=Taucherstraße 10 City=Cunewalde Region=null PostalCode=01307 Country=Germany Fax=null ContactID=63 ContactType=Customer CompanyName=QUICK-Stop Phone=0372-035188
ContactName=Sergio Gutiérrez ContactTitle=Sales Representative Address=Av. del Libertador 900 City=Buenos Aires Region=null PostalCode=1010 Country=Argentina Fax=(1) 123-5556 ContactID=64 ContactType=Customer CompanyName=Rancho grande Phone=(1) 123-5555
ContactName=Paula Wilson ContactTitle=Assistant Sales Representative Address=2817 Milton Dr. City=Albuquerque Region=NM PostalCode=87110 Country=USA Fax=(505) 555-3620 ContactID=65 ContactType=Customer CompanyName=Rattlesnake Canyon Grocery Phone=(505) 555-5939
ContactName=Maurizio Moroni ContactTitle=Sales Associate Address=Strada Provinciale 124 City=Reggio Emilia Region=null PostalCode=42100 Country=Italy Fax=0522-556722 ContactID=66 ContactType=Customer CompanyName=Reggiani Caseifici Phone=0522-556721
ContactName=Janete Limeira ContactTitle=Assistant Sales Agent Address=Av. Copacabana, 267 City=Rio de Janeiro Region=RJ PostalCode=02389-890 Country=Brazil Fax=null ContactID=67 ContactType=Customer CompanyName=Ricardo Adocicados Phone=(21) 555-3412
ContactName=Michael Holz ContactTitle=Sales Manager Address=Grenzacherweg 237 City=Genève Region=null PostalCode=1203 Country=Switzerland Fax=null ContactID=68 ContactType=Customer CompanyName=Richter Supermarkt Phone=0897-034214
ContactName=Alejandra Camino ContactTitle=Accounting Manager Address=Gran Vía, 1 City=Madrid Region=null PostalCode=28001 Country=Spain Fax=(91) 745 6210 ContactID=69 ContactType=Customer CompanyName=Romero y tomillo Phone=(91) 745 6200
ContactName=Jonas Bergulfsen ContactTitle=Owner Address=Erling Skakkes gate 78 City=Stavern Region=null PostalCode=4110 Country=Norway Fax=07-98 92 47 ContactID=70 ContactType=Customer CompanyName=Santé Gourmet Phone=07-98 92 35
ContactName=Jose Pavarotti ContactTitle=Sales Representative Address=187 Suffolk Ln. City=Boise Region=ID PostalCode=83720 Country=USA Fax=null ContactID=71 ContactType=Customer CompanyName=Save-a-lot Markets Phone=(208) 555-8097
ContactName=Hari Kumar ContactTitle=Sales Manager Address=90 Wadhurst Rd. City=London Region=null PostalCode=OX15 4NB Country=UK Fax=(171) 555-5646 ContactID=72 ContactType=Customer CompanyName=Seven Seas Imports Phone=(171) 555-1717
ContactName=Jytte Petersen ContactTitle=Owner Address=Vinbæltet 34 City=Kobenhavn Region=null PostalCode=1734 Country=Denmark Fax=31 13 35 57 ContactID=73 ContactType=Customer CompanyName=Simons bistro Phone=31 12 34 56
ContactName=Dominique Perrier ContactTitle=Marketing Manager Address=25, rue Lauriston City=Paris Region=null PostalCode=75016 Country=France Fax=(1) 47.55.60.20 ContactID=74 ContactType=Customer CompanyName=Spécialités du monde Phone=(1) 47.55.60.10
ContactName=Art Braunschweiger ContactTitle=Sales Manager Address=P.O. Box 555 City=Lander Region=WY PostalCode=82520 Country=USA Fax=(307) 555-6525 ContactID=75 ContactType=Customer CompanyName=Split Rail Beer & Ale Phone=(307) 555-4680
ContactName=Pascale Cartrain ContactTitle=Accounting Manager Address=Boulevard Tirou, 255 City=Charleroi Region=null PostalCode=B-6000 Country=Belgium Fax=(071) 23 67 22 21 ContactID=76 ContactType=Customer CompanyName=Suprêmes délices Phone=(071) 23 67 22 20
ContactName=Liz Nixon ContactTitle=Marketing Manager Address=89 Jefferson Way Suite 2 City=Portland Region=OR PostalCode=97201 Country=USA Fax=null ContactID=77 ContactType=Customer CompanyName=The Big Cheese Phone=(503) 555-3612
ContactName=Liu Wong ContactTitle=Marketing Assistant Address=55 Grizzly Peak Rd. City=Butte Region=MT PostalCode=59801 Country=USA Fax=(406) 555-8083 ContactID=78 ContactType=Customer CompanyName=The Cracker Box Phone=(406) 555-5834
ContactName=Karin Josephs ContactTitle=Marketing Manager Address=Luisenstr. 48 City=Münster Region=null PostalCode=44087 Country=Germany Fax=0251-035695 ContactID=79 ContactType=Customer CompanyName=Toms Spezialitäten Phone=0251-031259
ContactName=Miguel Angel Paolino ContactTitle=Owner Address=Avda. Azteca 123 City=México D.F. Region=null PostalCode=05033 Country=Mexico Fax=null ContactID=80 ContactType=Customer CompanyName=Tortuga Restaurante Phone=(5) 555-2933
ContactName=Anabela Domingues ContactTitle=Sales Representative Address=Av. Inês de Castro, 414 City=Sao Paulo Region=SP PostalCode=05634-030 Country=Brazil Fax=(11) 555-2168 ContactID=81 ContactType=Customer CompanyName=Tradição Hipermercados Phone=(11) 555-2167
ContactName=Helvetius Nagy ContactTitle=Sales Associate Address=722 DaVinci Blvd. City=Kirkland Region=WA PostalCode=98034 Country=USA Fax=(206) 555-2174 ContactID=82 ContactType=Customer CompanyName=Trail's Head Gourmet Provisioners Phone=(206) 555-8257
ContactName=Palle Ibsen ContactTitle=Sales Manager Address=Smagsloget 45 City=Århus Region=null PostalCode=8200 Country=Denmark Fax=86 22 33 44 ContactID=83 ContactType=Customer CompanyName=Vaffeljernet Phone=86 21 32 43
ContactName=Mary Saveley ContactTitle=Sales Agent Address=2, rue du Commerce City=Lyon Region=null PostalCode=69004 Country=France Fax=78.32.54.87 ContactID=84 ContactType=Customer CompanyName=Victuailles en stock Phone=78.32.54.86
ContactName=Paul Henriot ContactTitle=Accounting Manager Address=59 rue de l'Abbaye City=Reims Region=null PostalCode=51100 Country=France Fax=26.47.15.11 ContactID=85 ContactType=Customer CompanyName=Vins et alcools Chevalier Phone=26.47.15.10
ContactName=Rita Müller ContactTitle=Sales Representative Address=Adenauerallee 900 City=Stuttgart Region=null PostalCode=70563 Country=Germany Fax=0711-035428 ContactID=86 ContactType=Customer CompanyName=Die Wandernde Kuh Phone=0711-020361
ContactName=Pirkko Koskitalo ContactTitle=Accounting Manager Address=Torikatu 38 City=Oulu Region=null PostalCode=90110 Country=Finland Fax=981-443655 ContactID=87 ContactType=Customer CompanyName=Wartian Herkku Phone=981-443655
ContactName=Paula Parente ContactTitle=Sales Manager Address=Rua do Mercado, 12 City=Resende Region=SP PostalCode=08737-363 Country=Brazil Fax=null ContactID=88 ContactType=Customer CompanyName=Wellington Importadora Phone=(14) 555-8122
ContactName=Karl Jablonski ContactTitle=Owner Address=305 - 14th Ave. S. Suite 3B City=Seattle Region=WA PostalCode=98128 Country=USA Fax=(206) 555-4115 ContactID=89 ContactType=Customer CompanyName=White Clover Markets Phone=(206) 555-4112
ContactName=Matti Karttunen ContactTitle=Owner/Marketing Assistant Address=Keskuskatu 45 City=Helsinki Region=null PostalCode=21240 Country=Finland Fax=90-224 8858 ContactID=90 ContactType=Customer CompanyName=Wilman Kala Phone=90-224 8858
ContactName=Zbyszek Piestrzeniewicz ContactTitle=Owner Address=ul. Filtrowa 68 City=Warszawa Region=null PostalCode=01-012 Country=Poland Fax=(26) 642-7012 ContactID=91 ContactType=Customer CompanyName=Wolski Zajazd Phone=(26) 642-7012
HomePage=null ContactName=Charlotte Cooper ContactTitle=Purchasing Manager Address=49 Gilbert St. City=London Region=null PostalCode=EC1 4SD Country=UK Fax=null ContactID=92 ContactType=Supplier CompanyName=Exotic Liquids Phone=(171) 555-2222
HomePage=#CAJUN.HTM# ContactName=Shelley Burke ContactTitle=Order Administrator Address=P.O. Box 78934 City=New Orleans Region=LA PostalCode=70117 Country=USA Fax=null ContactID=93 ContactType=Supplier CompanyName=New Orleans Cajun Delights Phone=(100) 555-4822
HomePage=null ContactName=Regina Murphy ContactTitle=Sales Representative Address=707 Oxford Rd. City=Ann Arbor Region=MI PostalCode=48104 Country=USA Fax=(313) 555-3349 ContactID=94 ContactType=Supplier CompanyName=Grandma Kelly's Homestead Phone=(313) 555-5735
HomePage=null ContactName=Yoshi Nagase ContactTitle=Marketing Manager Address=9-8 Sekimai Musashino-shi City=Tokyo Region=null PostalCode=100 Country=Japan Fax=null ContactID=95 ContactType=Supplier CompanyName=Tokyo Traders Phone=(03) 3555-5011
HomePage=null ContactName=Antonio del Valle Saavedra ContactTitle=Export Administrator Address=Calle del Rosal 4 City=Oviedo Region=Asturias PostalCode=33007 Country=Spain Fax=null ContactID=96 ContactType=Supplier CompanyName=Cooperativa de Quesos 'Las Cabras' Phone=(98) 598 76 54
HomePage=Mayumi's (on the World Wide Web)#http://www.microsoft.com/accessdev/sampleapps/mayumi.htm# ContactName=Mayumi Ohno ContactTitle=Marketing Representative Address=92 Setsuko Chuo-ku City=Osaka Region=null PostalCode=545 Country=Japan Fax=null ContactID=97 ContactType=Supplier CompanyName=Mayumi's Phone=(06) 431-7877
HomePage=null ContactName=Ian Devling ContactTitle=Marketing Manager Address=74 Rose St. Moonie Ponds City=Melbourne Region=Victoria PostalCode=3058 Country=Australia Fax=(03) 444-6588 ContactID=98 ContactType=Supplier CompanyName=Pavlova, Ltd. Phone=(03) 444-2343
HomePage=null ContactName=Peter Wilson ContactTitle=Sales Representative Address=29 King's Way City=Manchester Region=null PostalCode=M14 GSD Country=UK Fax=null ContactID=99 ContactType=Supplier CompanyName=Specialty Biscuits, Ltd. Phone=(161) 555-4448
HomePage=null ContactName=Lars Peterson ContactTitle=Sales Agent Address=Kaloadagatan 13 City=Göteborg Region=null PostalCode=S-345 67 Country=Sweden Fax=031-987 65 91 ContactID=100 ContactType=Supplier CompanyName=PB Knäckebröd AB Phone=031-987 65 43
HomePage=null ContactName=Carlos Diaz ContactTitle=Marketing Manager Address=Av. das Americanas 12.890 City=Sao Paulo Region=null PostalCode=5442 Country=Brazil Fax=null ContactID=101 ContactType=Supplier CompanyName=Refrescos Americanas LTDA Phone=(11) 555 4640
HomePage=null ContactName=Petra Winkler ContactTitle=Sales Manager Address=Tiergartenstraße 5 City=Berlin Region=null PostalCode=10785 Country=Germany Fax=null ContactID=102 ContactType=Supplier CompanyName=Heli Süßwaren GmbH & Co. KG Phone=(010) 9984510
HomePage=Plutzer (on the World Wide Web)#http://www.microsoft.com/accessdev/sampleapps/plutzer.htm# ContactName=Martin Bein ContactTitle=International Marketing Mgr. Address=Bogenallee 51 City=Frankfurt Region=null PostalCode=60439 Country=Germany Fax=null ContactID=103 ContactType=Supplier CompanyName=Plutzer Lebensmittelgroßmärkte AG Phone=(069) 992755
HomePage=null ContactName=Sven Petersen ContactTitle=Coordinator Foreign Markets Address=Frahmredder 112a City=Cuxhaven Region=null PostalCode=27478 Country=Germany Fax=(04721) 8714 ContactID=104 ContactType=Supplier CompanyName=Nord-Ost-Fisch Handelsgesellschaft mbH Phone=(04721) 8713
HomePage=#FORMAGGI.HTM# ContactName=Elio Rossi ContactTitle=Sales Representative Address=Viale Dante, 75 City=Ravenna Region=null PostalCode=48100 Country=Italy Fax=(0544) 60603 ContactID=105 ContactType=Supplier CompanyName=Formaggi Fortini s.r.l. Phone=(0544) 60323
HomePage=null ContactName=Beate Vileid ContactTitle=Marketing Manager Address=Hatlevegen 5 City=Sandvika Region=null PostalCode=1320 Country=Norway Fax=null ContactID=106 ContactType=Supplier CompanyName=Norske Meierier Phone=(0)2-953010
HomePage=null ContactName=Cheryl Saylor ContactTitle=Regional Account Rep. Address=3400 - 8th Avenue Suite 210 City=Bend Region=OR PostalCode=97101 Country=USA Fax=null ContactID=107 ContactType=Supplier CompanyName=Bigfoot Breweries Phone=(503) 555-9931
HomePage=null ContactName=Michael Björn ContactTitle=Sales Representative Address=Brovallavägen 231 City=Stockholm Region=null PostalCode=S-123 45 Country=Sweden Fax=null ContactID=108 ContactType=Supplier CompanyName=Svensk Sjöföda AB Phone=08-123 45 67
HomePage=null ContactName=Guylène Nodier ContactTitle=Sales Manager Address=203, Rue des Francs-Bourgeois City=Paris Region=null PostalCode=75004 Country=France Fax=(1) 03.83.00.62 ContactID=109 ContactType=Supplier CompanyName=Aux joyeux ecclésiastiques Phone=(1) 03.83.00.68
HomePage=null ContactName=Robb Merchant ContactTitle=Wholesale Account Agent Address=Order Processing Dept. 2100 Paul Revere Blvd. City=Boston Region=MA PostalCode=02134 Country=USA Fax=(617) 555-3389 ContactID=110 ContactType=Supplier CompanyName=New England Seafood Cannery Phone=(617) 555-3267
HomePage=null ContactName=Chandra Leka ContactTitle=Owner Address=471 Serangoon Loop, Suite #402 City=Singapore Region=null PostalCode=0512 Country=Singapore Fax=null ContactID=111 ContactType=Supplier CompanyName=Leka Trading Phone=555-8787
HomePage=null ContactName=Niels Petersen ContactTitle=Sales Manager Address=Lyngbysild Fiskebakken 10 City=Lyngby Region=null PostalCode=2800 Country=Denmark Fax=43844115 ContactID=112 ContactType=Supplier CompanyName=Lyngbysild Phone=43844108
HomePage=null ContactName=Dirk Luchte ContactTitle=Accounting Manager Address=Verkoop Rijnweg 22 City=Zaandam Region=null PostalCode=9999 ZZ Country=Netherlands Fax=(12345) 1210 ContactID=113 ContactType=Supplier CompanyName=Zaanse Snoepfabriek Phone=(12345) 1212
HomePage=null ContactName=Anne Heikkonen ContactTitle=Product Manager Address=Valtakatu 12 City=Lappeenranta Region=null PostalCode=53120 Country=Finland Fax=null ContactID=114 ContactType=Supplier CompanyName=Karkki Oy Phone=(953) 10956
HomePage=G'day Mate (on the World Wide Web)#http://www.microsoft.com/accessdev/sampleapps/gdaymate.htm# ContactName=Wendy Mackenzie ContactTitle=Sales Representative Address=170 Prince Edward Parade Hunter's Hill City=Sydney Region=NSW PostalCode=2042 Country=Australia Fax=(02) 555-4873 ContactID=115 ContactType=Supplier CompanyName=G'day, Mate Phone=(02) 555-5914
HomePage=null ContactName=Jean-Guy Lauzon ContactTitle=Marketing Manager Address=2960 Rue St. Laurent City=Montréal Region=Québec PostalCode=H1J 1C3 Country=Canada Fax=null ContactID=116 ContactType=Supplier CompanyName=Ma Maison Phone=(514) 555-9022
HomePage=null ContactName=Giovanni Giudici ContactTitle=Order Administrator Address=Via dei Gelsomini, 153 City=Salerno Region=null PostalCode=84100 Country=Italy Fax=(089) 6547667 ContactID=117 ContactType=Supplier CompanyName=Pasta Buttini s.r.l. Phone=(089) 6547665
HomePage=null ContactName=Marie Delamare ContactTitle=Sales Manager Address=22, rue H. Voiron City=Montceau Region=null PostalCode=71300 Country=France Fax=null ContactID=118 ContactType=Supplier CompanyName=Escargots Nouveaux Phone=85.57.00.07
HomePage=null ContactName=Eliane Noz ContactTitle=Sales Representative Address=Bat. B 3, rue des Alpes City=Annecy Region=null PostalCode=74000 Country=France Fax=38.76.98.58 ContactID=119 ContactType=Supplier CompanyName=Gai pâturage Phone=38.76.98.06
HomePage=null ContactName=Chantal Goulet ContactTitle=Accounting Manager Address=148 rue Chasseur City=Ste-Hyacinthe Region=Québec PostalCode=J2S 7S8 Country=Canada Fax=(514) 555-2921 ContactID=120 ContactType=Supplier CompanyName=Forêts d'érables Phone=(514) 555-2955
Extension=5467 PhotoPath=http://accweb/emmployees/davolio.bmp Photo=... ContactName=Ms. Nancy Davolio ContactTitle=Sales Representative Address=507 - 20th Ave. E.
Apt. 2A City=Seattle Region=WA PostalCode=98122 Country=USA Fax=null ContactID=121 ContactType=Employee CompanyName=Northwind Phone=(206) 555-9857
Extension=3457 PhotoPath=http://accweb/emmployees/fuller.bmp Photo=... ContactName=Dr. Andrew Fuller ContactTitle=Vice President, Sales Address=908 W. Capital Way City=Tacoma Region=WA PostalCode=98401 Country=USA Fax=null ContactID=122 ContactType=Employee CompanyName=Northwind Phone=(206) 555-9482
Extension=3355 PhotoPath=http://accweb/emmployees/leverling.bmp Photo=... ContactName=Ms. Janet Leverling ContactTitle=Sales Representative Address=722 Moss Bay Blvd. City=Kirkland Region=WA PostalCode=98033 Country=USA Fax=null ContactID=123 ContactType=Employee CompanyName=Northwind Phone=(206) 555-3412
Extension=5176 PhotoPath=http://accweb/emmployees/peacock.bmp Photo=... ContactName=Mrs. Margaret Peacock ContactTitle=Sales Representative Address=4110 Old Redmond Rd. City=Redmond Region=WA PostalCode=98052 Country=USA Fax=null ContactID=124 ContactType=Employee CompanyName=Northwind Phone=(206) 555-8122
Extension=3453 PhotoPath=http://accweb/emmployees/buchanan.bmp Photo=... ContactName=Mr. Steven Buchanan ContactTitle=Sales Manager Address=14 Garrett Hill City=London Region=null PostalCode=SW1 8JR Country=UK Fax=null ContactID=125 ContactType=Employee CompanyName=Northwind Phone=(71) 555-4848
Extension=428 PhotoPath=http://accweb/emmployees/davolio.bmp Photo=... ContactName=Mr. Michael Suyama ContactTitle=Sales Representative Address=Coventry House
Miner Rd. City=London Region=null PostalCode=EC2 7JR Country=UK Fax=null ContactID=126 ContactType=Employee CompanyName=Northwind Phone=(71) 555-7773
Extension=465 PhotoPath=http://accweb/emmployees/davolio.bmp Photo=... ContactName=Mr. Robert King ContactTitle=Sales Representative Address=Edgeham Hollow
Winchester Way City=London Region=null PostalCode=RG1 9SP Country=UK Fax=null ContactID=127 ContactType=Employee CompanyName=Northwind Phone=(71) 555-5598
Extension=2344 PhotoPath=http://accweb/emmployees/davolio.bmp Photo=... ContactName=Ms. Laura Callahan ContactTitle=Inside Sales Coordinator Address=4726 - 11th Ave. N.E. City=Seattle Region=WA PostalCode=98105 Country=USA Fax=null ContactID=128 ContactType=Employee CompanyName=Northwind Phone=(206) 555-1189
Extension=452 PhotoPath=http://accweb/emmployees/davolio.bmp Photo=... ContactName=Ms. Anne Dodsworth ContactTitle=Sales Representative Address=7 Houndstooth Rd. City=London Region=null PostalCode=WG2 7LT Country=UK Fax=null ContactID=129 ContactType=Employee CompanyName=Northwind Phone=(71) 555-4444
null
null
null
null
This sample uses a cast to retrieve customer contacts who live in London.
Public Sub LinqToSqlInheritance05()
Dim cons = From c In newDB.Contacts _
Where c.ContactType = "Customer" AndAlso (DirectCast(c, CustomerContact)).City = "London" _
Select c
ObjectDumper.Write(cons, 0)
End Sub
Result:
ContactName=Thomas Hardy ContactTitle=Sales Representative Address=120 Hanover Sq. City=London Region=null PostalCode=WA1 1DP Country=UK Fax=(171) 555-6750 ContactID=4 ContactType=Customer CompanyName=Around the Horn Phone=(171) 555-7788
ContactName=Victoria Ashworth ContactTitle=Sales Representative Address=Fauntleroy Circus City=London Region=null PostalCode=EC2 5NT Country=UK Fax=null ContactID=11 ContactType=Customer CompanyName=B's Beverages Phone=(171) 555-1212
ContactName=Elizabeth Brown ContactTitle=Sales Representative Address=Berkeley Gardens 12 Brewery City=London Region=null PostalCode=WX1 6LT Country=UK Fax=(171) 555-9199 ContactID=16 ContactType=Customer CompanyName=Consolidated Holdings Phone=(171) 555-2282
ContactName=Ann Devon ContactTitle=Sales Agent Address=35 King George City=London Region=null PostalCode=WX3 6FW Country=UK Fax=(171) 555-3373 ContactID=19 ContactType=Customer CompanyName=Eastern Connection Phone=(171) 555-0297
ContactName=Simon Crowther ContactTitle=Sales Associate Address=South House 300 Queensbridge City=London Region=null PostalCode=SW7 1RZ Country=UK Fax=(171) 555-2530 ContactID=53 ContactType=Customer CompanyName=North/South Phone=(171) 555-7733
ContactName=Hari Kumar ContactTitle=Sales Manager Address=90 Wadhurst Rd. City=London Region=null PostalCode=OX15 4NB Country=UK Fax=(171) 555-5646 ContactID=72 ContactType=Customer CompanyName=Seven Seas Imports Phone=(171) 555-1717
This sample demonstrates that an unknown contact type will be automatically converted to the default contact type.
Public Sub LinqToSqlInheritance06()
Console.WriteLine("***** INSERT Unknown Contact using normal mapping *****")
Dim contact = New Contact() With {.ContactType = Nothing, .CompanyName = "Unknown Company", .City = "London", .Phone = "333-444-5555"}
db.Contacts.Add(contact)
db.SubmitChanges()
Console.WriteLine()
Console.WriteLine("***** Query Unknown Contact using inheritance mapping *****")
Dim con = (From c In newDB.Contacts _
Where c.ContactType = Nothing _
Select c).First()
Console.WriteLine("The base class nwind.BaseContact had been used as default fallback type")
Console.WriteLine("The discriminator value for con is unknown. So, its type should be {0}", con.GetType().ToString())
cleanup140(contact.ContactID)
End Sub
Result:
***** INSERT Unknown Contact using normal mapping *****
***** Query Unknown Contact using inheritance mapping *****
The base class nwind.BaseContact had been used as default fallback type
The discriminator value for con is unknown. So, its type should be SampleQueries.NorthwindInheritance+BaseContact
This sample demonstrates how to create a new shipper contact.
Public Sub LinqToSqlInheritance07()
Console.WriteLine("****** Before Insert Record ******")
Dim ShipperContacts = From sc In newDB.Contacts.OfType(Of ShipperContact)() _
Where sc.CompanyName = "Northwind Shipper" _
Select sc
Console.WriteLine()
Console.WriteLine("There is {0} Shipper Contact matched our requirement", ShipperContacts.Count())
Dim nsc = New ShipperContact() With {.CompanyName = "Northwind Shipper", .Phone = "(123)-456-7890"}
newDB.Contacts.Add(nsc)
newDB.SubmitChanges()
Console.WriteLine()
Console.WriteLine("****** After Insert Record ******")
ShipperContacts = From sc In newDB.Contacts.OfType(Of ShipperContact)() _
Where sc.CompanyName = "Northwind Shipper" _
Select sc
Console.WriteLine()
Console.WriteLine("There is {0} Shipper Contact matched our requirement", ShipperContacts.Count())
newDB.Contacts.Remove(nsc)
newDB.SubmitChanges()
End Sub
Result:
****** Before Insert Record ******
There is 0 Shipper Contact matched our requirement
****** After Insert Record ******
There is 1 Shipper Contact matched our requirement
