Skip to main content

Load document from file

Load an XML document from a file

Public Sub XLinq1()
    Dim doc = XDocument.Load(dataPath + "bib.xml")
    Console.WriteLine(doc)
End Sub

Result:
<bib>
  <book year="1994" anson="true">
    <title>TCP/IP Illustrated</title>
    <author>
      <last>Stevens</last>
      <first>W.</first>
    </author>
    <publisher>Addison-Wesley</publisher>
    <price> 65.95</price>
  </book>
  <book year="1992" joe="1,2,3">
    <title>Advanced Programming in the Unix environment</title>
    <author>
      <last>Stevens</last>
      <first>W.</first>
    </author>
    <author>
      <last>Golde</last>
      <first>Peter</first>
    </author>
    <publisher>Addison-Wesley</publisher>
    <price>65.95</price>
  </book>
  <book year="2000">
    <title>Data on the Web</title>
    <author>
      <last>Abiteboul</last>
      <first>Serge</first>
    </author>
    <author>
      <last>Buneman</last>
      <first>Peter</first>
    </author>
    <author>
      <last>Suciu</last>
      <first>Dan</first>
    </author>
    <publisher>Morgan Kaufmann Publishers</publisher>
    <price>39.95</price>
  </book>
  <book year="1999">
    <title>The Economics of Technology and Content for Digital TV</title>
    <author>
      <last>Hejlsberg</last>
      <first>Anders</first>
    </author>
    <editor>
      <last>Gerbarg</last>
      <first>Darcy</first>
      <affiliation type="informal">CITI</affiliation>
    </editor>
    <publisher>Kluwer Academic Publishers</publisher>
    <price>129.95</price>
  </book>
  <book year="2003">
    <title>The C# Programming Language</title>
    <publisher>Addison-Wesley</publisher>
    <author>
      <last>Hejlsberg</last>
      <first>Anders</first>
    </author>
    <author>
      <last>Wiltamuth</last>
      <first>Scott</first>
    </author>
    <author>
      <last>Golde</last>
      <first>Peter</first>
    </author>
  </book>
</bib>


Load document from string

Load document from literal

Public Sub XLinq2()
    Dim doc = _
        <book price="100" isbn="1002310">
            <title>XClarity Samples</title>
            <author>Matt</author>
        </book>

    Console.WriteLine(doc)
End Sub

Result:
<book price="100" isbn="1002310">
  <title>XClarity Samples</title>
  <author>Matt</author>
</book>


Load document from XmlReader

Load an XML document from XmlReader

Public Sub XLinq3()
    Dim reader = XmlReader.Create(dataPath + "bib.xml")
    Dim doc = XDocument.Load(reader)
    Console.WriteLine(doc)
End Sub

Result:
<bib>
    <book year="1994" anson="true">
        <title>TCP/IP Illustrated</title>
        <author><last>Stevens</last><first>W.</first></author>
        <publisher>Addison-Wesley</publisher>
        <price> 65.95</price>
    </book>
    <book year="1992" joe="1,2,3">
        <title>Advanced Programming in the Unix environment</title>
        <author><last>Stevens</last><first>W.</first></author>
        <author><last>Golde</last><first>Peter</first></author>
        <publisher>Addison-Wesley</publisher>
        <price>65.95</price>
    </book>
    <book year="2000">
        <title>Data on the Web</title>
        <author><last>Abiteboul</last><first>Serge</first></author>
        <author><last>Buneman</last><first>Peter</first></author>
        <author><last>Suciu</last><first>Dan</first></author>
        <publisher>Morgan Kaufmann Publishers</publisher>
        <price>39.95</price>
    </book>
    <book year="1999">
        <title>The Economics of Technology and Content for Digital TV</title>
        <author><last>Hejlsberg</last><first>Anders</first></author>
        <editor>
               <last>Gerbarg</last><first>Darcy</first>
                <affiliation type="informal">CITI</affiliation>
        </editor>
            <publisher>Kluwer Academic Publishers</publisher>
        <price>129.95</price>
    </book>
    <book year="2003">
        <title>The C# Programming Language</title>
        <publisher>Addison-Wesley</publisher>
        <author><last>Hejlsberg</last><first>Anders</first></author>
        <author><last>Wiltamuth</last><first>Scott</first></author>
        <author><last>Golde</last><first>Peter</first></author>
    </book>
</bib>


Element from XmlReader - 1

Construct XElement from XmlReader positioned on the root

Public Sub XLinq4()
    Dim reader As XmlReader = XmlReader.Create(dataPath + "nw_customers.xml")
    reader.Read() ' move to root
    Dim c = XElement.Load(reader)
    Console.WriteLine(c)
End Sub

Result:
<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'</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'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'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'Europe</Address>
      <City>Versailles</City>
      <PostalCode>78000</PostalCode>
      <Country>France</Country>
    </FullAddress>
  </Customers>
  <Customers CustomerID="LAMAI">
    <CompanyName>La maison d'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'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'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'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>


Element from XmlReader - 2

Read XElement content from XmlReader not positioned on an Element

Public Sub XLinq5()
    Dim reader As XmlReader = XmlReader.Create(dataPath + "config.xml") 'the file has comments and whitespace at the start
    reader.Read()
    reader.Read()
    Dim config As XElement = <appSettings>This content will be replaced</appSettings>

    config.Add(XElement.Load(reader))
    Console.WriteLine(config)
End Sub

Result:
<appSettings>This content will be replaced<config>
    <rootFolder>c:\</rootFolder>
    <iterations>5</iterations>
    <maxMemory>50.5</maxMemory>
    <tempFolder>c:\temp</tempFolder>
</config></appSettings>