How do I include my SQLite database in my published vb.net project?
<p>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:</p>

<p><a href="https://i.stack.imgur.com/O6kh1.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/O6kh1.png" alt="Database in solution explorer"></a></p>

<p><a href="https://i.stack.imgur.com/hdXdr.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/hdXdr.png" alt="Database in debug folder"></a></p>

<p>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.</p>

<p>My published project looks like this:</p>

<p><a href="https://i.stack.imgur.com/FOfjq.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/FOfjq.png" alt="Publication"></a></p>

<p>With the following inside the Application Files folder:</p>

<p><a href="https://i.stack.imgur.com/VvAbs.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/VvAbs.png" alt="enter image description here"></a></p>

<p>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!</p>

<p>Thanks</p>