How can I create a database file with SQLite-net?

Question

I am using SQLite-net nuget package in my UWP application. I want to create a local database file to use as such:

var s = new SQLiteConnection("myDbSQLite.db3", SQLiteOpenFlags.Create);

But it throws the error:

Could not open database file: C:\Path\MyProject\bin\x86\Debug\AppX\myDbSQLite.db3 (Misuse)

I see in other posts they suggest to use SQLiteConnection.CreateFile("MyDatabase.sqlite"); but I don't see that method?

EDIT

The code

FileStream fs = File.Create(path);

Throws the exception:

UnauthorizedAccessException access to the path is denied

So I think this is a permission issue I am having with UWP. Is there something in the capabilities that I need to set?

No, I don't see a method for SQLiteConnection.CreateFile. I am using version 1.5.231 of sqlite-net-pcl — Drake
– Drake, Commented Sep 10, 2019 at 18:26

Jon · Accepted Answer · 2019-09-10 18:39:02Z

3

Check your permissions on the folder, and also try using this for the constructor

_database = new SQLiteAsyncConnection(
     "myDbSQLite.db3", 
     SQLiteOpenFlags.Create | 
     SQLiteOpenFlags.FullMutex | 
     SQLiteOpenFlags.ReadWrite );

answered Sep 10, 2019 at 18:39

Jon

3,2751 gold badge19 silver badges28 bronze badges

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

Comments

Drake · Accepted Answer · 2019-09-10 21:09:17Z

2

Because creating a file in UWP must be done with the UWP API, if you're going to use this nuget library, you have to accommodate by creating it yourself first:

// Create the empty file; replace if exists.
Windows.Storage.StorageFolder storageFolder = Windows.Storage.ApplicationData.Current.LocalFolder;
storageFolder.CreateFileAsync("myDbSQLite.db3", Windows.Storage.CreationCollisionOption.ReplaceExisting);

My UWP app is actually part of a Xamarin.Forms app that is using shared code, so if your app is solely UWP there's probably a better library, such as this one that Codexer referred.

answered Sep 10, 2019 at 21:09

Drake

2,7636 gold badges54 silver badges96 bronze badges

1 Comment

Nasreddine Galfout Over a year ago

Why didn't you use the system IO from dot net standards instead. Or does your app have different IO classes for each platform?

KimKulling · Accepted Answer · 2019-09-10 18:27:02Z

1

You should use a folder wher you have write-access to. So please try the following code:

String path = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments);
string dbFile = Path.Combine( path, "myDbSQLite.db3");
var s = new SQLiteConnection( dbFile, SQLiteOpenFlags.Create);

answered Sep 10, 2019 at 18:27

KimKulling

2,8531 gold badge17 silver badges33 bronze badges

1 Comment

KimKulling Over a year ago

Have you checked this: stackoverflow.com/questions/38512257/…?

Julian Dormon · Accepted Answer · 2021-10-02 02:55:43Z

This worked for me:

 var databasePath = Path.Combine(GetLocalFileDirectory(), "MyData.db");

        try
        {
            // Create the empty file; replace if exists.
            db = new SQLiteAsyncConnection(databasePath,
                                         SQLiteOpenFlags.Create |
                                         SQLiteOpenFlags.FullMutex |
                                         SQLiteOpenFlags.ReadWrite);
        }
        catch(Exception ex) 
        {
            throw new Exception(ex.Message);
        }


public string GetLocalFileDirectory()
{
    var docFolder = FileSystem.AppDataDirectory
    var libFolder = Path.Combine(docFolder, "Databases");

    if (!Directory.Exists(libFolder))
    {
        Directory.CreateDirectory(libFolder);
    }
    return libFolder;
}

Collectives™ on Stack Overflow

How can I create a database file with SQLite-net?

4 Answers 4

Comments

1 Comment

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related