78 questions
0
votes
0
answers
14
views
Unable to run SQLite-net on Mac catalyst in release mode, works fine in debug
I have a UNO platform application that is trying to use SQLite-net-pcl. While this seems to work fine in iOS in release mode in MacCatalyst in release mode i get the following error
I am trying to ...
- 133
1
vote
1
answer
87
views
When to use Microsoft.Data.Sqlite over sqlite-net-pcl?
Even though the documentation uses sqlite-net-pcl while points to Microsoft.Data.Sqlite as an alternative, it is not clear when or why use one over another.
This article uses the sqlite-net-pcl NuGet ...
- 9,746
0
votes
0
answers
107
views
ARM64 UWP DesktopExtension – "e_sqlite3.dll is not a valid Win32 application" despite including runtimes\win-arm64\native
I have an UWP app with Desktop Extension (implemented like this: https://github.com/StefanWickDev/UWP-FullTrust/tree/master).
Here is my sample project, which shows this issue:
https://github.com/...
- 103
0
votes
1
answer
335
views
Can't Build/Deploy .NET(8) MAUI app with sqlite-net-sqlcipher (1.9.172) using VS Code for Mac
I am unable to build or deploy my .NET 8 MAUI app using sqlite-net-sqlcipher (1.9.172) in Visual Studio Code for Mac. I am targeting the iOS Simulator, but the build fails with linker errors. Below ...
- 1,474
0
votes
0
answers
347
views
Creating a sqlite database file in a MAUI project folder
I created a new folder in my MAUI project and named it Database and would like this folder to be the destination of my.db3 file instead of FileSystem.AppDataDirectory, for testing purposes. So far I ...
- 9,746
0
votes
0
answers
35
views
SQLiteAsyncConnection (sqlite-net-pcl) System.AggregateException: 'One or more errors occurred. (Cannot compile: Invoke)'
I'm using sqlite-net-pcl package (1.9.172) and when running the android version of the .Net MAUI application, I get an unsupported exception "Cannot compile: Invoke" when passing the filter ...
- 507
0
votes
0
answers
81
views
Using required parameters with SqliteAsyncConnection.Table<T>
I have a model class with a couple of required fields, to avoid the null warning:
public class CategoryTable
{
public CategoryTable() { }
[Column("id")]
public required int Id ...
- 51
0
votes
2
answers
142
views
File Created by File.WriteAllBytes() Doesn't Persist After Program Ends
I followed an old sqlite-net-pcl tutorial (if you're curious) that used this code to copy an Embedded Resource into an external file it should create in C://Users/my user/AppData/Local. I confirmed ...
- 620
0
votes
0
answers
105
views
sqlite-net-pcl crashes on synchronous init
I created a class for managing the SQLite database in my MAUI app. I have an async method to initialize it:
public static async Task InitializeDatabase()
{
_dbPath = Path.Combine(FileSystem....
- 1,842
0
votes
0
answers
718
views
Configure relationships in sqlite-net-pcl in MAUI
I'm using sqlite-net-pcl and sqlite-net-extensions in .NET MAUI app and when I configure relationship between tables like this:
User can have 1:M countries
and calling SQLiteAsynConnection and ...
- 3
0
votes
1
answer
129
views
No result with sqlite-net-pcl, xamarin at ios only
I am trying to use sqlite on Xamarin and has been implemented sqlite-net-pcl to create and access local database. Works very well on Android but I can't read records on iOS.
...
- 23
1
vote
0
answers
89
views
SQLite `GetWithChildren` methods stuck on iOS 16.2
I've been testing my Xamarin.Forms on iOS and ran into an error with the WithChildren methods in SQLiteNetExtensions.
My code seems to get stuck in lines containing GetAllWithChildren and ...
- 809
1
vote
0
answers
60
views
SQLite.SQLiteException: table RecipePage has no column named IdIngredients
I am working on a .Net MAUI app that uses sqlite-net-pcl and sqlite-net-extensions. My goal is to make a RecipeBook like app. For that I need to have a database, here is the concept so far, that I ...
2
votes
2
answers
2k
views
"System.TypeInitializationException: 'The type initializer for 'SQLite.SQLiteConnection' threw an exception.'"
So I am currently trying to develop a MAUI app using the sqlite-net-pcl nugget package. My app works fine in a Windows(Win11) enviroment, but throw an exception when I am using it on an Android device(...
0
votes
0
answers
116
views
sqlite-net-pcl order items by distance
I am trying to sort a SQLite table that contains coordinates by their distance to a reference position.
I would like to execute this on the SQLite level, to avoid retrieving 100.000 items from the ...
- 213