Updating Existing migration in EF6
I am using Entity Framework, i have already applied 23 migrations, now i have a migration at #14, which is a stored procedure and now i want to make updates to that stored procedure.
I am not sure how i shall edit the existing migration at #14, could anyone suggest best method to update the migration #14.
I tried add-migration "[exact name of the migration at #14]"
but that does not edits that migration, rather creates new migration.
Is there any commands which would edit that migration and then i can make the edits to that migration.
asp.net entity-framework-6 ef-migrations
add a comment |
I am using Entity Framework, i have already applied 23 migrations, now i have a migration at #14, which is a stored procedure and now i want to make updates to that stored procedure.
I am not sure how i shall edit the existing migration at #14, could anyone suggest best method to update the migration #14.
I tried add-migration "[exact name of the migration at #14]"
but that does not edits that migration, rather creates new migration.
Is there any commands which would edit that migration and then i can make the edits to that migration.
asp.net entity-framework-6 ef-migrations
add a comment |
I am using Entity Framework, i have already applied 23 migrations, now i have a migration at #14, which is a stored procedure and now i want to make updates to that stored procedure.
I am not sure how i shall edit the existing migration at #14, could anyone suggest best method to update the migration #14.
I tried add-migration "[exact name of the migration at #14]"
but that does not edits that migration, rather creates new migration.
Is there any commands which would edit that migration and then i can make the edits to that migration.
asp.net entity-framework-6 ef-migrations
I am using Entity Framework, i have already applied 23 migrations, now i have a migration at #14, which is a stored procedure and now i want to make updates to that stored procedure.
I am not sure how i shall edit the existing migration at #14, could anyone suggest best method to update the migration #14.
I tried add-migration "[exact name of the migration at #14]"
but that does not edits that migration, rather creates new migration.
Is there any commands which would edit that migration and then i can make the edits to that migration.
asp.net entity-framework-6 ef-migrations
asp.net entity-framework-6 ef-migrations
asked Nov 27 '18 at 11:02
AbbasAbbas
2,1002580142
2,1002580142
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
You shouldn't edit it. Migrations should be considered append-only. In the case of a stored procedure editing the existing migration would also introduce the problem that the schema at the time may not correspond to the schema that the stored procedure code expects.
You should add a new migration with an ALTER PROCEDURE
statement updating the code.
Thanks Jonas, Appreciated
– Abbas
Nov 27 '18 at 12:35
add a comment |
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%2f53498217%2fupdating-existing-migration-in-ef6%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
You shouldn't edit it. Migrations should be considered append-only. In the case of a stored procedure editing the existing migration would also introduce the problem that the schema at the time may not correspond to the schema that the stored procedure code expects.
You should add a new migration with an ALTER PROCEDURE
statement updating the code.
Thanks Jonas, Appreciated
– Abbas
Nov 27 '18 at 12:35
add a comment |
You shouldn't edit it. Migrations should be considered append-only. In the case of a stored procedure editing the existing migration would also introduce the problem that the schema at the time may not correspond to the schema that the stored procedure code expects.
You should add a new migration with an ALTER PROCEDURE
statement updating the code.
Thanks Jonas, Appreciated
– Abbas
Nov 27 '18 at 12:35
add a comment |
You shouldn't edit it. Migrations should be considered append-only. In the case of a stored procedure editing the existing migration would also introduce the problem that the schema at the time may not correspond to the schema that the stored procedure code expects.
You should add a new migration with an ALTER PROCEDURE
statement updating the code.
You shouldn't edit it. Migrations should be considered append-only. In the case of a stored procedure editing the existing migration would also introduce the problem that the schema at the time may not correspond to the schema that the stored procedure code expects.
You should add a new migration with an ALTER PROCEDURE
statement updating the code.
answered Nov 27 '18 at 11:05
Jonas HøghJonas Høgh
7,30311737
7,30311737
Thanks Jonas, Appreciated
– Abbas
Nov 27 '18 at 12:35
add a comment |
Thanks Jonas, Appreciated
– Abbas
Nov 27 '18 at 12:35
Thanks Jonas, Appreciated
– Abbas
Nov 27 '18 at 12:35
Thanks Jonas, Appreciated
– Abbas
Nov 27 '18 at 12:35
add a comment |
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%2f53498217%2fupdating-existing-migration-in-ef6%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