sqlite-net | Fork | Database library

I'm writing a simple Xamarin Forms mobile app (Android and iOS, but focusing on Android for now) as a school project. I'm using Visual Studio 2019 Community and I have installed the NuGet package sqlite-net-pcl v1.7.335

Everything was moving along when suddenly the application started throwing errors any time database access was attempted, saying "DatabasePath must be specified".

Concerned I might have made an error in my code, I created a blank application and attempted only a simple database connection. The same error occurs. Please see my code below.

MainActivity.cs

I am trying to implement the SQLiteNetExtensions.Async nuget in a Xamarin.Forms project but when I try to create a table with some reference to SQLiteNetExtensions I get the following exception when trying to create a table (only happens in UWP , in the rest of platforms it works well): Could not load file or assembly 'SQLite-net, Version=1.4.118.0, Culture=neutral, PublicKeyToken=null'. The system cannot find the specified file.

I use these versions:

SQLiteNetExtensions.Async version 2.1.0: https://www.nuget.org/packages/SQLiteNetExtensions.Async/

Xamarin.Forms version 5.0.0.2012

How do I update every row in sqlite-net-pcl database using this function by getting the id of every row even though i create new rows later on. To break it down, I need the id of every existing row in my table, and i need each one of that id to be put in this function and update the table.

For a table defined

I have a database schema that I do not control (it's a sqlite3 file exported from a desktop application that I need to interoperate with), that contains UUIDs for some of the columns. I'm using sqlite-net-pcl in a Xamarin.Forms app, and I cannot work out how to successfully read these columns. Here's what I've tried:

• using the sqlite3 command line, I've confirmed that the schema has type uuid for the relevant column, and using select count(distinct uuidcolumn) from mytable; I've confirmed that there are values for each row. (The column is nullable which is relevant for the code snippet below but in practice all the rows have non-null values)
• I have this model object:

My xamarin.forms app is breaking when it hits the _connection.CreateTableAsync() line. I tried installing the earlier version of SQLite-net-pcl nuget package but it is still breaking. If I look in the Application Output window there are these errors -

2021-02-03 14:32:20.172608-0500 Excercise.iOS[17306:776656] *** Assertion failure in -[UIApplication _runWithMainScene:transitionContext:completion:], UIApplication.m:4191 2021-02-03 14:32:20.198946-0500 Excercise.iOS[17306:776816] [unspecified] container_system_group_path_for_identifier: error = ((container_error_t)98) NOT_CODESIGNED 2021-02-03 14:32:20.199159-0500 Excercise.iOS[17306:776816] [MC] Error getting system group container for systemgroup.com.apple.configurationprofiles: 98 2021-02-03 14:32:20.199394-0500 Excercise.iOS[17306:776816] [MC] Failed to get profile system group container path. Overriding with expected path: /Users/xamarinforms/Library/Developer/CoreSimulator/Devices/CF07B70A-5AEC-4307-AB50-864317F14B69/data/Containers/Shared/SystemGroup/systemgroup.com.apple.configurationprofiles

I can't understand if this has something to do with Sqlite. Are the above errors related to bundle singing by any chance? My apple id and account that I used to signin to Visual studio are different.

My Sqlite ios implementation

I am trying to use SQLite-Net Extensions to create a Relational Database. I'm running into an issue when trying to pull the Term object from the database. It successfully pulls over its associated courses, but not the courses associated assessments and notes. I'm not sure if the problem lies in how I insert the objects into the database, how I pull the objects from the database, or how I have the objects attributes listed.

I feel like the SQLite-Net Extensions documentation is extremely limited, so I'm not even sure what's going on. I've tried it many different ways, including adding CascadeOperations, but non of those seemed to help.

Here is the (simplified) code for my objects:

I am using sqlite-net in my project and have a helper class called SqLiteHelper. Inside this class I have a simple method that returns TableQuery results as a List. Example:

I keep getting the following error when trying to initialize my SQLite-NET database:

Cannot create a table without columns (does 'PersonModel' have public properties?)

I have a class PersonModel that I want to be immutable, however SQLite is telling me that PersonModel must be mutable, e.g. each property must use public set;.

How can I continue using SQLite-NET with immutable properties?