WPF Core App not working with SQLite database.

Question

WPF Core App not working with SQLite database.

SatnamSingh 1

Recently i have create one app in WPF Core 3.1. Now i want to deployed that on Microsoft store. I have purchased partnership. Every thing is done. But my app is not working when i create windows app package. Same thing is working in WPF .Net framework. But not with windows app.

List of issues.

Sqlite file is not working in application installed directory.
I have write a code for "AppData" folder. But Directory.CreateDirectory() method not working i am unable create folder.
I cannot create db file in AppData. I have also put log there no error is coming, path is also right but file/directory nothing is created. In debug mode everything is working.
App certification kit also showing some errors which is surprise me because i have not use such dll's.

App is working in Visual studio. Once i create package and install on my local machine nothing is working. Please help me.

Alex Li-MSFT 1,086 Reputation points

2020-05-26T07:40:58.943+00:00

How did you package your app? Using Windows Application Packaging Project with VS or packaging it manually? If you use VS to package your package, did you associate your app with the Store before package it? What the error message when the SQLite file not working? Please give me more detailed steps or a simple demo which could reproduce the error for me to analyze.
SatnamSingh 1 Reputation point

2020-05-26T12:51:12.82+00:00

I have attached screen shot how i am creating app. After installation of app not any error coming in log but directory is not created in special folder.
Alex Li-MSFT 1,086 Reputation points

2020-05-27T07:15:03.197+00:00

The error message shows that System.Xml.XPath.dll is only for x86 process …, did you choose the Neutral as the Architecture[as the below picture shows] when you package the WPF project? If you did, could you change it to x86 to try again?
SatnamSingh 1 Reputation point

2020-05-27T17:40:03.507+00:00

Yes, now i am not getting that errors. There is one information highlight when i selected x86 "Select all architectures for your app to run on the most devices possible.". If i select X86 only then my app work on all devices without problem? :) .

Alex Li-MSFT 1,086 Reputation points

2020-05-26T07:40:58.943+00:00

How did you package your app? Using Windows Application Packaging Project with VS or packaging it manually? If you use VS to package your package, did you associate your app with the Store before package it? What the error message when the SQLite file not working? Please give me more detailed steps or a simple demo which could reproduce the error for me to analyze.
SatnamSingh 1 Reputation point

2020-05-26T12:51:12.82+00:00

I have attached screen shot how i am creating app. After installation of app not any error coming in log but directory is not created in special folder.
Alex Li-MSFT 1,086 Reputation points

2020-05-27T07:15:03.197+00:00

The error message shows that System.Xml.XPath.dll is only for x86 process …, did you choose the Neutral as the Architecture[as the below picture shows] when you package the WPF project? If you did, could you change it to x86 to try again?
SatnamSingh 1 Reputation point

2020-05-27T17:40:03.507+00:00

Yes, now i am not getting that errors. There is one information highlight when i selected x86 "Select all architectures for your app to run on the most devices possible.". If i select X86 only then my app work on all devices without problem? :) .

Answer 1

Duane Arnold 3,211

You created AppData folder where in what directory when you deployed the solution to the machine?

WPF Core App not working with SQLite database.

1 answer

Activity