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
1
vote
1 answer

How to use SQLite-Net Extensions with Composite keys

I have the following class: Class1.cs: [JsonObject(MemberSerialization.OptIn)] public class Class1 { [PrimaryKey] [JsonProperty("key1")] public string Key1 { get; set; } [PrimaryKey] [JsonProperty("key2")] public string Key2…
PkL728
  • 955
  • 8
  • 21
1
vote
1 answer

Return children using a Where clause

I'm using the SQL-NET Extensions in my Xamarin project. I am trying to return children emelments of my model using a where clause. Using the example models on the website: public class Stock { [PrimaryKey, AutoIncrement] public int Id { get;…
Joseph
  • 2,706
  • 6
  • 42
  • 80
1
vote
2 answers

Windows Phone 8.1 Sqlite-net foreign key relationship

I have installed sqlite-net from NuGet package in my windows phone universal app. But it does not contain foreign key relationship attribute between tables. I searched the web and found that SQLITE-Net Extenstions can handle this by using…
Muhammad Saifullah
  • 4,292
  • 1
  • 29
  • 59
1
vote
2 answers

Bulid SQLite-Net Extensions in visual studio professional 2013 but not successful

I am new to windows app and I am going to build the sqlite-net extension project to .dll file in order to make the models have the relationship attribute of one-to-many, one-to-one, many-to-many. Link:…
Brian Huang
  • 226
  • 2
  • 7
0
votes
0 answers

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 public int Id { get; set; } [Unique] …
OXO
  • 391
  • 1
  • 8
0
votes
0 answers

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 GetWithChildren, as if there's some deadlock issue in the…
E. Epstein
  • 739
  • 2
  • 11
  • 26
0
votes
1 answer

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 I am now editing an Item. So I will need to…
m4gik
  • 430
  • 5
  • 27
0
votes
1 answer

With SQLite-Net Extensions, is there a way to have List?

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 fine. What I want to do is to be able to add a…
VinceL
  • 299
  • 1
  • 3
  • 13
0
votes
1 answer

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 to the SQLite database on the device. Offline…
Wouter Van Hees
  • 51
  • 1
  • 8
0
votes
1 answer

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 trying to create a table (only happens in UWP , in…
Tecnopresley
  • 73
  • 1
  • 4
  • 14
0
votes
0 answers

Nested one-to-many tables SQLite-Net Extensions

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 Notes. My question is, is it possible to format my…
Knight Steele
  • 169
  • 4
  • 14
0
votes
1 answer

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 courses, but not the courses associated assessments…
Knight Steele
  • 169
  • 4
  • 14
0
votes
0 answers

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 write the CRUD methods to add/delete/load my tasks…
codejourney
  • 319
  • 4
  • 15
0
votes
1 answer

Checking if data exist in sqlite-net before inserting them to database

Im making an Xamarin.Android application that will use "templates" , template is this: [Table("Templates")] public class Template { [PrimaryKey, AutoIncrement] public int Id { get; set; } public int Category { get;…
CDrosos
  • 2,418
  • 4
  • 26
  • 49
0
votes
1 answer

Use SQLiteConnection and SQLiteAsyncConnection together

Given I use SQLite-Net NuGet package. I have old synchronous API for database manipulations (SQLiteConnection). What I need I want to use new asynchronous API for database manipulations (SQLiteAsyncConnection) Problem Old synchronous API is big…
picolino
  • 4,856
  • 1
  • 18
  • 31
1 2 3
…
9 10