How to deploy c# windows form with sqlite database?
I'm using visual studio 2015. I have the sqlite database in the solution explorer. I've also added the sqlite data base under Application Files. But when I deploy, I think a new database is being created every time the app is opened instead of using the existing database. I'm getting an exception that a certain table was not found. I've used this "Data Source=my_database.sqlite;Version=3;" relative path in the connection string. How do I make the application to use the existing database instead of creating new ones? Thanks in advance.
c# winforms sqlite visual-studio-2015 sqlite3
asked Nov 13 '18 at 8:49
amith_ajithamith_ajith
14
add a comment |
I'm using visual studio 2015. I have the sqlite database in the solution explorer. I've also added the sqlite data base under Application Files. But when I deploy, I think a new database is being created every time the app is opened instead of using the existing database. I'm getting an exception that a certain table was not found. I've used this "Data Source=my_database.sqlite;Version=3;" relative path in the connection string. How do I make the application to use the existing database instead of creating new ones? Thanks in advance.
c# winforms sqlite visual-studio-2015 sqlite3
asked Nov 13 '18 at 8:49
amith_ajithamith_ajith
14
This sounds like your DB file is not found. Check the path to the DB in the connection string. Try to set it absolute. If it works, your relative path is wrong and doesn't point to your db.
– Jürgen Müller
Nov 13 '18 at 9:25
It works when it is absolute. But how come the relative path works when it is debug mode and doesn't work in release mode?
– amith_ajith
Nov 13 '18 at 15:02
Your debug and release are not in the same folder. Release will work with:my_database.sqlitebut debug with....my_database.sqlitedepending on where your database is located.
– Olivier Belanger
Nov 13 '18 at 15:28
add a comment |
I'm using visual studio 2015. I have the sqlite database in the solution explorer. I've also added the sqlite data base under Application Files. But when I deploy, I think a new database is being created every time the app is opened instead of using the existing database. I'm getting an exception that a certain table was not found. I've used this "Data Source=my_database.sqlite;Version=3;" relative path in the connection string. How do I make the application to use the existing database instead of creating new ones? Thanks in advance.
c# winforms sqlite visual-studio-2015 sqlite3
asked Nov 13 '18 at 8:49
amith_ajithamith_ajith
14
I'm using visual studio 2015. I have the sqlite database in the solution explorer. I've also added the sqlite data base under Application Files. But when I deploy, I think a new database is being created every time the app is opened instead of using the existing database. I'm getting an exception that a certain table was not found. I've used this "Data Source=my_database.sqlite;Version=3;" relative path in the connection string. How do I make the application to use the existing database instead of creating new ones? Thanks in advance.
c# winforms sqlite visual-studio-2015 sqlite3
c# winforms sqlite visual-studio-2015 sqlite3
asked Nov 13 '18 at 8:49
amith_ajithamith_ajith
14
asked Nov 13 '18 at 8:49
amith_ajithamith_ajith
14
asked Nov 13 '18 at 8:49
amith_ajithamith_ajith
14
asked Nov 13 '18 at 8:49
amith_ajithamith_ajith
14
asked Nov 13 '18 at 8:49
amith_ajithamith_ajith
14
14
This sounds like your DB file is not found. Check the path to the DB in the connection string. Try to set it absolute. If it works, your relative path is wrong and doesn't point to your db.
– Jürgen Müller
Nov 13 '18 at 9:25
It works when it is absolute. But how come the relative path works when it is debug mode and doesn't work in release mode?
– amith_ajith
Nov 13 '18 at 15:02
Your debug and release are not in the same folder. Release will work with:my_database.sqlitebut debug with....my_database.sqlitedepending on where your database is located.
– Olivier Belanger
Nov 13 '18 at 15:28
add a comment |
This sounds like your DB file is not found. Check the path to the DB in the connection string. Try to set it absolute. If it works, your relative path is wrong and doesn't point to your db.
– Jürgen Müller
Nov 13 '18 at 9:25
It works when it is absolute. But how come the relative path works when it is debug mode and doesn't work in release mode?
– amith_ajith
Nov 13 '18 at 15:02
Your debug and release are not in the same folder. Release will work with:my_database.sqlitebut debug with....my_database.sqlitedepending on where your database is located.
– Olivier Belanger
Nov 13 '18 at 15:28
This sounds like your DB file is not found. Check the path to the DB in the connection string. Try to set it absolute. If it works, your relative path is wrong and doesn't point to your db.
– Jürgen Müller
Nov 13 '18 at 9:25
This sounds like your DB file is not found. Check the path to the DB in the connection string. Try to set it absolute. If it works, your relative path is wrong and doesn't point to your db.
– Jürgen Müller
Nov 13 '18 at 9:25
It works when it is absolute. But how come the relative path works when it is debug mode and doesn't work in release mode?
– amith_ajith
Nov 13 '18 at 15:02
It works when it is absolute. But how come the relative path works when it is debug mode and doesn't work in release mode?
– amith_ajith
Nov 13 '18 at 15:02
Your debug and release are not in the same folder. Release will work with:
my_database.sqlite but debug with ....my_database.sqlite depending on where your database is located.– Olivier Belanger
Nov 13 '18 at 15:28
Your debug and release are not in the same folder. Release will work with:
my_database.sqlite but debug with ....my_database.sqlite depending on where your database is located.– Olivier Belanger
Nov 13 '18 at 15:28
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%2f53277072%2fhow-to-deploy-c-sharp-windows-form-with-sqlite-database%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.
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.
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%2f53277072%2fhow-to-deploy-c-sharp-windows-form-with-sqlite-database%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
This sounds like your DB file is not found. Check the path to the DB in the connection string. Try to set it absolute. If it works, your relative path is wrong and doesn't point to your db.
– Jürgen Müller
Nov 13 '18 at 9:25
It works when it is absolute. But how come the relative path works when it is debug mode and doesn't work in release mode?
– amith_ajith
Nov 13 '18 at 15:02
Your debug and release are not in the same folder. Release will work with:
my_database.sqlitebut debug with....my_database.sqlitedepending on where your database is located.– Olivier Belanger
Nov 13 '18 at 15:28