WinRT c# load a sqlite database from folder asset

Question

I would like to load a prefab sqlite database from the folder Assets at the launch and copy it in the localstate of the application.

I try a lot of thing and every time I have a "Access denied" or "file not found".

Have you any idea how to do it ?

Regards

Do you have it stored in a folder such as Program Files which requires Administration Rights and UAC Permission to invoke? — Greg
– Greg, Commented Mar 12, 2013 at 21:16

Gary93730 · Accepted Answer · 2013-03-12 23:12:43Z

3

This is a weird quirk for Win 8 RT. I might guess that you have a special extension for your Sqlite db, like ".db" ... a workaround I have used is to use a ".txt" extension for the db in assets.

This works on my system without corrupting the file. I checked the db in Sqlite Database Browser.

StorageFile file = await StorageFile.GetFileFromApplicationUriAsync(new Uri("ms-appx:///Assets/db_in_assets.txt"));

await file.CopyAsync(ApplicationData.Current.LocalFolder, "db_in_local.db");

answered Mar 12, 2013 at 23:12

Gary93730

4414 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Sw1a Over a year ago

that's work. I tried with extension "db" and that didn't work. Thanks a lot

Collectives™ on Stack Overflow

WinRT c# load a sqlite database from folder asset

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related