title: How to archive the SQL data record in File system and restore it back when required?
body: <p>I need a C# program to read the a record (stored in various tables) from the database and store it in the File System (in some format) and remove the record from the database. In other words, archiving database record on File System. It is also required to restore this record back when needed. 
  So how can i achieve this? In which format I gonna go to store the data in File System. How can i restore it back when needed. </p>
  
  <p>PS: My data is stored in various different tables and data types are int, text, varchar, datetime, images.</p>