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
0
votes
2 answers

fully delete a relationship in a many to many table in sqlite-net extension?

I have a similar situation, to this post the delete works but only on students and classes table, in the student_classes table the elements are not deleted. public class Students { [PrimaryKey, AutoIncrement] public int StudentId { get;…
PandaSharp
  • 642
  • 7
  • 24
0
votes
1 answer

Replacement for sqlite-extensions: InsertWithChildren (too many Variables)

i have a project here, were a big amount of data is read from different sources. In a special logic, a data/object-modell is build with these data. So as a result i retrieve a complete SQLite capable object model. The data were previously written to…
The Chris
  • 591
  • 6
  • 19
0
votes
1 answer

SQLiteNetExtensions - NuGet Could not install package

I've been developing several cross platform mobile projects using Xamarin. Pretty much all of them utilize SQLite in some way. I've been maintaining two separate libraries for my SQLite functionality; one for iOS and one for Android. The way I've…
Jared Price
  • 5,217
  • 7
  • 44
  • 74
0
votes
1 answer

UpdateWithChildren sqlite-net-extensions

I have confused with UpdateWithChildren and InsertOrReplaceWithChildren. I can't get it work with UpdateWithChildren, but It can work with InsertOrReplaceWithChildren. so I have deleted the db, then apply InsertOrReplaceWithChildren, but the problem…
tom tom
  • 29
  • 10
0
votes
1 answer

CreateTable does not create PrimaryKey nor Foreign Kety Constraits

I created a simple project. Aded the Sqlite and Sqlite extensons. However when I create the tables. Neither Primary nor ForeignKey relation is established on the table. Could someone let me know what am I doing wrong. SQLiteConnection…
imasud
  • 171
  • 2
  • 9
0
votes
1 answer

SQLiteNetExtensions OneToMany and ManyToOne Relationships not working

I have a problem with SQLite-Net I have three classes: ClassA, ClassB, ClassC. ClassA has OneToMany relation with ClassB. ClassB has ManyToOne Relation with ClassC. This is my code using System; using System.Collections.Generic; using…
Larisa
  • 1
  • 2
0
votes
0 answers

Attributes sqlite-net doesn't work

I don't know if this problem it's related that I'm using SqliteNetExtensions but attributes here seems to work partially. I.E. if I declare a column with [Ignore] attribute I see that in my table the attribute exist, so the attribute here it's not…
Caio
  • 61
  • 5
0
votes
1 answer

Inserting/Retrieve data into Sqlite with Sqlite.net Extensions

i'm currently making an app that is using Sqlite to store an object that has a list of object within it. I've been having trouble trying to insert and retrieve the object for the past week and was wondering if I could get some help with this. Any…
Fayt
  • 71
  • 2
  • 10
0
votes
1 answer

SQLite Extentions inner joins on GetAllWithChildren

We're currently trying SQLite Extentions (PCL) as an ORM. We're wondering if the mapping is supposed to build a SELECT with INNER JOINs on children if they are correctly configured in the entity? public class Project { [PrimaryKey] public…
Nicolas Belley
  • 803
  • 2
  • 12
  • 29
0
votes
1 answer

SQLite.net Extensions loads the same entity multiple times rather than returning the same reference

I'm using the PCL version of SQLite.Net Extensions in a Windows 10 universal app. This is my first time using it. It generally seems to be working, but it appears to be loading an entity multiple times rather than reusing a reference to the same…
David Cater
  • 415
  • 3
  • 15
0
votes
1 answer

Many to Many relationships with look up tables

public class Person { [PrimaryKey, AutoIncrement] public int Id { get; set; } public string FirstName { get; set; } public string LastName { get; set; } [ManyToMany(typeof(PersonColor), CascadeOperations =…
ad0ran
  • 326
  • 4
  • 15
0
votes
1 answer

Joining two records with the same key

Let's say I have these two objects: public class Employee : Person { public string Something { get; set; } } public class Person { public int Id { get; set; } public string FirstName { get; set; } public string LastName { get; set;…
asp_net
  • 3,567
  • 3
  • 31
  • 58
0
votes
1 answer

Many To Many Relationships not updating in Sqlite Extensions

Please pardon the wall of code, but I need to set the stage.... public class Student { public string Name { get; set; } [PrimaryKey] public string Id { get; set; } [ManyToMany(typeof(StudentStaff))] public List…
Charles
  • 11
  • 3
0
votes
1 answer

Unable to get Item from SQLite.Net Async PCL

I am struggling to get an Item by ID using the asynchronous API of SQLite.Net Async PCL. Here is my model class public class Invoice : IEntityBase { public Invoice() { LineItems = new List(); DateCreated =…
Val Okafor
  • 3,371
  • 13
  • 47
  • 72
0
votes
1 answer

SQLite.Net Extensions issue with InsertOrReplaceWithChildren

I am using SQLite-Net PCL together with SQLite-Net extensions for the development of an application using Xamarin. I have two classes A and B defined as follows: public class A { [PrimaryKey, AutoIncrement] public int Id { get; …
papafe
  • 2,959
  • 4
  • 41
  • 72
1 2 3
…
9
10