Problem with SQLite with .NET 9.0 and WebAssembly.

[Rafucho25]

Hi, I'm trying to use SQLite in my project, for some reason with .Net 9.0 is not working but with .NET 8.0 it does on WebAssembly. I created two projects with this command:

dotnet new unoapp -o test8 -preset "recommended" -tfm "net8.0" -platforms "android" -platforms "maccatalyst" -platforms "wasm" -platforms "windows" -platforms "desktop" -platforms "ios" -presentation "none" -nav "blank" -pub "test8"

dotnet new unoapp -o test9 -preset "recommended" -tfm "net9.0" -platforms "android" -platforms "maccatalyst" -platforms "wasm" -platforms "windows" -platforms "desktop" -platforms "ios" -presentation "none" -nav "blank" -pub "test9"

I modify both projects with this sample in test8 it works great as I said but in test9 I receive this error:

Unhandled Exception:
dotnet.native.gvpz05k4vk.js:1722
System.DllNotFoundException: sqlite3
dotnet.native.gvpz05k4vk.js:1722
   at SQLitePCL.SQLite3Provider_sqlite3.SQLitePCL.ISQLite3Provider.sqlite3_libversion_number()
dotnet.native.gvpz05k4vk.js:1722
   at SQLitePCL.raw.SetProvider(ISQLite3Provider imp)
dotnet.native.gvpz05k4vk.js:1722
   at SQLitePCL.Batteries_V2.Init()
dotnet.native.gvpz05k4vk.js:1722
   at SQLite.SQLiteConnection..cctor()
dotnet.native.gvpz05k4vk.js:1722
fail: Uno.UI.Dispatching.NativeDispatcher[0]
      NativeDispatcher unhandled exception
System.TypeInitializationException: The type initializer for 'SQLite.SQLiteConnection' threw an exception.
 ---> System.DllNotFoundException: sqlite3
   at SQLitePCL.SQLite3Provider_sqlite3.SQLitePCL.ISQLite3Provider.sqlite3_libversion_number()
   at SQLitePCL.raw.SetProvider(ISQLite3Provider imp)
   at SQLitePCL.Batteries_V2.Init()
   at SQLite.SQLiteConnection..cctor()
   --- End of inner exception stack trace ---
   at test9.MainPage.TryCreateDatabase() in C:\Users\user\source\repos\Uno\test9\test9\MainPage.xaml.cs:line 39
   at test9.MainPage.InitializeDatabase() in C:\Users\user\source\repos\Uno\test9\test9\MainPage.xaml.cs:line 18
   at System.Threading.Tasks.Task.<>c.<ThrowAsync>b__128_0(Object state)
   at Uno.UI.Dispatching.NativeDispatcherSynchronizationContext.<>c__DisplayClass3_0.<Post>b__0() in /agent/_work/1/s/src/Uno.UI.Dispatching/Native/NativeDispatcherSynchronizationContext.cs:line 21
   at Uno.UI.Dispatching.NativeDispatcher.RunAction(NativeDispatcher dispatcher, Action action) in /agent/_work/1/s/src/Uno.UI.Dispatching/Native/NativeDispatcher.cs:line 148

Am i doing something wrong, or at this moment is it not possible to use SQLite.net with .NET 9.0 and WebAssembly? Is there another way to do so? Thanks.

[MartinZikmund]

Converted to an issue as I have seen this myself too #20188, please track progress there