Error 3031: Problem in mapping fragments starting at line… nullable column
16-Dec-1111 Leave a comment
Error 3031: Problem in mapping fragments starting at line… nullable column
In SQL I added a column to a table and initially had the column as Not Nullable. I then updated a view to use the new column. I then updated Entity Framework model from the database. I then changed my mind and made the column nullable. I then updated EF model once again and it would not compile. No-manner of updating column Nullable properties worked.
After some reading suggested this was a bug in EF. As a precaution I updated the view in SQL to refresh the schema went to EF and removed and added it again.