title: From a web app, I have to store a file in MS SQL 2008 DB. Do you recommend storing it as xml string or as a blob?
body: <p>The web app has to let a user browse a csv file of around 100'000 lines.
  We have to show the contents of the file on the screen so the user can see what has been loaded.
  Then the user will perform some actions on the screen (e.g. add their details)
  We need to store the file in database and associate it with the user record</p>
  
  <p>The contents and the format of the file will change per user.
  Therefore, I cannot create a static table in MS SQL DB for it.</p>
  
  <p>Do you recommend loading this file as a blob in MS SQL 2008 DB or should I load the file, create a plain class (in C#) object that matches the file, serialise it and then store it as the xml file.  Later if user wants to see it, I can read the xml string from DB, deserialise it to the object, write logic that takes the object and creates a csv file?</p>
  
  <p>Is there another approach?  Is storing as xml string better than storing as blob?</p>