Adding a column to the model - The entity type R is not part of the model for the current context
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?
entity-framework
asked Nov 12 at 15:00
Old Geezer
3,791114998
add a comment |
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?
entity-framework
asked Nov 12 at 15:00
Old Geezer
3,791114998
add a comment |
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?
entity-framework
asked Nov 12 at 15:00
Old Geezer
3,791114998
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?
entity-framework
entity-framework
asked Nov 12 at 15:00
Old Geezer
3,791114998
asked Nov 12 at 15:00
Old Geezer
3,791114998
edited Nov 13 at 5:45
asked Nov 12 at 15:00
Old Geezer
3,791114998
asked Nov 12 at 15:00
Old Geezer
3,791114998
asked Nov 12 at 15:00
Old Geezer
3,791114998
3,791114998
add a comment |
add a comment |
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53264836%2fadding-a-column-to-the-model-the-entity-type-r-is-not-part-of-the-model-for-th%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53264836%2fadding-a-column-to-the-model-the-entity-type-r-is-not-part-of-the-model-for-th%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
