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

How to make SQLite foreign keys with SQLite.Net-PCL

In UWP, I enjoy the benefits of using SQLite.Net-PCL, creating classes to be used in apps as ObservableCollections to bind to the GridView. After including SQLiteNetExtensions to build a database with foreign keys, I've noticed that the foreign…
detailCode
  • 537
  • 1
  • 8
  • 22
10
votes
3 answers

Sqlite extension is not working as expected

I am working on an WinRT app. I want to use sqlite-net-extensions to support OneToMany, ManyToMany. using SQLiteNetExtensions.Attributes; using SQLite; [Table("WorkFlow")] public class Workflow { [PrimaryKey, AutoIncrement] public int…
Brian Huang
  • 226
  • 2
  • 7
7
votes
5 answers

SQLite-net-pcl - Always returning ID as 0 (Xamarin)

I recently moved across from SQLite.NET to SQLite-net-pcl due to the Android 7.0 SQlite issue. In the process I have updated all my libraries and all is working well with regards to insert/drop etc. The only issue I have is that every time I…
Phill Wiggins
  • 2,577
  • 4
  • 28
  • 33
7
votes
1 answer

SQLite-Net Extension both one-to-one and one-to-many relationships between two entities

I am using SQLite-Net PCL together with SQLite-Net extensions for the development of an application using Xamarin. In my model I have two entities, let us call them A and B, that are connected by both a one-to-one and a one-to-many relationships.…
papafe
  • 2,959
  • 4
  • 41
  • 72
6
votes
1 answer

Using SQLite-Net Extensions and OneToMany relation

I'm having difficulty trying to implement an SQLite-Extensions example for Windows Phone 8.1 that features a OneToMany relation. I'd really like to use this feature but I'm pulling my hair out trying to get it to work. Like in this question, when I…
omnir
  • 123
  • 1
  • 5
5
votes
3 answers

SQLite-Net Extensions Compatibility with SQLite-Net PCL (note no period)

Basically my question boils down to if SQLite-Net Extensions (NuGet Link) is compatible with Frank A. Krueger's SQLite-net PCL. As I understand it, at some point Oystein Krog created a fork to improve things in the past (possibly before Frank…
Steven_BDawg
  • 796
  • 6
  • 21
4
votes
1 answer

How to work with nested classes and lists in my table?

I'm using SQLite as a database and I have the following table, which works, when I create it: public class TodoItem { [PrimaryKey, AutoIncrement] public int ID { get; set; } public string Name { get; set; } public string Notes { get;…
testing
  • 19,681
  • 50
  • 236
  • 417
4
votes
1 answer

Can't seem to get OneToMany relation working

I'm very new to Mobile App Development so i'm trying to teach myself. I'm using Xamarin and sqlite-net (extensions) for this particular app i'm trying to make. I have 2 classes with a OneToMany relationship class Game { [PrimaryKey,…
Jinse
  • 63
  • 1
  • 8
4
votes
1 answer

SQLiteAsyncConnection UpdateWithChildren not available

I am trying to implement a OneToMany relationship inside my PCL using SQLite.net. I have the async extensions package (SQLiteNetExtensions.Async) and I am basing the code on the example found in …
Carl
  • 841
  • 1
  • 13
  • 33
4
votes
1 answer

How to: Nested Lists in SQLite-Net Extensions

How to: Do nested lists in sqlite-net-extensions Answer Found: Keeping the question as an example of how to do it. The problem i encountered was not sqlite-net-extensions related, but i'm keeping the question for context. [Old Question] I've got a…
Cicero
  • 2,872
  • 3
  • 21
  • 31
4
votes
2 answers

One to Many relationship in SQLite Xamarin

I am building a Xamarin mobile app, and I have a set of products that I get from a rest api. Each product can have n number of images. I have set the relationship of the table using SQLite-Net Extensions. However, when I insert the values into the…
Libin Joseph
  • 7,070
  • 5
  • 29
  • 52
4
votes
2 answers

SQLite Net Extensions OneToMany relationship not inserting/saving/updating Children

I'm attempting to use SQLite Net Extensions to do a note taking app for games, it uses 3 layers of models, Game [1 has many *] Character [1 has many *] Note [1 applies to *] Character I am using Xamarin in Visual Studio Community 2015 and installed…
Tom 'Blue' Piddock
  • 2,131
  • 1
  • 21
  • 36
4
votes
1 answer

Multiple @OneToOne on same object with SQLite.Net.Async Extensions PCL 1.3.0?

Is it possible to have multiple OneToOne relationships within an entity using SQLite.Net.Async Extensions PCL 1.3.0? Example: [Table("body")] public class Body { [OneToOne(CascadeOperations = CascadeOperation.All)] [Column ("left")] …
dynamokaj
  • 471
  • 7
  • 19
4
votes
1 answer

Using Textblobbed in sqlite-net-extensions

I'm trying to map a complex class in sqlite but something seems to be wrong because when I retrieve my objects the complex fields are empty. Shortly, my class is something similar: public class Contact { [PrimaryKey, AutoIncrement] public…
Caio
  • 61
  • 5
4
votes
1 answer

How to specify a foreign key property in SQLite-Net Extensions

How do I specify a foreign key that references a specific property instead of the primary key? For example the Stock class has a uuid property. And I want to create a foreign key in the Valuation class that references it using this property. In the…
Alexei Vinidiktov
  • 169
  • 3
  • 8
1
2 3
…
9 10