How do I include my SQLite database in my published vb.net project?

Question

I have been working on a project in vb.net which uses an SQLite database (Patient_Database.db). The connection between the software and the database works when I debug the program, and the database is stored in the project folder, and automatically transferred to the debug folder, as shown:

However, when I publish the project in order to make an executable, the database is not included in the publication. I have spent all day trying various walkthroughs online but I just don't seem to be able to get the publication to include the database or the necessary SQLite.Interop.dll file in the x64 and x86 folders in the Debug folder.

My published project looks like this:

With the following inside the Application Files folder:

I realise that I might be doing something stupid, or that I might just be going about this in the entirely incorrect way. If anyone could correct my flawed methods that would be very helpful!

Thanks

Possible duplicate of How to publish my windows form application with database — Ňɏssa Pøngjǣrdenlarp
– Ňɏssa Pøngjǣrdenlarp, Commented Jul 3, 2016 at 20:40
The selected answer for that question says: "You will need to deploy your database as "IncludeData" in the application settings." However after trying for the past 15 minutes or so I don't seem to be able to locate an application settings or an IncludeData setting. — Patrick Thorpe
– Patrick Thorpe, Commented Jul 3, 2016 at 20:56
Go to the Publish tab and click the Application Files button. — jmcilhinney
– jmcilhinney, Commented Jul 4, 2016 at 0:56
Hi. I thought this might be the answer, and I have tried it. However, the database is not listed; even when I press "show all files" — Patrick Thorpe
– Patrick Thorpe, Commented Jul 4, 2016 at 20:16

Alex B. · Accepted Answer · 2016-07-05 06:11:15Z

2

In regards to the comments some visual help for you:

Open project properties of your main project
Select the Publish tab
Choose Application files...

Find your db file
If it is not listed, select Show all files first
Set the Publish Status to Include
The Download Group should be Required.

After a new publish the DB file should be contained in the Application Files on your server.

EDIT: To make the file visible for the published application files you have to set its 'Build Action':

edited Jul 5, 2016 at 6:11

answered Jul 4, 2016 at 7:23

Alex B.

2,1671 gold badge17 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Patrick Thorpe Over a year ago

Hi. I thought this might be the answer, and I have tried it. However, the database is not listed; even when I press "show all files"

user3267567 Over a year ago

great visual demo but this is the only step that you need: i.e., Right click the db file in solution explorer then set its Build Action to CONTENT as demonstrated here i.sstatic.net/nfCP9.png.

Milad Faridnia · Accepted Answer · 2017-12-13 04:22:31Z

-1

Just add a folder "Database" in your project and insert there your file.db

Then on Publish "Application files" include as dataFile your file.db

edited Dec 13, 2017 at 4:22

Milad Faridnia

9,49513 gold badges71 silver badges83 bronze badges

answered Dec 13, 2017 at 0:32

Neshat Ademi

12 bronze badges

Collectives™ on Stack Overflow

How do I include my SQLite database in my published vb.net project?

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related