Is it possible to use a SqlLite file from a directory other than LocalStorage

Question

I can successfully connect to a sqlite file located in LocalStorage but not other locations such as PicturesLibrary.

Has anyone else had this issue? or know of a fix without copying the file from the other folders into LocalStorage since Im working with an 8Gig sqlite file.

Cheers,

Answer 1

No. SQLlite depends on having direct access to read and write the database file. Your app has direct access only to its install directory (read only) and application data directories (read and write). The app can only access the libraries via StorageFolders, which SQLlite does not use.

See File access and permissions .

--Rob

Answer 2

Hello Native Code,

try to give file access permission in project using package.appxmanifiest file. than use this code : 

StorageFile fo = await KnownFolders.PicturesLibrary.GetFileAsync("your sqlite database file name");
            SQLiteAsyncConnection conn1 = new SQLiteAsyncConnection(fo.Path);

Answer 3

Hello Native Code,

try to give file access permission in project using package.appxmanifiest file. than use this code : 

StorageFile fo = await KnownFolders.PicturesLibrary.GetFileAsync("your sqlite database file name");
            SQLiteAsyncConnection conn1 = new SQLiteAsyncConnection(fo.Path);

I'v tried that previously but it doesn't work.