WinUI 3 Access LocalState Folder

[Bondarenko1990]

I use in my application Sqlite.

And I want to add migrations. But....
The EF migration command uses dotnet build, which is not supported by WinUI project now.
The workaround is defining EF related things in another project and reference it from WinUI project.
microsoft/microsoft-ui-xaml#3850 (comment)
And how can I get the path to the database in class library project?

[castorix]

To get special folders, you can use Environment.GetFolderPath, like :

string sLocalAppdata = Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData);

[Bondarenko1990]

If I use Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData) I get path (C:*\bonds\AppData\Local) and the database is created in the folder LocalCache.
I need LocalSatet Folder of my App (C:\Users*\AppData\Local\Packages*_c36cftgf3se56\LocalState) not (C:\Users*\AppData\Local\Packages****_c36cftgf3se56\LocalCache).

[huoyaoyuan]

You can target the library project to net6.0-windows10.0.19041 (or any other SDK version), without adding WinUI, so that you are supported by dotnet build and have access to ApplicationData which is a part of WinRT api.

[Bondarenko1990]

@huoyaoyuan Have you tried making a migration in the CsWinRT project?

[huoyaoyuan]

No, I never set connection string directly in OnConfigure.
I remember in fact you can omit the application data folder. It will be your current working directory in packaged app.

[Bondarenko1990]

@huoyaoyuan What does it mean to omit?

[huoyaoyuan]

Remove the whole Path.Combine call, and just use Database.db or .\Database.db.

[Bondarenko1990]

@huoyaoyuan

And I have error
Exception thrown: 'Microsoft.Data.Sqlite.SqliteException' in System.Private.CoreLib.dll An exception of type 'Microsoft.Data.Sqlite.SqliteException' occurred in System.Private.CoreLib.dll but was not handled in user code SQLite Error 14: 'unable to open database file'.

database not created

[ghost1372]

@Bondarenko1990 mybe this can help you

https://github.com/microsoft/WinUI-Gallery/blob/7238109ef49a3fea0884db05671ed11b2cec1f5d/WinUIGallery/Common/SuspensionManager.cs#L81

[Bondarenko1990]

I cannot use StorageFolder Or ApplicationData in Class Library