title: The "X" property on "Y" could not be set to a 'null' value. You must set this property to a non-null value of type 'Int32'
body: <p>When I run my application and I click a specific button I get the error:</p>
  
  <pre><code>"The "X" property on "Y" could not be set to a 'null' value. You must set this property to a non-null value of type 'Int32'."
  </code></pre>
  
  <p>Cool so I go to my Entity project, go to Y table, find X column, right-click and go to X's properties and find that Nullable is set to False.</p>
  
  <p>I verify in SQL that in Y table, X is set to allow nulls, and it is.</p>
  
  <p>I then go back to my Entity project, set Nullable to True, save and build and I receive:</p>
  
  <pre><code>Error 3031: Problem in mapping fragments starting at line 4049:Non-nullable column "X" in table "Y" is mapped to a nullable entity property.
  </code></pre>
  
  <p>I've heard that deleting the table from the .edmx file and then re-adding it is a possibility but have never done that and don't understand the implications enough to feel comfortable in doing that.</p>
  
  <p>I've heard that it could be in the view, could be in the stored procedure...</p>
  
  <p>Also have heard that this is a bug.</p>
  
  <p>Has anyone come across this and found an "across the board" fix or somewhat of a road map of sorts on where to look for this error?</p>
  
  <p>Thanks!</p>