Getting a FileNotFoundException when trying to make a SQLite connection in .net MAUI on Android

Question

db = new SQLiteConnection(databasePath);

The above statement works fine on Windows but gets the below error on Android. It also worked fine in xamarin forms on both platforms.

System.IO.FileNotFoundException: 'Could not load file or assembly 'SQLitePCLRaw.provider.dynamic_cdecl, Version=2.0.4.976, Culture=neutral, PublicKeyToken=b68184102cba0b3b' or one of its dependencies.'

Thanks for any help.

The error happens on real Android device or Android emulators?Have you installed all the necessary nuget packages?Please create a Minimal, Reproducible Example via github repo. — Alexandar May
– Alexandar May, Commented Jun 27, 2022 at 6:44

Alexandar May · Accepted Answer · 2022-06-27 06:28:48Z

19

There are a few things that you need take care of when using sqlite in your MAUI project.

1.Make sure you have installed below nuget packages:

 <ItemGroup>
    <PackageReference Include="sqlite-net-pcl" Version="1.8.116" />
    <PackageReference Include="SQLiteNetExtensions.Async" Version="2.1.0" />
    <PackageReference Include="SQLitePCLRaw.core" Version="2.1.0-pre20220207221914" />
    <PackageReference Include="SQLitePCLRaw.bundle_green" Version="2.1.0-pre20220207221914" />
    <PackageReference Include="SQLitePCLRaw.provider.dynamic_cdecl" Version="2.1.0-pre20220207221914" />
    <PackageReference Include="SQLitePCLRaw.provider.sqlite3" Version="2.1.0-pre20220207221914" />
  </ItemGroup>

2.Use SQLiteAsyncConnection to initialize the database connection.

Database = new SQLiteAsyncConnection(Constants.DatabasePath, Constants.Flags);

And then create static class Constants like below:

 public static class Constants
    {
        public const string DatabaseFilename = "MySQLite.db3";
        public const SQLite.SQLiteOpenFlags Flags =
            SQLite.SQLiteOpenFlags.ReadWrite |
            SQLite.SQLiteOpenFlags.Create |
            SQLite.SQLiteOpenFlags.SharedCache;
        public static string DatabasePath
        {
            get
            {
                var basePath = Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData);
                return Path.Combine(basePath, DatabaseFilename);
            }
        }
    }

answered Jun 27, 2022 at 6:28

Alexandar May

10.5k1 gold badge14 silver badges23 bronze badges

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

3 Comments

djack109 Over a year ago

both SQLiteAsyncConnection and SQLiteConnection give me runtime errors.

user7862339 Over a year ago

For a week I've been looking for a solution, turns out it was just adding a few more packages... Thanks a lot for making my day!

Vfleitao Over a year ago

This just solved all my problems with SQLite not starting up Thanks !!!

Gautam Jain · Accepted Answer · 2024-02-24 09:26:00Z

2

I installed the package SQLitePCLRaw.provider.dynamic_cdecl and it worked.

answered Feb 24, 2024 at 9:26

Gautam Jain

6,84910 gold badges51 silver badges68 bronze badges

Comments

Ritchie B · Accepted Answer · 2023-04-22 20:32:40Z

1

I experienced the same exception.

It was caused by having spaces in the Project Name

answered Apr 22, 2023 at 20:32

Ritchie B

951 silver badge8 bronze badges

Collectives™ on Stack Overflow

Getting a FileNotFoundException when trying to make a SQLite connection in .net MAUI on Android

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related