title: Converting DataTable to Dictionary using LINQ in VB.NET
body: <p>I have a DataTable which pulls out results from a SQL table using this SQL:</p>
  
  <pre><code>SELECT firstName,lastName,companyName,address1,countryCode FROM dbo.users
  </code></pre>
  
  <p>I would like to convert this DataTable to a Dictionary-esque structure with the key for each field above being the column name and the value being the value for each DataRow for that column. I have a vague idea of how to do it in C# but the VB.NET LINQ syntax is completely different so I'm struggling to figure out how to do this..</p>
  
  <p>Structure (visualized in JSON) would be something like this:</p>
  
  <pre><code>[
      {
          "firstName": "Adam",
          "lastName": "Smith",
          "address1": "123 Old St",
          "companyName": "Fake Company",
          "countryCode": "us"
      },
      {
          "firstName": "Paul",
          "lastName": "Jones",
          "address1": "474 Old St",
          "companyName": "Fake Company",
          "countryCode": "gb"
      }
  ]
  </code></pre>