LINQ - Sample Queries

This project contains about 101 samples using LINQ.

 
 
 
 
 
4.8 Star
(89)
175,658 times
Add to favorites
3/13/2012
E-mail Twitter del.icio.us Digg Facebook

Solution explorer

VB.NET
C#
<Root><Customers CustomerID="ALFKI"><CompanyName>Alfreds Futterkiste</CompanyName><ContactName>Maria Anders</ContactName><ContactTitle>Sales Representative</ContactTitle><Phone>030-0074321</Phone><Fax>030-0076545</Fax><FullAddress><Address>Obere Str. 57</Address><City>Berlin</City><PostalCode>12209</PostalCode><Country>Germany</Country></FullAddress></Customers><Customers CustomerID="ANATR"><CompanyName>Ana Trujillo Emparedados y helados</CompanyName><ContactName>Ana Trujillo</ContactName><ContactTitle>Owner</ContactTitle><Phone>(5) 555-4729</Phone><Fax>(5) 555-3745</Fax><FullAddress><Address>Avda. de la Constitución 2222</Address><City>México D.F.</City><PostalCode>05021</PostalCode><Country>Mexico</Country></FullAddress></Customers><Customers CustomerID="ANTON"><CompanyName>Antonio Moreno Taquería</CompanyName><ContactName>Antonio Moreno</ContactName><ContactTitle>Owner</ContactTitle><Phone>(5) 555-3932</Phone><FullAddress><Address>Mataderos  2312</Address><City>México D.F.</City><PostalCode>05023</PostalCode><Country>Mexico</Country></FullAddress></Customers><Customers CustomerID="AROUT"><CompanyName>Around the Horn</CompanyName><ContactName>Thomas Hardy</ContactName><ContactTitle>Sales Representative</ContactTitle><Phone>(171) 555-7788</Phone><Fax>(171) 555-6750</Fax><FullAddress><Address>120 Hanover Sq.</Address><City>London</City><PostalCode>WA1 1DP</PostalCode><Country>UK</Country></FullAddress></Customers><Customers CustomerID="BERGS"><CompanyName>Berglunds snabbköp</CompanyName><ContactName>Christina Berglund</ContactName><ContactTitle>Order Administrator</ContactTitle><Phone>0921-12 34 65</Phone><Fax>0921-12 34 67</Fax><FullAddress><Address>Berguvsvägen  8</Address><City>Luleå</City><PostalCode>S-958 22</PostalCode><Country>Sweden</Country></FullAddress></Customers><Customers CustomerID="BLAUS"><CompanyName>Blauer See Delikatessen</CompanyName><ContactName>Hanna Moos</ContactName><ContactTitle>Sales Representative</ContactTitle><Phone>0621-08460</Phone><Fax>0621-08924</Fax><FullAddress><Address>Forsterstr. 57</Address><City>Mannheim</City><PostalCode>68306</PostalCode><Country>Germany</Country></FullAddress></Customers><Customers CustomerID="BLONP"><CompanyName>Blondesddsl père et fils</CompanyName><ContactName>Frédérique Citeaux</ContactName><ContactTitle>Marketing Manager</ContactTitle><Phone>88.60.15.31</Phone><Fax>88.60.15.32</Fax><FullAddress><Address>24, place Kléber</Address><City>Strasbourg</City><PostalCode>67000</PostalCode><Country>France</Country></FullAddress></Customers><Customers CustomerID="BOLID"><CompanyName>Bólido Comidas preparadas</CompanyName><ContactName>Martín Sommer</ContactName><ContactTitle>Owner</ContactTitle><Phone>(91) 555 22 82</Phone><Fax>(91) 555 91 99</Fax><FullAddress><Address>C/ Araquil, 67</Address><City>Madrid</City><PostalCode>28023</PostalCode><Country>Spain</Country></FullAddress></Customers><Customers CustomerID="BONAP"><CompanyName>Bon app&apos;</CompanyName><ContactName>Laurence Lebihan</ContactName><ContactTitle>Owner</ContactTitle><Phone>91.24.45.40</Phone><Fax>91.24.45.41</Fax><FullAddress><Address>12, rue des Bouchers</Address><City>Marseille</City><PostalCode>13008</PostalCode><Country>France</Country></FullAddress></Customers><Customers CustomerID="BOTTM"><CompanyName>Bottom-Dollar Markets</CompanyName><ContactName>Elizabeth Lincoln</ContactName><ContactTitle>Accounting Manager</ContactTitle><Phone>(604) 555-4729</Phone><Fax>(604) 555-3745</Fax><FullAddress><Address>23 Tsawassen Blvd.</Address><City>Tsawassen</City><Region>BC</Region><PostalCode>T2F 8M4</PostalCode><Country>Canada</Country></FullAddress></Customers><Customers CustomerID="BSBEV"><CompanyName>B&apos;s Beverages</CompanyName><ContactName>Victoria Ashworth</ContactName><ContactTitle>Sales Representative</ContactTitle><Phone>(171) 555-1212</Phone><FullAddress><Address>Fauntleroy Circus</Address><City>London</City><PostalCode>EC2 5NT</PostalCode><Country>UK</Country></FullAddress></Customers><Customers CustomerID="CACTU"><CompanyName>Cactus Comidas para llevar</CompanyName><ContactName>Patricio Simpson</ContactName><ContactTitle>Sales Agent</ContactTitle><Phone>(1) 135-5555</Phone><Fax>(1) 135-4892</Fax><FullAddress><Address>Cerrito 333</Address><City>Buenos Aires</City><PostalCode>1010</PostalCode><Country>Argentina</Country></FullAddress></Customers><Customers CustomerID="CENTC"><CompanyName>Centro comercial Moctezuma</CompanyName><ContactName>Francisco Chang</ContactName><ContactTitle>Marketing Manager</ContactTitle><Phone>(5) 555-3392</Phone><Fax>(5) 555-7293</Fax><FullAddress><Address>Sierras de Granada 9993</Address><City>México D.F.</City><PostalCode>05022</PostalCode><Country>Mexico</Country></FullAddress></Customers><Customers CustomerID="CHOPS"><CompanyName>Chop-suey Chinese</CompanyName><ContactName>Yang Wang</ContactName><ContactTitle>Owner</ContactTitle><Phone>0452-076545</Phone><FullAddress><Address>Hauptstr. 29</Address><City>Bern</City><PostalCode>3012</PostalCode><Country>Switzerland</Country></FullAddress></Customers><Customers CustomerID="COMMI"><CompanyName>Comércio Mineiro</CompanyName><ContactName>Pedro Afonso</ContactName><ContactTitle>Sales Associate</ContactTitle><Phone>(11) 555-7647</Phone><FullAddress><Address>Av. dos Lusíadas, 23</Address><City>Sao Paulo</City><Region>SP</Region><PostalCode>05432-043</PostalCode><Country>Brazil</Country></FullAddress></Customers><Customers CustomerID="CONSH"><CompanyName>Consolidated Holdings</CompanyName><ContactName>Elizabeth Brown</ContactName><ContactTitle>Sales Representative</ContactTitle><Phone>(171) 555-2282</Phone><Fax>(171) 555-9199</Fax><FullAddress><Address>Berkeley Gardens 12  Brewery</Address><City>London</City><PostalCode>WX1 6LT</PostalCode><Country>UK</Country></FullAddress></Customers><Customers CustomerID="DRACD"><CompanyName>Drachenblut Delikatessen</CompanyName><ContactName>Sven Ottlieb</ContactName><ContactTitle>Order Administrator</ContactTitle><Phone>0241-039123</Phone><Fax>0241-059428</Fax><FullAddress><Address>Walserweg 21</Address><City>Aachen</City><PostalCode>52066</PostalCode><Country>Germany</Country></FullAddress></Customers><Customers CustomerID="DUMON"><CompanyName>Du monde entier</CompanyName><ContactName>Janine Labrune</ContactName><ContactTitle>Owner</ContactTitle><Phone>40.67.88.88</Phone><Fax>40.67.89.89</Fax><FullAddress><Address>67, rue des Cinquante Otages</Address><City>Nantes</City><PostalCode>44000</PostalCode><Country>France</Country></FullAddress></Customers><Customers CustomerID="EASTC"><CompanyName>Eastern Connection</CompanyName><ContactName>Ann Devon</ContactName><ContactTitle>Sales Agent</ContactTitle><Phone>(171) 555-0297</Phone><Fax>(171) 555-3373</Fax><FullAddress><Address>35 King George</Address><City>London</City><PostalCode>WX3 6FW</PostalCode><Country>UK</Country></FullAddress></Customers><Customers CustomerID="ERNSH"><CompanyName>Ernst Handel</CompanyName><ContactName>Roland Mendel</ContactName><ContactTitle>Sales Manager</ContactTitle><Phone>7675-3425</Phone><Fax>7675-3426</Fax><FullAddress><Address>Kirchgasse 6</Address><City>Graz</City><PostalCode>8010</PostalCode><Country>Austria</Country></FullAddress></Customers><Customers CustomerID="FAMIA"><CompanyName>Familia Arquibaldo</CompanyName><ContactName>Aria Cruz</ContactName><ContactTitle>Marketing Assistant</ContactTitle><Phone>(11) 555-9857</Phone><FullAddress><Address>Rua Orós, 92</Address><City>Sao Paulo</City><Region>SP</Region><PostalCode>05442-030</PostalCode><Country>Brazil</Country></FullAddress></Customers><Customers CustomerID="FISSA"><CompanyName>FISSA Fabrica Inter. Salchichas S.A.</CompanyName><ContactName>Diego Roel</ContactName><ContactTitle>Accounting Manager</ContactTitle><Phone>(91) 555 94 44</Phone><Fax>(91) 555 55 93</Fax><FullAddress><Address>C/ Moralzarzal, 86</Address><City>Madrid</City><PostalCode>28034</PostalCode><Country>Spain</Country></FullAddress></Customers><Customers CustomerID="FOLIG"><CompanyName>Folies gourmandes</CompanyName><ContactName>Martine Rancé</ContactName><ContactTitle>Assistant Sales Agent</ContactTitle><Phone>20.16.10.16</Phone><Fax>20.16.10.17</Fax><FullAddress><Address>184, chaussée de Tournai</Address><City>Lille</City><PostalCode>59000</PostalCode><Country>France</Country></FullAddress></Customers><Customers CustomerID="FOLKO"><CompanyName>Folk och fä HB</CompanyName><ContactName>Maria Larsson</ContactName><ContactTitle>Owner</ContactTitle><Phone>0695-34 67 21</Phone><FullAddress><Address>Åkergatan 24</Address><City>Bräcke</City><PostalCode>S-844 67</PostalCode><Country>Sweden</Country></FullAddress></Customers><Customers CustomerID="FRANK"><CompanyName>Frankenversand</CompanyName><ContactName>Peter Franken</ContactName><ContactTitle>Marketing Manager</ContactTitle><Phone>089-0877310</Phone><Fax>089-0877451</Fax><FullAddress><Address>Berliner Platz 43</Address><City>München</City><PostalCode>80805</PostalCode><Country>Germany</Country></FullAddress></Customers><Customers CustomerID="FRANR"><CompanyName>France restauration</CompanyName><ContactName>Carine Schmitt</ContactName><ContactTitle>Marketing Manager</ContactTitle><Phone>40.32.21.21</Phone><Fax>40.32.21.20</Fax><FullAddress><Address>54, rue Royale</Address><City>Nantes</City><PostalCode>44000</PostalCode><Country>France</Country></FullAddress></Customers><Customers CustomerID="FRANS"><CompanyName>Franchi S.p.A.</CompanyName><ContactName>Paolo Accorti</ContactName><ContactTitle>Sales Representative</ContactTitle><Phone>011-4988260</Phone><Fax>011-4988261</Fax><FullAddress><Address>Via Monte Bianco 34</Address><City>Torino</City><PostalCode>10100</PostalCode><Country>Italy</Country></FullAddress></Customers><Customers CustomerID="FURIB"><CompanyName>Furia Bacalhau e Frutos do Mar</CompanyName><ContactName>Lino Rodriguez</ContactName><ContactTitle>Sales Manager</ContactTitle><Phone>(1) 354-2534</Phone><Fax>(1) 354-2535</Fax><FullAddress><Address>Jardim das rosas n. 32</Address><City>Lisboa</City><PostalCode>1675</PostalCode><Country>Portugal</Country></FullAddress></Customers><Customers CustomerID="GALED"><CompanyName>Galería del gastrónomo</CompanyName><ContactName>Eduardo Saavedra</ContactName><ContactTitle>Marketing Manager</ContactTitle><Phone>(93) 203 4560</Phone><Fax>(93) 203 4561</Fax><FullAddress><Address>Rambla de Cataluña, 23</Address><City>Barcelona</City><PostalCode>08022</PostalCode><Country>Spain</Country></FullAddress></Customers><Customers CustomerID="GODOS"><CompanyName>Godos Cocina Típica</CompanyName><ContactName>José Pedro Freyre</ContactName><ContactTitle>Sales Manager</ContactTitle><Phone>(95) 555 82 82</Phone><FullAddress><Address>C/ Romero, 33</Address><City>Sevilla</City><PostalCode>41101</PostalCode><Country>Spain</Country></FullAddress></Customers><Customers CustomerID="GOURL"><CompanyName>Gourmet Lanchonetes</CompanyName><ContactName>André Fonseca</ContactName><ContactTitle>Sales Associate</ContactTitle><Phone>(11) 555-9482</Phone><FullAddress><Address>Av. Brasil, 442</Address><City>Campinas</City><Region>SP</Region><PostalCode>04876-786</PostalCode><Country>Brazil</Country></FullAddress></Customers><Customers CustomerID="GREAL"><CompanyName>Great Lakes Food Market</CompanyName><ContactName>Howard Snyder</ContactName><ContactTitle>Marketing Manager</ContactTitle><Phone>(503) 555-7555</Phone><FullAddress><Address>2732 Baker Blvd.</Address><City>Eugene</City><Region>OR</Region><PostalCode>97403</PostalCode><Country>USA</Country></FullAddress></Customers><Customers CustomerID="GROSR"><CompanyName>GROSELLA-Restaurante</CompanyName><ContactName>Manuel Pereira</ContactName><ContactTitle>Owner</ContactTitle><Phone>(2) 283-2951</Phone><Fax>(2) 283-3397</Fax><FullAddress><Address>5ª Ave. Los Palos Grandes</Address><City>Caracas</City><Region>DF</Region><PostalCode>1081</PostalCode><Country>Venezuela</Country></FullAddress></Customers><Customers CustomerID="HANAR"><CompanyName>Hanari Carnes</CompanyName><ContactName>Mario Pontes</ContactName><ContactTitle>Accounting Manager</ContactTitle><Phone>(21) 555-0091</Phone><Fax>(21) 555-8765</Fax><FullAddress><Address>Rua do Paço, 67</Address><City>Rio de Janeiro</City><Region>RJ</Region><PostalCode>05454-876</PostalCode><Country>Brazil</Country></FullAddress></Customers><Customers CustomerID="HILAA"><CompanyName>HILARION-Abastos</CompanyName><ContactName>Carlos Hernández</ContactName><ContactTitle>Sales Representative</ContactTitle><Phone>(5) 555-1340</Phone><Fax>(5) 555-1948</Fax><FullAddress><Address>Carrera 22 con Ave. Carlos Soublette #8-35</Address><City>San Cristóbal</City><Region>Táchira</Region><PostalCode>5022</PostalCode><Country>Venezuela</Country></FullAddress></Customers><Customers CustomerID="HUNGC"><CompanyName>Hungry Coyote Import Store</CompanyName><ContactName>Yoshi Latimer</ContactName><ContactTitle>Sales Representative</ContactTitle><Phone>(503) 555-6874</Phone><Fax>(503) 555-2376</Fax><FullAddress><Address>City Center Plaza 516 Main St.</Address><City>Elgin</City><Region>OR</Region><PostalCode>97827</PostalCode><Country>USA</Country></FullAddress></Customers><Customers CustomerID="HUNGO"><CompanyName>Hungry Owl All-Night Grocers</CompanyName><ContactName>Patricia McKenna</ContactName><ContactTitle>Sales Associate</ContactTitle><Phone>2967 542</Phone><Fax>2967 3333</Fax><FullAddress><Address>8 Johnstown Road</Address><City>Cork</City><Region>Co. Cork</Region><Country>Ireland</Country></FullAddress></Customers><Customers CustomerID="ISLAT"><CompanyName>Island Trading</CompanyName><ContactName>Helen Bennett</ContactName><ContactTitle>Marketing Manager</ContactTitle><Phone>(198) 555-8888</Phone><FullAddress><Address>Garden House Crowther Way</Address><City>Cowes</City><Region>Isle of Wight</Region><PostalCode>PO31 7PJ</PostalCode><Country>UK</Country></FullAddress></Customers><Customers CustomerID="KOENE"><CompanyName>Königlich Essen</CompanyName><ContactName>Philip Cramer</ContactName><ContactTitle>Sales Associate</ContactTitle><Phone>0555-09876</Phone><FullAddress><Address>Maubelstr. 90</Address><City>Brandenburg</City><PostalCode>14776</PostalCode><Country>Germany</Country></FullAddress></Customers><Customers CustomerID="LACOR"><CompanyName>La corne d&apos;abondance</CompanyName><ContactName>Daniel Tonini</ContactName><ContactTitle>Sales Representative</ContactTitle><Phone>30.59.84.10</Phone><Fax>30.59.85.11</Fax><FullAddress><Address>67, avenue de l&apos;Europe</Address><City>Versailles</City><PostalCode>78000</PostalCode><Country>France</Country></FullAddress></Customers><Customers CustomerID="LAMAI"><CompanyName>La maison d&apos;Asie</CompanyName><ContactName>Annette Roulet</ContactName><ContactTitle>Sales Manager</ContactTitle><Phone>61.77.61.10</Phone><Fax>61.77.61.11</Fax><FullAddress><Address>1 rue Alsace-Lorraine</Address><City>Toulouse</City><PostalCode>31000</PostalCode><Country>France</Country></FullAddress></Customers><Customers CustomerID="LAUGB"><CompanyName>Laughing Bacchus Wine Cellars</CompanyName><ContactName>Yoshi Tannamuri</ContactName><ContactTitle>Marketing Assistant</ContactTitle><Phone>(604) 555-3392</Phone><Fax>(604) 555-7293</Fax><FullAddress><Address>1900 Oak St.</Address><City>Vancouver</City><Region>BC</Region><PostalCode>V3F 2K1</PostalCode><Country>Canada</Country></FullAddress></Customers><Customers CustomerID="LAZYK"><CompanyName>Lazy K Kountry Store</CompanyName><ContactName>John Steel</ContactName><ContactTitle>Marketing Manager</ContactTitle><Phone>(509) 555-7969</Phone><Fax>(509) 555-6221</Fax><FullAddress><Address>12 Orchestra Terrace</Address><City>Walla Walla</City><Region>WA</Region><PostalCode>99362</PostalCode><Country>USA</Country></FullAddress></Customers><Customers CustomerID="LEHMS"><CompanyName>Lehmanns Marktstand</CompanyName><ContactName>Renate Messner</ContactName><ContactTitle>Sales Representative</ContactTitle><Phone>069-0245984</Phone><Fax>069-0245874</Fax><FullAddress><Address>Magazinweg 7</Address><City>Frankfurt a.M.</City><PostalCode>60528</PostalCode><Country>Germany</Country></FullAddress></Customers><Customers CustomerID="LETSS"><CompanyName>Let&apos;s Stop N Shop</CompanyName><ContactName>Jaime Yorres</ContactName><ContactTitle>Owner</ContactTitle><Phone>(415) 555-5938</Phone><FullAddress><Address>87 Polk St. Suite 5</Address><City>San Francisco</City><Region>CA</Region><PostalCode>94117</PostalCode><Country>USA</Country></FullAddress></Customers><Customers CustomerID="LILAS"><CompanyName>LILA-Supermercado</CompanyName><ContactName>Carlos González</ContactName><ContactTitle>Accounting Manager</ContactTitle><Phone>(9) 331-6954</Phone><Fax>(9) 331-7256</Fax><FullAddress><Address>Carrera 52 con Ave. Bolívar #65-98 Llano Largo</Address><City>Barquisimeto</City><Region>Lara</Region><PostalCode>3508</PostalCode><Country>Venezuela</Country></FullAddress></Customers><Customers CustomerID="LINOD"><CompanyName>LINO-Delicateses</CompanyName><ContactName>Felipe Izquierdo</ContactName><ContactTitle>Owner</ContactTitle><Phone>(8) 34-56-12</Phone><Fax>(8) 34-93-93</Fax><FullAddress><Address>Ave. 5 de Mayo Porlamar</Address><City>I. de Margarita</City><Region>Nueva Esparta</Region><PostalCode>4980</PostalCode><Country>Venezuela</Country></FullAddress></Customers><Customers CustomerID="LONEP"><CompanyName>Lonesome Pine Restaurant</CompanyName><ContactName>Fran Wilson</ContactName><ContactTitle>Sales Manager</ContactTitle><Phone>(503) 555-9573</Phone><Fax>(503) 555-9646</Fax><FullAddress><Address>89 Chiaroscuro Rd.</Address><City>Portland</City><Region>OR</Region><PostalCode>97219</PostalCode><Country>USA</Country></FullAddress></Customers><Customers CustomerID="MAGAA"><CompanyName>Magazzini Alimentari Riuniti</CompanyName><ContactName>Giovanni Rovelli</ContactName><ContactTitle>Marketing Manager</ContactTitle><Phone>035-640230</Phone><Fax>035-640231</Fax><FullAddress><Address>Via Ludovico il Moro 22</Address><City>Bergamo</City><PostalCode>24100</PostalCode><Country>Italy</Country></FullAddress></Customers><Customers CustomerID="MAISD"><CompanyName>Maison Dewey</CompanyName><ContactName>Catherine Dewey</ContactName><ContactTitle>Sales Agent</ContactTitle><Phone>(02) 201 24 67</Phone><Fax>(02) 201 24 68</Fax><FullAddress><Address>Rue Joseph-Bens 532</Address><City>Bruxelles</City><PostalCode>B-1180</PostalCode><Country>Belgium</Country></FullAddress></Customers><Customers CustomerID="MEREP"><CompanyName>Mère Paillarde</CompanyName><ContactName>Jean Fresnière</ContactName><ContactTitle>Marketing Assistant</ContactTitle><Phone>(514) 555-8054</Phone><Fax>(514) 555-8055</Fax><FullAddress><Address>43 rue St. Laurent</Address><City>Montréal</City><Region>Québec</Region><PostalCode>H1J 1C3</PostalCode><Country>Canada</Country></FullAddress></Customers><Customers CustomerID="MORGK"><CompanyName>Morgenstern Gesundkost</CompanyName><ContactName>Alexander Feuer</ContactName><ContactTitle>Marketing Assistant</ContactTitle><Phone>0342-023176</Phone><FullAddress><Address>Heerstr. 22</Address><City>Leipzig</City><PostalCode>04179</PostalCode><Country>Germany</Country></FullAddress></Customers><Customers CustomerID="NORTS"><CompanyName>North/South</CompanyName><ContactName>Simon Crowther</ContactName><ContactTitle>Sales Associate</ContactTitle><Phone>(171) 555-7733</Phone><Fax>(171) 555-2530</Fax><FullAddress><Address>South House 300 Queensbridge</Address><City>London</City><PostalCode>SW7 1RZ</PostalCode><Country>UK</Country></FullAddress></Customers><Customers CustomerID="OCEAN"><CompanyName>Océano Atlántico Ltda.</CompanyName><ContactName>Yvonne Moncada</ContactName><ContactTitle>Sales Agent</ContactTitle><Phone>(1) 135-5333</Phone><Fax>(1) 135-5535</Fax><FullAddress><Address>Ing. Gustavo Moncada 8585 Piso 20-A</Address><City>Buenos Aires</City><PostalCode>1010</PostalCode><Country>Argentina</Country></FullAddress></Customers><Customers CustomerID="OLDWO"><CompanyName>Old World Delicatessen</CompanyName><ContactName>Rene Phillips</ContactName><ContactTitle>Sales Representative</ContactTitle><Phone>(907) 555-7584</Phone><Fax>(907) 555-2880</Fax><FullAddress><Address>2743 Bering St.</Address><City>Anchorage</City><Region>AK</Region><PostalCode>99508</PostalCode><Country>USA</Country></FullAddress></Customers><Customers CustomerID="OTTIK"><CompanyName>Ottilies Käseladen</CompanyName><ContactName>Henriette Pfalzheim</ContactName><ContactTitle>Owner</ContactTitle><Phone>0221-0644327</Phone><Fax>0221-0765721</Fax><FullAddress><Address>Mehrheimerstr. 369</Address><City>Köln</City><PostalCode>50739</PostalCode><Country>Germany</Country></FullAddress></Customers><Customers CustomerID="PARIS"><CompanyName>Paris spécialités</CompanyName><ContactName>Marie Bertrand</ContactName><ContactTitle>Owner</ContactTitle><Phone>(1) 42.34.22.66</Phone><Fax>(1) 42.34.22.77</Fax><FullAddress><Address>265, boulevard Charonne</Address><City>Paris</City><PostalCode>75012</PostalCode><Country>France</Country></FullAddress></Customers><Customers CustomerID="PERIC"><CompanyName>Pericles Comidas clásicas</CompanyName><ContactName>Guillermo Fernández</ContactName><ContactTitle>Sales Representative</ContactTitle><Phone>(5) 552-3745</Phone><Fax>(5) 545-3745</Fax><FullAddress><Address>Calle Dr. Jorge Cash 321</Address><City>México D.F.</City><PostalCode>05033</PostalCode><Country>Mexico</Country></FullAddress></Customers><Customers CustomerID="PICCO"><CompanyName>Piccolo und mehr</CompanyName><ContactName>Georg Pipps</ContactName><ContactTitle>Sales Manager</ContactTitle><Phone>6562-9722</Phone><Fax>6562-9723</Fax><FullAddress><Address>Geislweg 14</Address><City>Salzburg</City><PostalCode>5020</PostalCode><Country>Austria</Country></FullAddress></Customers><Customers CustomerID="PRINI"><CompanyName>Princesa Isabel Vinhos</CompanyName><ContactName>Isabel de Castro</ContactName><ContactTitle>Sales Representative</ContactTitle><Phone>(1) 356-5634</Phone><FullAddress><Address>Estrada da saúde n. 58</Address><City>Lisboa</City><PostalCode>1756</PostalCode><Country>Portugal</Country></FullAddress></Customers><Customers CustomerID="QUEDE"><CompanyName>Que Delícia</CompanyName><ContactName>Bernardo Batista</ContactName><ContactTitle>Accounting Manager</ContactTitle><Phone>(21) 555-4252</Phone><Fax>(21) 555-4545</Fax><FullAddress><Address>Rua da Panificadora, 12</Address><City>Rio de Janeiro</City><Region>RJ</Region><PostalCode>02389-673</PostalCode><Country>Brazil</Country></FullAddress></Customers><Customers CustomerID="QUEEN"><CompanyName>Queen Cozinha</CompanyName><ContactName>Lúcia Carvalho</ContactName><ContactTitle>Marketing Assistant</ContactTitle><Phone>(11) 555-1189</Phone><FullAddress><Address>Alameda dos Canàrios, 891</Address><City>Sao Paulo</City><Region>SP</Region><PostalCode>05487-020</PostalCode><Country>Brazil</Country></FullAddress></Customers><Customers CustomerID="QUICK"><CompanyName>QUICK-Stop</CompanyName><ContactName>Horst Kloss</ContactName><ContactTitle>Accounting Manager</ContactTitle><Phone>0372-035188</Phone><FullAddress><Address>Taucherstraße 10</Address><City>Cunewalde</City><PostalCode>01307</PostalCode><Country>Germany</Country></FullAddress></Customers><Customers CustomerID="RANCH"><CompanyName>Rancho grande</CompanyName><ContactName>Sergio Gutiérrez</ContactName><ContactTitle>Sales Representative</ContactTitle><Phone>(1) 123-5555</Phone><Fax>(1) 123-5556</Fax><FullAddress><Address>Av. del Libertador 900</Address><City>Buenos Aires</City><PostalCode>1010</PostalCode><Country>Argentina</Country></FullAddress></Customers><Customers CustomerID="RATTC"><CompanyName>Rattlesnake Canyon Grocery</CompanyName><ContactName>Paula Wilson</ContactName><ContactTitle>Assistant Sales Representative</ContactTitle><Phone>(505) 555-5939</Phone><Fax>(505) 555-3620</Fax><FullAddress><Address>2817 Milton Dr.</Address><City>Albuquerque</City><Region>NM</Region><PostalCode>87110</PostalCode><Country>USA</Country></FullAddress></Customers><Customers CustomerID="REGGC"><CompanyName>Reggiani Caseifici</CompanyName><ContactName>Maurizio Moroni</ContactName><ContactTitle>Sales Associate</ContactTitle><Phone>0522-556721</Phone><Fax>0522-556722</Fax><FullAddress><Address>Strada Provinciale 124</Address><City>Reggio Emilia</City><PostalCode>42100</PostalCode><Country>Italy</Country></FullAddress></Customers><Customers CustomerID="RICAR"><CompanyName>Ricardo Adocicados</CompanyName><ContactName>Janete Limeira</ContactName><ContactTitle>Assistant Sales Agent</ContactTitle><Phone>(21) 555-3412</Phone><FullAddress><Address>Av. Copacabana, 267</Address><City>Rio de Janeiro</City><Region>RJ</Region><PostalCode>02389-890</PostalCode><Country>Brazil</Country></FullAddress></Customers><Customers CustomerID="RICSU"><CompanyName>Richter Supermarkt</CompanyName><ContactName>Michael Holz</ContactName><ContactTitle>Sales Manager</ContactTitle><Phone>0897-034214</Phone><FullAddress><Address>Grenzacherweg 237</Address><City>Genève</City><PostalCode>1203</PostalCode><Country>Switzerland</Country></FullAddress></Customers><Customers CustomerID="ROMEY"><CompanyName>Romero y tomillo</CompanyName><ContactName>Alejandra Camino</ContactName><ContactTitle>Accounting Manager</ContactTitle><Phone>(91) 745 6200</Phone><Fax>(91) 745 6210</Fax><FullAddress><Address>Gran Vía, 1</Address><City>Madrid</City><PostalCode>28001</PostalCode><Country>Spain</Country></FullAddress></Customers><Customers CustomerID="SANTG"><CompanyName>Santé Gourmet</CompanyName><ContactName>Jonas Bergulfsen</ContactName><ContactTitle>Owner</ContactTitle><Phone>07-98 92 35</Phone><Fax>07-98 92 47</Fax><FullAddress><Address>Erling Skakkes gate 78</Address><City>Stavern</City><PostalCode>4110</PostalCode><Country>Norway</Country></FullAddress></Customers><Customers CustomerID="SAVEA"><CompanyName>Save-a-lot Markets</CompanyName><ContactName>Jose Pavarotti</ContactName><ContactTitle>Sales Representative</ContactTitle><Phone>(208) 555-8097</Phone><FullAddress><Address>187 Suffolk Ln.</Address><City>Boise</City><Region>ID</Region><PostalCode>83720</PostalCode><Country>USA</Country></FullAddress></Customers><Customers CustomerID="SEVES"><CompanyName>Seven Seas Imports</CompanyName><ContactName>Hari Kumar</ContactName><ContactTitle>Sales Manager</ContactTitle><Phone>(171) 555-1717</Phone><Fax>(171) 555-5646</Fax><FullAddress><Address>90 Wadhurst Rd.</Address><City>London</City><PostalCode>OX15 4NB</PostalCode><Country>UK</Country></FullAddress></Customers><Customers CustomerID="SIMOB"><CompanyName>Simons bistro</CompanyName><ContactName>Jytte Petersen</ContactName><ContactTitle>Owner</ContactTitle><Phone>31 12 34 56</Phone><Fax>31 13 35 57</Fax><FullAddress><Address>Vinbæltet 34</Address><City>Kobenhavn</City><PostalCode>1734</PostalCode><Country>Denmark</Country></FullAddress></Customers><Customers CustomerID="SPECD"><CompanyName>Spécialités du monde</CompanyName><ContactName>Dominique Perrier</ContactName><ContactTitle>Marketing Manager</ContactTitle><Phone>(1) 47.55.60.10</Phone><Fax>(1) 47.55.60.20</Fax><FullAddress><Address>25, rue Lauriston</Address><City>Paris</City><PostalCode>75016</PostalCode><Country>France</Country></FullAddress></Customers><Customers CustomerID="SPLIR"><CompanyName>Split Rail Beer &amp; Ale</CompanyName><ContactName>Art Braunschweiger</ContactName><ContactTitle>Sales Manager</ContactTitle><Phone>(307) 555-4680</Phone><Fax>(307) 555-6525</Fax><FullAddress><Address>P.O. Box 555</Address><City>Lander</City><Region>WY</Region><PostalCode>82520</PostalCode><Country>USA</Country></FullAddress></Customers><Customers CustomerID="SUPRD"><CompanyName>Suprêmes délices</CompanyName><ContactName>Pascale Cartrain</ContactName><ContactTitle>Accounting Manager</ContactTitle><Phone>(071) 23 67 22 20</Phone><Fax>(071) 23 67 22 21</Fax><FullAddress><Address>Boulevard Tirou, 255</Address><City>Charleroi</City><PostalCode>B-6000</PostalCode><Country>Belgium</Country></FullAddress></Customers><Customers CustomerID="THEBI"><CompanyName>The Big Cheese</CompanyName><ContactName>Liz Nixon</ContactName><ContactTitle>Marketing Manager</ContactTitle><Phone>(503) 555-3612</Phone><FullAddress><Address>89 Jefferson Way Suite 2</Address><City>Portland</City><Region>OR</Region><PostalCode>97201</PostalCode><Country>USA</Country></FullAddress></Customers><Customers CustomerID="THECR"><CompanyName>The Cracker Box</CompanyName><ContactName>Liu Wong</ContactName><ContactTitle>Marketing Assistant</ContactTitle><Phone>(406) 555-5834</Phone><Fax>(406) 555-8083</Fax><FullAddress><Address>55 Grizzly Peak Rd.</Address><City>Butte</City><Region>MT</Region><PostalCode>59801</PostalCode><Country>USA</Country></FullAddress></Customers><Customers CustomerID="TOMSP"><CompanyName>Toms Spezialitäten</CompanyName><ContactName>Karin Josephs</ContactName><ContactTitle>Marketing Manager</ContactTitle><Phone>0251-031259</Phone><Fax>0251-035695</Fax><FullAddress><Address>Luisenstr. 48</Address><City>Münster</City><PostalCode>44087</PostalCode><Country>Germany</Country></FullAddress></Customers><Customers CustomerID="TORTU"><CompanyName>Tortuga Restaurante</CompanyName><ContactName>Miguel Angel Paolino</ContactName><ContactTitle>Owner</ContactTitle><Phone>(5) 555-2933</Phone><FullAddress><Address>Avda. Azteca 123</Address><City>México D.F.</City><PostalCode>05033</PostalCode><Country>Mexico</Country></FullAddress></Customers><Customers CustomerID="TRADH"><CompanyName>Tradição Hipermercados</CompanyName><ContactName>Anabela Domingues</ContactName><ContactTitle>Sales Representative</ContactTitle><Phone>(11) 555-2167</Phone><Fax>(11) 555-2168</Fax><FullAddress><Address>Av. Inês de Castro, 414</Address><City>Sao Paulo</City><Region>SP</Region><PostalCode>05634-030</PostalCode><Country>Brazil</Country></FullAddress></Customers><Customers CustomerID="TRAIH"><CompanyName>Trail&apos;s Head Gourmet Provisioners</CompanyName><ContactName>Helvetius Nagy</ContactName><ContactTitle>Sales Associate</ContactTitle><Phone>(206) 555-8257</Phone><Fax>(206) 555-2174</Fax><FullAddress><Address>722 DaVinci Blvd.</Address><City>Kirkland</City><Region>WA</Region><PostalCode>98034</PostalCode><Country>USA</Country></FullAddress></Customers><Customers CustomerID="VAFFE"><CompanyName>Vaffeljernet</CompanyName><ContactName>Palle Ibsen</ContactName><ContactTitle>Sales Manager</ContactTitle><Phone>86 21 32 43</Phone><Fax>86 22 33 44</Fax><FullAddress><Address>Smagsloget 45</Address><City>Århus</City><PostalCode>8200</PostalCode><Country>Denmark</Country></FullAddress></Customers><Customers CustomerID="VICTE"><CompanyName>Victuailles en stock</CompanyName><ContactName>Mary Saveley</ContactName><ContactTitle>Sales Agent</ContactTitle><Phone>78.32.54.86</Phone><Fax>78.32.54.87</Fax><FullAddress><Address>2, rue du Commerce</Address><City>Lyon</City><PostalCode>69004</PostalCode><Country>France</Country></FullAddress></Customers><Customers CustomerID="VINET"><CompanyName>Vins et alcools Chevalier</CompanyName><ContactName>Paul Henriot</ContactName><ContactTitle>Accounting Manager</ContactTitle><Phone>26.47.15.10</Phone><Fax>26.47.15.11</Fax><FullAddress><Address>59 rue de l&apos;Abbaye</Address><City>Reims</City><PostalCode>51100</PostalCode><Country>France</Country></FullAddress></Customers><Customers CustomerID="WANDK"><CompanyName>Die Wandernde Kuh</CompanyName><ContactName>Rita Müller</ContactName><ContactTitle>Sales Representative</ContactTitle><Phone>0711-020361</Phone><Fax>0711-035428</Fax><FullAddress><Address>Adenauerallee 900</Address><City>Stuttgart</City><PostalCode>70563</PostalCode><Country>Germany</Country></FullAddress></Customers><Customers CustomerID="WARTH"><CompanyName>Wartian Herkku</CompanyName><ContactName>Pirkko Koskitalo</ContactName><ContactTitle>Accounting Manager</ContactTitle><Phone>981-443655</Phone><Fax>981-443655</Fax><FullAddress><Address>Torikatu 38</Address><City>Oulu</City><PostalCode>90110</PostalCode><Country>Finland</Country></FullAddress></Customers><Customers CustomerID="WELLI"><CompanyName>Wellington Importadora</CompanyName><ContactName>Paula Parente</ContactName><ContactTitle>Sales Manager</ContactTitle><Phone>(14) 555-8122</Phone><FullAddress><Address>Rua do Mercado, 12</Address><City>Resende</City><Region>SP</Region><PostalCode>08737-363</PostalCode><Country>Brazil</Country></FullAddress></Customers><Customers CustomerID="WHITC"><CompanyName>White Clover Markets</CompanyName><ContactName>Karl Jablonski</ContactName><ContactTitle>Owner</ContactTitle><Phone>(206) 555-4112</Phone><Fax>(206) 555-4115</Fax><FullAddress><Address>305 - 14th Ave. S. Suite 3B</Address><City>Seattle</City><Region>WA</Region><PostalCode>98128</PostalCode><Country>USA</Country></FullAddress></Customers><Customers CustomerID="WILMK"><CompanyName>Wilman Kala</CompanyName><ContactName>Matti Karttunen</ContactName><ContactTitle>Owner/Marketing Assistant</ContactTitle><Phone>90-224 8858</Phone><Fax>90-224 8858</Fax><FullAddress><Address>Keskuskatu 45</Address><City>Helsinki</City><PostalCode>21240</PostalCode><Country>Finland</Country></FullAddress></Customers><Customers CustomerID="WOLZA"><CompanyName>Wolski  Zajazd</CompanyName><ContactName>Zbyszek Piestrzeniewicz</ContactName><ContactTitle>Owner</ContactTitle><Phone>(26) 642-7012</Phone><Fax>(26) 642-7012</Fax><FullAddress><Address>ul. Filtrowa 68</Address><City>Warszawa</City><PostalCode>01-012</PostalCode><Country>Poland</Country></FullAddress></Customers></Root>