title: How to parse a string json from a sql query result and map it
body: <p>I have a query that gives me a result but 2 columns of the table im querying into dont have normal records but they contain a JSON string (varcharMAX format).I need to parse the json given from the query result and map it </p>
  
  <p>this is the mapping i have done where i get the values of the column </p>
  
  <pre><code> vinDetails e = new vinDetails();
    {
  
     e.bundle= DataReaderExtension.GetStringOrNull(reader, "bundle");
     e.fix = DataReaderExtension.GetStringOrNull(reader, "fix")
     e.House = DataReaderExtension.GetStringOrNull(reader, "House")
     e.not_House = DataReaderExtension.GetStringOrNull(reader, "not_House ")
     };
  </code></pre>
  
  <p>While this is my model </p>
  
  <p>public class vinDetails</p>
  
  <pre><code>    public string bundle { get; set; }
      public string fix { get; set; }
      public string house { get; set; }
      public string not_house { get; set; }
  </code></pre>
  
  <p>bundle and fix are fine since they are just a value taken from the column.
  But the other i have in the model (house,not_house),
  they both return a string JSON  like this </p>
  
  <pre><code>   {
      'Email': 'james@example.com',
       'Active': true,
      'CreatedDate': '2013-01-20T00:00:00Z',
      'Roles': [
       'User',
       'Admin'
               ]
               }"
  </code></pre>
  
  <p>I dont know how to map these json in order to return evrything in a </p>
  
  <p>LinkedList</p>