title: Saving XML file in a database along with other fields to SQL Server using Entity Framework
body: <p>I have the PersonDetails table in the database whose fields are given below :</p>
  
  <pre><code>ID    AutoGenerated field
  
  PersonName  Int Not null
  
  FailureDetails  XML not null
  </code></pre>
  
  <p>I have an xml file in my local drive D:\personFailureDetails.xml which needs to be saved in PersonDetails table along with other fields.</p>
  
  <p>I am using entity framework to retieve and insert data to database.</p>
  
  <p>Which is the best way to insert values into “PersonDetails” entity? </p>
  
  <p>Which datatype is available to get the xml file to be stored in entity to be inserted into the “PersonDetails” table?</p>