Mixing
xamarin app crashes when the primary key is added to the existing sqlite table
0
I have a table named "Log" with some string and int columns.
App is installed and working on a device.
I recently added primary key, to the existing int column as follows.
[PrimaryKey, AutoIncrement]
public int MobileID { get; set; }
If i update the old app with the newly built, then it crashes.
How to handle this addition of primary key?
Thanks
c# sqlite xamarin primary-key
asked Jan 3 at 0:23
Sai SunkariSai Sunkari
6410
add a comment |
0
I have a table named "Log" with some string and int columns.
App is installed and working on a device.
I recently added primary key, to the existing int column as follows.
[PrimaryKey, AutoIncrement]
public int MobileID { get; set; }
If i update the old app with the newly built, then it crashes.
How to handle this addition of primary key?
Thanks
c# sqlite xamarin primary-key
asked Jan 3 at 0:23
Sai SunkariSai Sunkari
6410
if you change the schema of an existing table, you'll need to take some steps to update the table schema when the app is updated. It won't magically do that on its own.
– Jason
Jan 3 at 0:28
can you send me an example link or any good article?
– Sai Sunkari
Jan 3 at 0:38
@sai - In new release, you can get the current data from the above mentioned table to a temp table and delete and recreate the table and insert the data into the table from temp table. This should be a one time process.
– hashimks
Jan 3 at 6:07
thanks @hashimks
– Sai Sunkari
Jan 8 at 22:47
add a comment |
0
0
0
I have a table named "Log" with some string and int columns.
App is installed and working on a device.
I recently added primary key, to the existing int column as follows.
[PrimaryKey, AutoIncrement]
public int MobileID { get; set; }
If i update the old app with the newly built, then it crashes.
How to handle this addition of primary key?
Thanks
c# sqlite xamarin primary-key
asked Jan 3 at 0:23
Sai SunkariSai Sunkari
6410
I have a table named "Log" with some string and int columns.
App is installed and working on a device.
I recently added primary key, to the existing int column as follows.
[PrimaryKey, AutoIncrement]
public int MobileID { get; set; }
If i update the old app with the newly built, then it crashes.
How to handle this addition of primary key?
Thanks
c# sqlite xamarin primary-key
c# sqlite xamarin primary-key
asked Jan 3 at 0:23
Sai SunkariSai Sunkari
6410
asked Jan 3 at 0:23
Sai SunkariSai Sunkari
6410
asked Jan 3 at 0:23
Sai SunkariSai Sunkari
6410
asked Jan 3 at 0:23
Sai SunkariSai Sunkari
6410
asked Jan 3 at 0:23
Sai SunkariSai Sunkari
6410
6410
if you change the schema of an existing table, you'll need to take some steps to update the table schema when the app is updated. It won't magically do that on its own.
– Jason
Jan 3 at 0:28
can you send me an example link or any good article?
– Sai Sunkari
Jan 3 at 0:38
@sai - In new release, you can get the current data from the above mentioned table to a temp table and delete and recreate the table and insert the data into the table from temp table. This should be a one time process.
– hashimks
Jan 3 at 6:07
thanks @hashimks
– Sai Sunkari
Jan 8 at 22:47
add a comment |
if you change the schema of an existing table, you'll need to take some steps to update the table schema when the app is updated. It won't magically do that on its own.
– Jason
Jan 3 at 0:28
can you send me an example link or any good article?
– Sai Sunkari
Jan 3 at 0:38
@sai - In new release, you can get the current data from the above mentioned table to a temp table and delete and recreate the table and insert the data into the table from temp table. This should be a one time process.
– hashimks
Jan 3 at 6:07
thanks @hashimks
– Sai Sunkari
Jan 8 at 22:47
if you change the schema of an existing table, you'll need to take some steps to update the table schema when the app is updated. It won't magically do that on its own.
– Jason
Jan 3 at 0:28
if you change the schema of an existing table, you'll need to take some steps to update the table schema when the app is updated. It won't magically do that on its own.
– Jason
Jan 3 at 0:28
can you send me an example link or any good article?
– Sai Sunkari
Jan 3 at 0:38
can you send me an example link or any good article?
– Sai Sunkari
Jan 3 at 0:38
@sai - In new release, you can get the current data from the above mentioned table to a temp table and delete and recreate the table and insert the data into the table from temp table. This should be a one time process.
– hashimks
Jan 3 at 6:07
@sai - In new release, you can get the current data from the above mentioned table to a temp table and delete and recreate the table and insert the data into the table from temp table. This should be a one time process.
– hashimks
Jan 3 at 6:07
thanks @hashimks
– Sai Sunkari
Jan 8 at 22:47
thanks @hashimks
– Sai Sunkari
Jan 8 at 22:47
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
});
}
});
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%2f54014888%2fxamarin-app-crashes-when-the-primary-key-is-added-to-the-existing-sqlite-table%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
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.
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%2f54014888%2fxamarin-app-crashes-when-the-primary-key-is-added-to-the-existing-sqlite-table%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
if you change the schema of an existing table, you'll need to take some steps to update the table schema when the app is updated. It won't magically do that on its own.
– Jason
Jan 3 at 0:28
can you send me an example link or any good article?
– Sai Sunkari
Jan 3 at 0:38
@sai - In new release, you can get the current data from the above mentioned table to a temp table and delete and recreate the table and insert the data into the table from temp table. This should be a one time process.
– hashimks
Jan 3 at 6:07
thanks @hashimks
– Sai Sunkari
Jan 8 at 22:47