title: convert complex JSON to dataset using JSON schema
body: <p>I have some complex JSON data (1-many relationships) and both a text file and URL reference to the schema.  I need to convert the data to a System.Data.Dataset, perserving the data types and relationships in the schema.</p>
  
  <p>At present, I've been able to create a dataset by converting the data to an XML document, but it does not read the schema and therefore the data columns are all text and the data relationship is not preserved.</p>
  
  <pre><code>Imports System.Data
  Imports Newtonsoft.Json
  Imports System.IO
  
      Dim xml As XmlDocument = JsonConvert.DeserializeXmlNode(System.IO.File.ReadAllText("C:\jsondata.txt"), "rootnode")
      Dim ds As New DataSet("Json Data")
      Dim xr As XmlReader = New XmlNodeReader(xml)
  ds.ReadXml(xr)
  </code></pre>
  
  <p>My programming language is VB.NET.</p>
  
  <p>At this point I can see all the data in the appropriate tables, but the relationships are assigned by the converter and all the data is text.  I don't see a way of referencing the schema in this or any other Json.net method.</p>
  
  <p>Any help would be appreciated.</p>