All geek questions in one place

Deploying .NET SQLite and Click-Once

Have a smartclient application that is distributed using Click-Once, but also includes SQLite DB for the local cache.

The problem is that after publishing the application, it does not seem to be able to open the SQLite DB file. Included a DB file as part of the installation process ...

Any thoughts?

+3
source share
4 answers

If the ClickOnce application is set to Full Trust, during installation it will ask the user to provide full trust. This means that the application will have all the same privileges on the computer as the user running the application (editing the registry, io file, etc.). You mentioned in the comments that the application is configured for full trust, so this does not seem to be a security issue.

Are you sure all the necessary files are being deployed? I will simply remove ClickOnce from the image. Look at all the files in your deployment, create a folder and copy all these files into it, and then try to run it. It works? My initial guess is that some of the required files are not included in the ClickOnce deployment.

+3

, . Virtuallized paths Vista .

.

+1

Have you included the SQLite provider in the package?

0
source

I had the same problem. My solution was to add SQL.interop.DLL (x32 and x64) to the Visual Studio Project (as a link) so that ClickOne Deploiment would add these files to this “package”. See this blog post: http://webbercross.azurewebsites.net / ef7-sqlite-click-once-deployment-error /

0
source

Source: https://habr.com/ru/post/1716675/

More articles:


All Articles