Stack Overflow
Stack Overflow

Questions tagged [sqlite-net-extensions]

SQLite-Net Extensions is a very simple ORM that provides one-to-one, one-to-many, many-to-one, many-to-many, inverse and text-blobbed relationships on top of the sqlite-net library.

SQLite-Net Extensions is a very simple ORM that provides one-to-one, one-to-many, many-to-one, many-to-many, inverse and text-blobbed relationships on top of the sqlite-net library.

sqlite-net is an open source, minimal library to allow .NET and Mono applications to store data in SQLite 3 databases. SQLite-Net Extensions extends its functionality to help the user handle relationships between sqlite-net entities.

148 questions
2
votes
2 answers

How to implement a recursive relationship with SQLite-Net Extentions

I have a table Employee that must have a recursive relationship eg. Row 1: EmployeeId = 1, EmployeeName = Albert, SupervisorId = NULL; Row 2: EmployeeId = 2, EmployeeName = Leonardo, SupervisorId = 1; i.e. EmployeeId(2) is a child of EmployeeId(1)…
MJ33
  • 859
  • 12
  • 25
2
votes
1 answer

Sqlite.Net PCL And Sqlite-Net Extensions

I'm trying to use this lib: https://github.com/oysteinkrog/SQLite.Net-PCL so I can keep all my repository stuff in a PCL. And https://bitbucket.org/twincoders/sqlite-net-extensions/overview Because is way better to manage the relationship between…
Giusepe
  • 655
  • 5
  • 15
1
vote
0 answers

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 want to make: Hope you can read everything. So far I…
Bence Hérincs
  • 21
  • 3
1
vote
1 answer

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:…
Santiago Vasquez
  • 149
  • 1
  • 10
1
vote
1 answer

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 PostID { get; set; } public string Name { get;…
IranSosa
  • 51
  • 4
1
vote
1 answer

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 { [PrimaryKey, AutoIncrement] public int id {…
Tom Anderson
  • 11
  • 3
1
vote
1 answer

ManyToMany Relation → Add a value to the junction table

I have two entities: Component and Attribute. Components can have multiple Attributes and Attributes can also have multiple Components. The value of the attribute will be stored in the junction table "ComponentAttribute". I don't know whats the best…
Alex
  • 11
  • 3
1
vote
1 answer

Is sqlite.Net.Extensions functionalities supported in Uwp platform?

Not being able to use any SQLExtensions functionalities with Sqlite connection. Installed SQLExtensions 2.1.0 nuget package in the UWP app, created the following db connection, using (SQLite.Net.SQLiteConnection conn = new…
Skynet094
  • 443
  • 4
  • 19
1
vote
1 answer

SqliteNetExtensions is it possible to ignore a specified child when calling InsertOrReplaceWithChildren()?

I'm building a mobile app in xamarin that has a lot of relationships between classes. For simplicity consider it to be a "University" app that has the classes: ExamPapers, Students, ExamAnswers. The ExamPaper class would look like this public class…
user8051386
  • 115
  • 6
1
vote
0 answers

sqlite-net-extensions -- Create Table Async

My problem is that I'm using the CreateTableAsync method and is always returning "0". I researched and saw that this return is a mistake. I wanted to know what I'm doing wrong. Class Service Table: public class SqliteTable { private readonly…
Gilberto Freitas
  • 11
  • 1
1
vote
2 answers

SQLite extension for xamarin.forms : delete on cascade not working, but the the code compiles with no errors

I'm using SQLiteNetExtensions to create a foreign key from one table to another so I can delete on cascade. I followed the documentation on: https://bitbucket.org/twincoders/sqlite-net-extensions, but when I delete a record on my Missions Table, the…
BLM
  • 23
  • 8
1
vote
1 answer

Navigate to SQLite object related to an other object, fetched from the database

I'm trying to navigate to an object, related to an other object. In this situation, there are 2 classes; StockTakeSession and Location. These 2 have a one-to-one relation. When there are 2 objects created of each class and I set the relation as in…
Robert
  • 118
  • 1
  • 10
1
vote
4 answers

Use SQLiteNetextensions with Xamarin for Android-App

I've read some threads about SQLite for Xamarin but I'm still not able to set up SQLiteNetExtensions in a proper way. I'm currently developing an android app with Target Framework Android 7.1(API Level 25 - Nougat). Can anybody tell me what I'm…
Muffex
  • 55
  • 1
  • 12
1
vote
0 answers

SQLite-net-pcl - SQLite.SQLiteException: Cannot add a PRIMARY KEY column

I seem to be hitting all sorts of problems today. I simply cannot get Sqlite-net-pcl to behave correctly when signing an APK. Debug and release work fine but everytime I create a signed version of the APK the app crashes with this…
Phill Wiggins
  • 2,577
  • 4
  • 28
  • 33
1
vote
0 answers

ForeignKey Goes NULL After a second UpdateWithChildren()

I am using SQLiteNetExtension for XAMARIN Forms project (PCL). the problem which I am facing is the the ForeignKey for a many-to-one relationship which is defined in the many end of the relationship is Overrided with Null after a second…
Mohamed Aymen Haddad
  • 67
  • 7
1 2 3
…
9 10