xamarin.forms SQLite database missing in debug after device disconnected and reconnected to USB











up vote
0
down vote

favorite












may be somebody can shed the light how to solve the following problem:
I am writing app with xamarin forms using SQLite for storing local data.
at some point I found, that sometimes my SQLite database missing . couple of days I was searching through internet trying to find the solution and checking everything ..
today I found, that it happens after I disconnect device from USB, connect it back and trying to start debugging



configuration.
windows 10 pc (10.0.17134.407), MS VS 15.9.2, Xamarin Forms 3.4.0.1008975 , SQLite-net-pcl 1.5.231 . device Samsung S7edge (SM-G935FD) with android 8.0.0



piece of code



    string dbfname = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.Personal), "dbname.db");    
if (!File.Exists(dbfname))
{
System.Diagnostics.Debug.WriteLine("no database found, creating new");
IsNewDB = true;
}
else
{
IsNewDB = false;
}


working as expected on a device during numerous debug session restarts, working on simulator, working on a device disconnected from computer. but once I connect it to computer and starts debugging session file.exists returns false



with adb I'm seeing that database related files got deleted while visual studio deploys project to device. any idea what I am doing wrong ?
option to preserve app data between deploys checked.



thank you in advance.



ish










share|improve this question
























  • for some reason after USB reconnection msbuild completely reinstall application .. I think that here all data is removed 2>[BEGIN] Removing previous version of application 2>[MESSAGE] Removing previous version of application... 2>Removing previous version of application... 2>DEBUG RunShellCommand ce12160cd043882605 pm uninstall -k "com.companyname.Application" 2>DEBUG RunShellCommand ce12160cd043882605 pm uninstall -k "com.companyname.Application" 2>TASK: UninstallPackage pm uninstall -k "com.companyname.Application" completed?:Success 2>
    – ish1313
    Nov 23 at 9:27

















up vote
0
down vote

favorite












may be somebody can shed the light how to solve the following problem:
I am writing app with xamarin forms using SQLite for storing local data.
at some point I found, that sometimes my SQLite database missing . couple of days I was searching through internet trying to find the solution and checking everything ..
today I found, that it happens after I disconnect device from USB, connect it back and trying to start debugging



configuration.
windows 10 pc (10.0.17134.407), MS VS 15.9.2, Xamarin Forms 3.4.0.1008975 , SQLite-net-pcl 1.5.231 . device Samsung S7edge (SM-G935FD) with android 8.0.0



piece of code



    string dbfname = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.Personal), "dbname.db");    
if (!File.Exists(dbfname))
{
System.Diagnostics.Debug.WriteLine("no database found, creating new");
IsNewDB = true;
}
else
{
IsNewDB = false;
}


working as expected on a device during numerous debug session restarts, working on simulator, working on a device disconnected from computer. but once I connect it to computer and starts debugging session file.exists returns false



with adb I'm seeing that database related files got deleted while visual studio deploys project to device. any idea what I am doing wrong ?
option to preserve app data between deploys checked.



thank you in advance.



ish










share|improve this question
























  • for some reason after USB reconnection msbuild completely reinstall application .. I think that here all data is removed 2>[BEGIN] Removing previous version of application 2>[MESSAGE] Removing previous version of application... 2>Removing previous version of application... 2>DEBUG RunShellCommand ce12160cd043882605 pm uninstall -k "com.companyname.Application" 2>DEBUG RunShellCommand ce12160cd043882605 pm uninstall -k "com.companyname.Application" 2>TASK: UninstallPackage pm uninstall -k "com.companyname.Application" completed?:Success 2>
    – ish1313
    Nov 23 at 9:27















up vote
0
down vote

favorite









up vote
0
down vote

favorite











may be somebody can shed the light how to solve the following problem:
I am writing app with xamarin forms using SQLite for storing local data.
at some point I found, that sometimes my SQLite database missing . couple of days I was searching through internet trying to find the solution and checking everything ..
today I found, that it happens after I disconnect device from USB, connect it back and trying to start debugging



configuration.
windows 10 pc (10.0.17134.407), MS VS 15.9.2, Xamarin Forms 3.4.0.1008975 , SQLite-net-pcl 1.5.231 . device Samsung S7edge (SM-G935FD) with android 8.0.0



piece of code



    string dbfname = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.Personal), "dbname.db");    
if (!File.Exists(dbfname))
{
System.Diagnostics.Debug.WriteLine("no database found, creating new");
IsNewDB = true;
}
else
{
IsNewDB = false;
}


