Resolving SQLite issues for .NET MAUI

Recently, while working on ExampleApp, we faced two significant errors and found effective solutions for both. Here’s a detailed account of the problems and their resolutions.

System.TypeInitializationException

System.TypeInitializationException: The type initializer for 'SQLite.SQLiteConnection' threw an exception.
 ---> System.DllNotFoundException: e_sqlite3

To resolve this error, we needed to install the latest NuGet package for SQLitePCLRaw.bundle_green. This package ensures that the necessary SQLite libraries are included in the project.

Add the following package reference with the latest version to your project:

<PackageReference Include="SQLitePCLRaw.bundle_green" Version="2.1.10" />

In the AppDelegate.cs file, add the following line to the CreateMauiApp method:

protected override MauiApp CreateMauiApp()
{
    SQLitePCL.raw.SetProvider(new SQLitePCL.SQLite3Provider_sqlite3());
    return MauiProgram.CreateMauiApp();
}

System.ExecutionEngineException in iOS Release Mode

System.ExecutionEngineException: Attempting to JIT compile method '(wrapper delegate-invoke) void System.Action`2<ExampleApp.Entites.LocalDatabase.VoucherLite, double>:invoke_callvirt_void_T1_T2 (ExampleApp.Entites.LocalDatabase.VoucherLite,double)' while running in aot-only mode. See https://docs.microsoft.com/xamarin/ios/internals/limitations for more information.

This error occurs due to the JIT compilation attempt in AOT-only mode on iOS. The solution is to install this specific version of the sqlite-net-pcl.
It will ONLY work with 1.7.355 or below.

<PackageReference Include="sqlite-net-pcl" Version="1.7.335" />

 This solution is also applicable to Xamarin projects.