149 questions
0 votes
2 answers
204 views
How do I delete records from one table that are linked to another table through its PK?
I have a database in a Maui app that has two tables. The first table was setup with a class like this: public class Groups { [PrimaryKey, AutoIncrement] public long Id { get; set; } public ...
0 votes
0 answers
818 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 ...
0 votes
0 answers
197 views
SQLiteExtensions UpdateWithChildrenAsync(..) not updating items with constraint
I have an App in which I use SQLiteExtensions and following model: [Table("SavedMeals")] public class SavedMeal { [PrimaryKey, AutoIncrement] // Primary Key already indexed in Table ...
1 vote
0 answers
91 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 ...
1 vote
0 answers
66 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 ...
0 votes
1 answer
187 views
How To Read and Write Records In SQLite Using SQLite Net Extensions?
Here is the documentation I've looked at and may be helpful: Sample SQLite OneToMany Unit Test and General Read and Write Documentation in Readme My use-case is that I've already inserted an Item and ...
0 votes
1 answer
370 views
With SQLite-Net Extensions, is there a way to have List<string>?
In the documentation for SQLite-Net Extensions, it shows having an object (Stock) with property that has a List of another object (Valuation) with a OneToMany relationship. I am able to reproduce that ...
1 vote
1 answer
205 views
Xamarin Cannot compile: Parameter System.Collections.Generic.List`1[T] queryArgs
I have a problem with a query of SQLite Xamarin I have installed sqlite-net-pcl 1.7.335 and SQLiteNetExtensions 2.0.0 The process of error is the next: I fill the variable nuevoRegistro: dataService....
0 votes
1 answer
298 views
Storing automapped object with class properties with sqlite-pcl and a generic repository
The project I am working on is a Xamarin mobile application with a REST api and offline first practices. To achieve this I've setup a generic repository which is supposed to handle the communication ...
0 votes
1 answer
198 views
Can't create tables with some reference to SQLiteNetExtensions in UWP Xamarin.Forms
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 ...
0 votes
0 answers
73 views
Nested one-to-many tables SQLite-Net Extensions [duplicate]
I have 4 tables that I'm trying to create: Term, Courses, Assessments, and Notes. Term has a one-to-many relationship with Courses, and Courses has a one-to-many relationship with Assessments and ...
0 votes
1 answer
1k views
SQLite-Net Extensions - GetAllWithChildrenAsync not pulling everything
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 ...
0 votes
0 answers
539 views
How to do the CRUD operations for a table with a foreign key with SQLiteNet-Extensions
I am using sqlite-net-pcl with the SqLiteNetExtensions for a foreign key. I have this two tables ( not sure if they are written correctly) an agenda can contain many Tasks, my question is how do i ...
1 vote
1 answer
561 views
How to create two foreign keys to the same table with SQLite in Xamari Form
I working in a project with Xamarin Form using C#. I'm trying to create two foreign keys to the same table, using this code: [Table("Posts")] public class Post { [PrimaryKey] public long ...
1 vote
1 answer
568 views
Having problem inserting child list of objects with included textblobs
I'm hoping someone can shed some light on this problem. Being new to the extensions, it is probably something I'm doing wrong. I have an object called Reason: public class Reason { [...