title: Store c# object in sql server database
body: <p>I would like to store a c# object in SQL server. I thought about the following options:</p>
  
  <ol>
  <li>Read object byte memory stream and save them into the database (but
  not readable in sql)</li>
  <li>Json, readable, easy to convert but what data type? (only a datatype for sql 2016)</li>
  <li>XML, a bit less readable, easy to convert, there is an XML dataType</li>
  </ol>
  
  <p>What's the best practice to store a C# object in a sql column and why?
  I am using SQL 2014, so I think option 3 is the best?</p>
  
  <p>Edit:
  Note: it's not data to query, I just want to load a object which I have cached into a c# object in memory. And perform some logic on that in c#. It just takes a while to get the data from another database, therefore I save all my data in a custom object. Therefore I don't think I should use ORM</p>