Change the IDENTITY property of a column, the column needs to be dropped and recreated
I am using EF Core 2.1
This was my initial model definition.
public class Customer //Parent
{
public int Id { get; set; }
public string Name { get; set; }
public string Email { get; set; }
public BankAccount BankAccount { get; set; }
}
public class BankAccount
{
public int Id { get; set; }
public string Branch { get; set; }
public string AcntNumber { get; set; }
public DateTime CreatedDate { get; set; }
public int CustomerId { get; set; }
public Customer Customer { get; set; }
}
But I realized having Id & CustomerId both is overhead as its One-to-One relation, I can update my BankAccount model definition as below.
public class BankAccount
{
public int Id { get; set; }
public string Branch { get; set; }
public string AcntNumber { get; set; }
public DateTime CreatedDate { get; set; }
public Customer Customer { get; set; }
}
While in DbContext class defined the principal entity as below.
HasOne(b => b.Customer).WithOne(c => c.BankAccount).HasForeignKey<BankAccount>(f => f.Id);
While running the update-database I am getting the below error.
System.InvalidOperationException: To change the IDENTITY property of a column, the column needs to be dropped and recreated.
However, ideally I should not but just get rid of this error, I deleted the column, constraints and as well table and then the complete database as well. But still the same error.
c# asp.net entity-framework entity-framework-core ef-core-2.1
edited Dec 21 '18 at 23:41
Erik Philips
41.2k692126
asked Nov 21 '18 at 8:44
Kgn-webKgn-web
2,06962764
add a comment |
I am using EF Core 2.1
This was my initial model definition.
public class Customer //Parent
{
public int Id { get; set; }
public string Name { get; set; }
public string Email { get; set; }
public BankAccount BankAccount { get; set; }
}
public class BankAccount
{
public int Id { get; set; }
public string Branch { get; set; }
public string AcntNumber { get; set; }
public DateTime CreatedDate { get; set; }
public int CustomerId { get; set; }
public Customer Customer { get; set; }
}
But I realized having Id & CustomerId both is overhead as its One-to-One relation, I can update my BankAccount model definition as below.
public class BankAccount
{
public int Id { get; set; }
public string Branch { get; set; }
public string AcntNumber { get; set; }
public DateTime CreatedDate { get; set; }
public Customer Customer { get; set; }
}
While in DbContext class defined the principal entity as below.
HasOne(b => b.Customer).WithOne(c => c.BankAccount).HasForeignKey<BankAccount>(f => f.Id);
While running the update-database I am getting the below error.
System.InvalidOperationException: To change the IDENTITY property of a column, the column needs to be dropped and recreated.
However, ideally I should not but just get rid of this error, I deleted the column, constraints and as well table and then the complete database as well. But still the same error.
c# asp.net entity-framework entity-framework-core ef-core-2.1
edited Dec 21 '18 at 23:41
Erik Philips
41.2k692126
asked Nov 21 '18 at 8:44
Kgn-webKgn-web
2,06962764
what do you mean by '...I realized having Id & CustomerId both is overhead as its One-to-One relation'? Id is the primary key and CustomerId is a foreign key so what's the overhead here?
– Elyas Esna
Nov 21 '18 at 9:47
@ElyasEsna,One Customer One BankAccount, so the Id in Customer entity could be used as FK & primary key in BankAccount entity
– Kgn-web
Nov 21 '18 at 9:51
seems to be the issue github.com/aspnet/EntityFrameworkCore/issues/7444 , which is an open issue in EF core.
– DevilSuichiro
Nov 21 '18 at 10:49
add a comment |
I am using EF Core 2.1
This was my initial model definition.
public class Customer //Parent
{
public int Id { get; set; }
public string Name { get; set; }
public string Email { get; set; }
public BankAccount BankAccount { get; set; }
}
public class BankAccount
{
public int Id { get; set; }
public string Branch { get; set; }
public string AcntNumber { get; set; }
public DateTime CreatedDate { get; set; }
public int CustomerId { get; set; }
public Customer Customer { get; set; }
}
But I realized having Id & CustomerId both is overhead as its One-to-One relation, I can update my BankAccount model definition as below.
public class BankAccount
{
public int Id { get; set; }
public string Branch { get; set; }
public string AcntNumber { get; set; }
public DateTime CreatedDate { get; set; }
public Customer Customer { get; set; }
}
While in DbContext class defined the principal entity as below.
HasOne(b => b.Customer).WithOne(c => c.BankAccount).HasForeignKey<BankAccount>(f => f.Id);
While running the update-database I am getting the below error.
System.InvalidOperationException: To change the IDENTITY property of a column, the column needs to be dropped and recreated.
However, ideally I should not but just get rid of this error, I deleted the column, constraints and as well table and then the complete database as well. But still the same error.
c# asp.net entity-framework entity-framework-core ef-core-2.1
edited Dec 21 '18 at 23:41
Erik Philips
41.2k692126
asked Nov 21 '18 at 8:44
Kgn-webKgn-web
2,06962764
I am using EF Core 2.1
This was my initial model definition.
public class Customer //Parent
{
public int Id { get; set; }
public string Name { get; set; }
public string Email { get; set; }
public BankAccount BankAccount { get; set; }
}
public class BankAccount
{
public int Id { get; set; }
public string Branch { get; set; }
public string AcntNumber { get; set; }
public DateTime CreatedDate { get; set; }
public int CustomerId { get; set; }
public Customer Customer { get; set; }
}
But I realized having Id & CustomerId both is overhead as its One-to-One relation, I can update my BankAccount model definition as below.
public class BankAccount
{
public int Id { get; set; }
public string Branch { get; set; }
public string AcntNumber { get; set; }
public DateTime CreatedDate { get; set; }
public Customer Customer { get; set; }
}
While in DbContext class defined the principal entity as below.
HasOne(b => b.Customer).WithOne(c => c.BankAccount).HasForeignKey<BankAccount>(f => f.Id);
While running the update-database I am getting the below error.
System.InvalidOperationException: To change the IDENTITY property of a column, the column needs to be dropped and recreated.
However, ideally I should not but just get rid of this error, I deleted the column, constraints and as well table and then the complete database as well. But still the same error.
c# asp.net entity-framework entity-framework-core ef-core-2.1
c# asp.net entity-framework entity-framework-core ef-core-2.1
edited Dec 21 '18 at 23:41
Erik Philips
41.2k692126
asked Nov 21 '18 at 8:44
Kgn-webKgn-web
2,06962764
edited Dec 21 '18 at 23:41
Erik Philips
41.2k692126
asked Nov 21 '18 at 8:44
Kgn-webKgn-web
2,06962764
edited Dec 21 '18 at 23:41
Erik Philips
41.2k692126
edited Dec 21 '18 at 23:41
Erik Philips
41.2k692126
edited Dec 21 '18 at 23:41
Erik Philips
41.2k692126
41.2k692126
asked Nov 21 '18 at 8:44
Kgn-webKgn-web
2,06962764
asked Nov 21 '18 at 8:44
Kgn-webKgn-web
2,06962764
asked Nov 21 '18 at 8:44
Kgn-webKgn-web
2,06962764
2,06962764
what do you mean by '...I realized having Id & CustomerId both is overhead as its One-to-One relation'? Id is the primary key and CustomerId is a foreign key so what's the overhead here?
– Elyas Esna
Nov 21 '18 at 9:47
@ElyasEsna,One Customer One BankAccount, so the Id in Customer entity could be used as FK & primary key in BankAccount entity
– Kgn-web
Nov 21 '18 at 9:51
seems to be the issue github.com/aspnet/EntityFrameworkCore/issues/7444 , which is an open issue in EF core.
– DevilSuichiro
Nov 21 '18 at 10:49
add a comment |
what do you mean by '...I realized having Id & CustomerId both is overhead as its One-to-One relation'? Id is the primary key and CustomerId is a foreign key so what's the overhead here?
– Elyas Esna
Nov 21 '18 at 9:47
@ElyasEsna,One Customer One BankAccount, so the Id in Customer entity could be used as FK & primary key in BankAccount entity
– Kgn-web
Nov 21 '18 at 9:51
seems to be the issue github.com/aspnet/EntityFrameworkCore/issues/7444 , which is an open issue in EF core.
– DevilSuichiro
Nov 21 '18 at 10:49
what do you mean by '...I realized having Id & CustomerId both is overhead as its One-to-One relation'? Id is the primary key and CustomerId is a foreign key so what's the overhead here?
– Elyas Esna
Nov 21 '18 at 9:47
what do you mean by '...I realized having Id & CustomerId both is overhead as its One-to-One relation'? Id is the primary key and CustomerId is a foreign key so what's the overhead here?
– Elyas Esna
Nov 21 '18 at 9:47
@ElyasEsna,
One Customer One BankAccount, so the Id in Customer entity could be used as FK & primary key in BankAccount entity– Kgn-web
Nov 21 '18 at 9:51
@ElyasEsna,
One Customer One BankAccount, so the Id in Customer entity could be used as FK & primary key in BankAccount entity– Kgn-web
Nov 21 '18 at 9:51
seems to be the issue github.com/aspnet/EntityFrameworkCore/issues/7444 , which is an open issue in EF core.
– DevilSuichiro
Nov 21 '18 at 10:49
seems to be the issue github.com/aspnet/EntityFrameworkCore/issues/7444 , which is an open issue in EF core.
– DevilSuichiro
Nov 21 '18 at 10:49
add a comment |
0
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%2f53408175%2fchange-the-identity-property-of-a-column-the-column-needs-to-be-dropped-and-rec%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
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.
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%2f53408175%2fchange-the-identity-property-of-a-column-the-column-needs-to-be-dropped-and-rec%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
what do you mean by '...I realized having Id & CustomerId both is overhead as its One-to-One relation'? Id is the primary key and CustomerId is a foreign key so what's the overhead here?
– Elyas Esna
Nov 21 '18 at 9:47
@ElyasEsna,
One Customer One BankAccount, so the Id in Customer entity could be used as FK & primary key in BankAccount entity– Kgn-web
Nov 21 '18 at 9:51
seems to be the issue github.com/aspnet/EntityFrameworkCore/issues/7444 , which is an open issue in EF core.
– DevilSuichiro
Nov 21 '18 at 10:49