Deploy WPF application with sqlite database

Question

0.00/5 (No votes)

See more:

hello
i am trying to deploy a wpf application with sqlite database and target .net framework 4.5.2, when i install the application its work ion my machine (the same machine i develop the application on)
but when i install the application on another devices its not working.
i search a lot for the same issue many people have the same problem, i tried their solution its not working for me.
i attach the sqlite dll and the database file but no change.
i install it in pc that has all dlls and .netframework but its not working i think its something related to the sqlite
can any one make this possible?

What I have tried:

oneclick publish using VS 2015
vs installer in visual studio 2015

Posted 18-Mar-18 7:53am

Member 13199484

Updated 18-Mar-18 18:03pm

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Graeme_Grant · Answer 1 · 2018-03-18T18:04:00

Solution 2

You need to manually add the SQLite.Interop.dll file and folder to your solution's main project for the type of build that you are using. When you are ready to publish, check and tell your installer to include them. You can find the file and folders in the packages\System.Data.SQLite.Core.1.0.106.0\build solution folder.

Posted 18-Mar-18 18:04pm

Graeme_Grant

Comments

Member 13199484 19-Mar-18 0:30am

I add those library to the bin folder and I tell the vs to copy them to the output.
but for the SQLite.Interop.dll when I add it and rebuild the project its disappear.

Graeme_Grant 19-Mar-18 0:41am

You add them to the project, not the bin folder, and set the properties to add if newer. when you compile the app, the files will be copied as part of the build process.

Member 13199484 19-Mar-18 7:24am

I add the dll nothing change the application still not working

Graeme_Grant 19-Mar-18 12:05pm

It works - I do it with my own projects & ClickOnce installation...

Add the x86 & x64 folders to your main project and add the existing SQLite.Interop.dll file (don't mix them up) and set the "copy" project property for each. (side note: one of my apps has over 200 projects and one is the main app project, so I add the folders and files to it). Now (release) build the app and make sure that the folders and files are copied to the bin folder correctly. Once they do, now configure your installer to correctly copy the files. Now you're ready to publish...

I have an article on how to do "Silent" ClickOnce and pitfalls to avoid: Silent ClickOnce Installer for Winform & WPF in C# & VB[^]

I'm currently working on an SQLite article but it is not finished yet. I've noted your issue and will cover it in a section of the article. When will it be published? Good question! I'm working on it between jobs and answering questions here. It's quite comprehensive and will take a little while longer to complete. So no exact publication date, sorry.

Member 13199484 19-Mar-18 8:09am

Please can you remote my pc and check the project?

Graeme_Grant 19-Mar-18 12:07pm

Sorry, can't do that. Please carefully read the solution again and the additional comments that I have given above. Check each step very carefully to make sure that you are doing them correctly. "Measure twice, cut once" as they say... If you do it will work. :)

Member 13199484 19-Mar-18 12:12pm

thank you i will read it again and do it step by step

Graeme_Grant 19-Mar-18 12:13pm

Also have a read of this answer to a very similar question to yours: How to deploy SqLite Database with windows application[^]

Member 13199484 19-Mar-18 12:26pm

okay i have little question:
i manually add the SQLite.Interop.dll to x64 and x86 folders in bin folder
then in my project. should i click add->existing item and explore to the SQLite.Interop or just in the solution panel -> show folder in explore for the dll and right click then include in the project?

and when i rebuild the project the SQLite.Interop.dll deleted automaticlly from bin folder.
and now i relaize that inside the bin folder after rebuild another bin folder added so i have bin folder inside bin folder

Graeme_Grant 19-Mar-18 12:31pm

" manually add the SQLite.Interop.dll to x64 and x86 folders in bin folder" ... this is your problem, you don't.

Please carefully read my solution above again and the additional information above. Add them to the project, not the bin folder.

Member 13199484 19-Mar-18 12:34pm

i do it both to be in the safe side lol.

Graeme_Grant 19-Mar-18 12:40pm

If you add to the project in the solution, the ones that you manually add in the bin folder will automatically be replaced by the build. Secondly, the installer publishing process won't see the files that you manually put in the bin folder. The installer publish process looks at the project only. So pointless to do what you are doing...

peterkmx · Answer 2 · 2018-03-18T09:47:00

Solution 1

Please check windows event log, as there can be more info about the cause of errors...
It can be found in Event Viewer, in particular Application Log and System Log might help ...
Cheers,

Posted 18-Mar-18 9:47am

peterkmx