Error in Entity Framework in code first pattern
up vote
0
down vote
favorite
When I try to execute the update-database command, I get the error:
Foreign key 'FK_dbo.HomeWork_dbo.Students_StudentID' references invalid column 'ID' in referenced table 'dbo.Students'.
This is my homework class inherited by the parent class containing a few properties, like ID, etc.
public class HomeWork: Commons_Parent
{
public DateTime DateCreated { get; set; }
public string Content { get; set; }
public string Grade { get; set; }
public int StudentID { get; set; }
public Student Student { get; set; }
}
This is my Student class inherited by the class Person which hold properties like Name, etc.
public class Student: Person
{
public DateTime DateOfBirth { get; set; }
public Class Std_Class { get; set; }
public int Class_ID { get; set; }
public List<Parent> Parents { get; set; }
}
c# entity-framework-6
edited Nov 13 at 5:07
Peter Mortensen
13.4k1983111
asked Nov 12 at 6:04
Muamber Khan
11
|
show 1 more comment
up vote
0
down vote
favorite
When I try to execute the update-database command, I get the error:
Foreign key 'FK_dbo.HomeWork_dbo.Students_StudentID' references invalid column 'ID' in referenced table 'dbo.Students'.
This is my homework class inherited by the parent class containing a few properties, like ID, etc.
public class HomeWork: Commons_Parent
{
public DateTime DateCreated { get; set; }
public string Content { get; set; }
public string Grade { get; set; }
public int StudentID { get; set; }
public Student Student { get; set; }
}
This is my Student class inherited by the class Person which hold properties like Name, etc.
public class Student: Person
{
public DateTime DateOfBirth { get; set; }
public Class Std_Class { get; set; }
public int Class_ID { get; set; }
public List<Parent> Parents { get; set; }
}
c# entity-framework-6
edited Nov 13 at 5:07
Peter Mortensen
13.4k1983111
asked Nov 12 at 6:04
Muamber Khan
11
@Llazar here is the code
– Muamber Khan
Nov 12 at 6:05
It would be better if you could share the error by editing your question.
– ichthyocentaurs
Nov 12 at 6:06
@ichthyocentaurs thanks for your reply, i have shared the code if want more details plz let me know
– Muamber Khan
Nov 12 at 6:09
@Muamber Khan Could you please share the update database command that you're running, for further investigation.
– Prasan Karunarathne
Nov 12 at 6:32
It would help if you add the last migration code
– roozbeh S
Nov 12 at 6:55
|
show 1 more comment
up vote
0
down vote
favorite
up vote
0
down vote
favorite
When I try to execute the update-database command, I get the error:
Foreign key 'FK_dbo.HomeWork_dbo.Students_StudentID' references invalid column 'ID' in referenced table 'dbo.Students'.
This is my homework class inherited by the parent class containing a few properties, like ID, etc.
public class HomeWork: Commons_Parent
{
public DateTime DateCreated { get; set; }
public string Content { get; set; }
public string Grade { get; set; }
public int StudentID { get; set; }
public Student Student { get; set; }
}
This is my Student class inherited by the class Person which hold properties like Name, etc.
public class Student: Person
{
public DateTime DateOfBirth { get; set; }
public Class Std_Class { get; set; }
public int Class_ID { get; set; }
public List<Parent> Parents { get; set; }
}
c# entity-framework-6
edited Nov 13 at 5:07
Peter Mortensen
13.4k1983111
asked Nov 12 at 6:04
Muamber Khan
11
When I try to execute the update-database command, I get the error:
Foreign key 'FK_dbo.HomeWork_dbo.Students_StudentID' references invalid column 'ID' in referenced table 'dbo.Students'.
This is my homework class inherited by the parent class containing a few properties, like ID, etc.
public class HomeWork: Commons_Parent
{
public DateTime DateCreated { get; set; }
public string Content { get; set; }
public string Grade { get; set; }
public int StudentID { get; set; }
public Student Student { get; set; }
}
This is my Student class inherited by the class Person which hold properties like Name, etc.
public class Student: Person
{
public DateTime DateOfBirth { get; set; }
public Class Std_Class { get; set; }
public int Class_ID { get; set; }
public List<Parent> Parents { get; set; }
}
c# entity-framework-6
c# entity-framework-6
edited Nov 13 at 5:07
Peter Mortensen
13.4k1983111
asked Nov 12 at 6:04
Muamber Khan
11
edited Nov 13 at 5:07
Peter Mortensen
13.4k1983111
asked Nov 12 at 6:04
Muamber Khan
11
edited Nov 13 at 5:07
Peter Mortensen
13.4k1983111
edited Nov 13 at 5:07
Peter Mortensen
13.4k1983111
edited Nov 13 at 5:07
Peter Mortensen
13.4k1983111
13.4k1983111
asked Nov 12 at 6:04
Muamber Khan
11
asked Nov 12 at 6:04
Muamber Khan
11
asked Nov 12 at 6:04
Muamber Khan
11
11
@Llazar here is the code
– Muamber Khan
Nov 12 at 6:05
It would be better if you could share the error by editing your question.
– ichthyocentaurs
Nov 12 at 6:06
@ichthyocentaurs thanks for your reply, i have shared the code if want more details plz let me know
– Muamber Khan
Nov 12 at 6:09
@Muamber Khan Could you please share the update database command that you're running, for further investigation.
– Prasan Karunarathne
Nov 12 at 6:32
It would help if you add the last migration code
– roozbeh S
Nov 12 at 6:55
|
show 1 more comment
@Llazar here is the code
– Muamber Khan
Nov 12 at 6:05
It would be better if you could share the error by editing your question.
– ichthyocentaurs
Nov 12 at 6:06
@ichthyocentaurs thanks for your reply, i have shared the code if want more details plz let me know
– Muamber Khan
Nov 12 at 6:09
@Muamber Khan Could you please share the update database command that you're running, for further investigation.
– Prasan Karunarathne
Nov 12 at 6:32
It would help if you add the last migration code
– roozbeh S
Nov 12 at 6:55
@Llazar here is the code
– Muamber Khan
Nov 12 at 6:05
@Llazar here is the code
– Muamber Khan
Nov 12 at 6:05
It would be better if you could share the error by editing your question.
– ichthyocentaurs
Nov 12 at 6:06
It would be better if you could share the error by editing your question.
– ichthyocentaurs
Nov 12 at 6:06
@ichthyocentaurs thanks for your reply, i have shared the code if want more details plz let me know
– Muamber Khan
Nov 12 at 6:09
@ichthyocentaurs thanks for your reply, i have shared the code if want more details plz let me know
– Muamber Khan
Nov 12 at 6:09
@Muamber Khan Could you please share the update database command that you're running, for further investigation.
– Prasan Karunarathne
Nov 12 at 6:32
@Muamber Khan Could you please share the update database command that you're running, for further investigation.
– Prasan Karunarathne
Nov 12 at 6:32
It would help if you add the last migration code
– roozbeh S
Nov 12 at 6:55
It would help if you add the last migration code
– roozbeh S
Nov 12 at 6:55
|
show 1 more 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',
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
});
}
});
draft saved
draft discarded
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%2f53256631%2ferror-in-entity-framework-in-code-first-pattern%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
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.
draft saved
draft discarded
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%2f53256631%2ferror-in-entity-framework-in-code-first-pattern%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
@Llazar here is the code
– Muamber Khan
Nov 12 at 6:05
It would be better if you could share the error by editing your question.
– ichthyocentaurs
Nov 12 at 6:06
@ichthyocentaurs thanks for your reply, i have shared the code if want more details plz let me know
– Muamber Khan
Nov 12 at 6:09
@Muamber Khan Could you please share the update database command that you're running, for further investigation.
– Prasan Karunarathne
Nov 12 at 6:32
It would help if you add the last migration code
– roozbeh S
Nov 12 at 6:55