title: Using Textblobbed in sqlite-net-extensions
body: <p>I'm trying to map a complex class in sqlite but something seems to be wrong because when I retrieve my objects the complex fields are empty.
  Shortly, my class is something similar:</p>
  
  <pre><code> public class Contact
   {
      [PrimaryKey, AutoIncrement]
      public int Id { set; get; }
      public string Name { set; get; }
      public string Status { set; get; }
  
      [TextBlob("PhoneNumbersBlobbed")]
      public List&lt;PhoneNumber&gt; PhoneNumbers { set; get; }
      public string PhoneNumbersBlobbed { get; set; } // serialized PhoneNumbers
  
      [TextBlob("MailAddressesBlobbed")]
      public List&lt;ContactEmail&gt; MailAddresses { set; get; }
      public string MailAddressesBlobbed { get; set; } // serialized MailAddresses
   }
  </code></pre>
  
  <p>I obviously have a separated class for PhoneNumber:</p>
  
  <pre><code>     public class PhoneNumber
       {          
          public string Number { set; get; }
          public bool IsVerified { set; get; }
          public string AttrString { set; get; }  
      }
  </code></pre>
  
  <p>while ContactEmail class is a native class of WinPhone.</p>
  
  <p>Well, after have created the tables in DB:</p>
  
  <pre><code> connection.CreateTable&lt;Contact.PhoneNumber&gt;();
   connection.CreateTable&lt;Contact&gt;();
  </code></pre>
  
  <p>and have populated my List of Contact I save them in DB. I tried as saving one by one with:</p>
  
  <pre><code>connection.InsertWithChildren(contact,true);
  </code></pre>
  
  <p>as all the list togheter:</p>
  
  <pre><code>connection.InsertAllWithChildren(listOfContacts, true);
  </code></pre>
  
  <p>and I'm sure that the list is correctly populated before to save it.
  But when I read its values from sqlite:</p>
  
  <pre><code>var list = connection.Table&lt;Contact&gt;().ToList();
  connection.UpdateAll(list ,true);
  </code></pre>
  
  <p>I can't see values in my PhoneNumbers and MailAddresses fields, while they are filled with serialized value in their blobbed fields.</p>
  
  <p>In addiction, trying to manually deserialize the blobbed fields, I get an exception from Json.net (ie. doing in this way):</p>
  
  <pre><code> foreach (Contact pc in list)
          {
              try
              {
                  Contact.PhoneNumber[] numbs = JsonConvert.DeserializeObject&lt;PhoneContact.PhoneNumber[]&gt;(pc.PhoneNumbersBlobbed);
              }
              catch {
                  ;
              }
          }
  </code></pre>
  
  <p>what am I wrong?
  Thank you</p>