working as expected on a device during numerous debug session restarts, working on simulator, working on a device disconnected from computer. but once I connect it to computer and starts debugging session file.exists returns false



with adb I'm seeing that database related files got deleted while visual studio deploys project to device. any idea what I am doing wrong ?
option to preserve app data between deploys checked.



thank you in advance.



ish










share|improve this question















may be somebody can shed the light how to solve the following problem:
I am writing app with xamarin forms using SQLite for storing local data.
at some point I found, that sometimes my SQLite database missing . couple of days I was searching through internet trying to find the solution and checking everything ..
today I found, that it happens after I disconnect device from USB, connect it back and trying to start debugging



configuration.
windows 10 pc (10.0.17134.407), MS VS 15.9.2, Xamarin Forms 3.4.0.1008975 , SQLite-net-pcl 1.5.231 . device Samsung S7edge (SM-G935FD) with android 8.0.0



piece of code



    string dbfname = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.Personal), "dbname.db");    
if (!File.Exists(dbfname))
{
System.Diagnostics.Debug.WriteLine("no database found, creating new");
IsNewDB = true;
}
else
{
IsNewDB = false;
}


working as expected on a device during numerous debug session restarts, working on simulator, working on a device disconnected from computer. but once I connect it to computer and starts debugging session file.exists returns false



with adb I'm seeing that database related files got deleted while visual studio deploys project to device. any idea what I am doing wrong ?
option to preserve app data between deploys checked.



thank you in advance.



ish







c# android sqlite xamarin.forms






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Nov 22 at 17:07

























asked Nov 22 at 16:32









ish1313

12




12












  • for some reason after USB reconnection msbuild completely reinstall application .. I think that here all data is removed 2>[BEGIN] Removing previous version of application 2>[MESSAGE] Removing previous version of application... 2>Removing previous version of application... 2>DEBUG RunShellCommand ce12160cd043882605 pm uninstall -k "com.companyname.Application" 2>DEBUG RunShellCommand ce12160cd043882605 pm uninstall -k "com.companyname.Application" 2>TASK: UninstallPackage pm uninstall -k "com.companyname.Application" completed?:Success 2>
    – ish1313
    Nov 23 at 9:27




















  • for some reason after USB reconnection msbuild completely reinstall application .. I think that here all data is removed 2>[BEGIN] Removing previous version of application 2>[MESSAGE] Removing previous version of application... 2>Removing previous version of application... 2>DEBUG RunShellCommand ce12160cd043882605 pm uninstall -k "com.companyname.Application" 2>DEBUG RunShellCommand ce12160cd043882605 pm uninstall -k "com.companyname.Application" 2>TASK: UninstallPackage pm uninstall -k "com.companyname.Application" completed?:Success 2>
    – ish1313
    Nov 23 at 9:27


















for some reason after USB reconnection msbuild completely reinstall application .. I think that here all data is removed 2>[BEGIN] Removing previous version of application 2>[MESSAGE] Removing previous version of application... 2>Removing previous version of application... 2>DEBUG RunShellCommand ce12160cd043882605 pm uninstall -k "com.companyname.Application" 2>DEBUG RunShellCommand ce12160cd043882605 pm uninstall -k "com.companyname.Application" 2>TASK: UninstallPackage pm uninstall -k "com.companyname.Application" completed?:Success 2>
– ish1313
Nov 23 at 9:27






for some reason after USB reconnection msbuild completely reinstall application .. I think that here all data is removed 2>[BEGIN] Removing previous version of application 2>[MESSAGE] Removing previous version of application... 2>Removing previous version of application... 2>DEBUG RunShellCommand ce12160cd043882605 pm uninstall -k "com.companyname.Application" 2>DEBUG RunShellCommand ce12160cd043882605 pm uninstall -k "com.companyname.Application" 2>TASK: UninstallPackage pm uninstall -k "com.companyname.Application" completed?:Success 2>
– ish1313
Nov 23 at 9:27



















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


















StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53435082%2fxamarin-forms-sqlite-database-missing-in-debug-after-device-disconnected-and-rec%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














StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53435082%2fxamarin-forms-sqlite-database-missing-in-debug-after-device-disconnected-and-rec%23new-answer', 'question_page');
}
);

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







Popular posts from this blog

What visual should I use to simply compare current year value vs last year in Power BI desktop

Alexandru Averescu

Trompette piccolo