title: How to achieve partial update in Entity Framework 5/6?
body: <p>I am working on Entity framework with database first approach and I came across below issue. </p>
  
  <p>I have a Customer table with columns col1, col2, col3 ,....,col8. I have created an entity for this table and this table has around 100 records already. Out of above 8 columns, col4 is marked as Non-null.</p>
  
  <pre><code>Class Customer
      {
           member col1;
           member col2;
           member col3;
           member col4;
           .
           .
           member col8;
      }
      class Main
      {
         //main logic to read data from database using EF 
         Customer obj = object of Customerwith values assigned to col1,col2 and col3 members
         obj.col2=some changed value.
         DBContext.SaveChanges(); //&lt;- throws an error stating it is expecting value of col4. 
  
      }
  </code></pre>
  
  <p>In my application, I am trying to read the one of the record using the stored procedure using EF and stored procedure only returns col1,col2 and col3.
  I am trying to save the modified value of col2 and trying to save back to database using DBContext. But it thows an error stating value of required field col4 is not provided. </p>
  
  <p><em>FYI: I have gone through couple of forums and question and  option to go with disabled verfication on SaveChanges is not feasible for me.</em></p>
  
  <p>Is there any other way through which I can achieve partial update?</p>