Dfyjkt

I have a working EF app. Then I needed to add a column updatedBy to table R. I added it to the table in SQL Server, and it is:

updatedBy (nvarchar(50), null)

I added three lines related to updatedBy in the edmx file as shown by *** below:

<edmx:StorageModels>
 <Schema Namespace=.... >
 <EntityType Name="R">
 *** <Property Name="updatedBy" Type="nvarchar" MaxLength="50" Nullable="true" />
 ...
 </Schema>
</edmx:StorageModels>

<edmx:ConceptualModels>
 <Schema Namespace="... >
 <EntityType Name="recontractRequest">
*** <Property Name="updatedBy" Type="String" Nullable="true" MaxLength="50" FixedLength="false" Unicode="true" />
 </EntityType>
 </Schema>
</edmx:ConceptualModels>

<edmx:Mappings>
 <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2009/11/mapping/cs">
 <EntityContainerMapping ... >
 <EntitySetMapping Name="Rs">
 <EntityTypeMapping TypeName="myModel.R">
 <MappingFragment StoreEntitySet="Rs">
 *** <ScalarProperty Name="updatedBy" ColumnName="updatedBy" />
 ...
 </MappingFragment>
 </EntityTypeMapping>
 </EntitySetMapping>

Other than the above, I made no reference to updatedBy anywhere in my code, and made no other changes to the version that was running fine. The new code compiles fine. But the moment existing code that uses db.Rs is hit, for example:

var rr = from r in db.Rs select new Q x = r.someOtherColumn .ToList();

I get:

The entity type R is not part of the model for the current context

The moment I removed those three lines from the edmx file, it runs fine again. What is causing the error? Is it caused by a mismatch between one or more properties of the column in SQL Server vis-a-vis the model? Why is it so difficult to just add a column to the application?