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

Set result of query to DataGrid or ListView by SQLite.NET

Is it possible to set result of query directly to DataGrid (without mapping to object). I have some dynamic reports and I want to only display it in Grid, without set columns,etc. Usually it'not problem because I "mapped" my data to an objects in…
user3688227
  • 123
  • 2
  • 12
0
votes
3 answers

SQLite.Net Extensions with Many-To-One doesn't work as expected

My table will contain many repeating strings like domains. For minimize database size I want save only unique domains in other table and use domains id in main table. All times I did it manually, but a short time ago I found out SQLite can did it…
Geograph
  • 2,274
  • 23
  • 23
0
votes
1 answer

OneToMany Relational Database

I have the following json object, where I am trying to store them in two different tables in the sqlite. Here is the scenario, I download a set a students first and check the database, and everything looks great. However, when I get another set of…
casillas
  • 16,351
  • 19
  • 115
  • 215
0
votes
3 answers

Many to Many "self"-relation SQLite: is it possible?

I'm using SQLite.net and SQLite-Net Extensions. I would like to create a many to many self-relation. In my case I have a child class with some siblings, of course the siblings are still of child type. Therefore I tried to implement a manytomany…
Alex Gimondi
  • 84
  • 1
  • 11
0
votes
2 answers

I lose the foreign key when I update children in object with other foreign key

I'am using SQLite.NET-PCL and SQLiteNetExtensions OBJECTS: public class Object1 { [PrimaryKey, AutoIncrement] public int id { get; set; } [OneToMany(CascadeOperations = CascadeOperation.All)] public List ListObject2 { get;…
Francisco Possetto
  • 443
  • 1
  • 3
  • 10
0
votes
1 answer

Automatically set entitykey in One-to-One relationship with SQLite-Net extensions

In a Xamarin project using SQLite-Net extensions, I have two entities: Project and ProjectSettings. These entities have a one-to-one relationship. The Project entity has an auto-increment Id. When I initially save a project, the Id of the Project is…
Dominic
  • 4,572
  • 3
  • 25
  • 36
0
votes
1 answer

Ways to use relationship between database tables w/o using SQLite-Net Extensions

What are various ways to have relationships (One-to-Many, Many-to-Many, etc) between database tables. I don't want to use SQLite-Net Extensions. Does anyone know any sources for this. If you know one, kindly give a very simple example of doing…
Anil
  • 193
  • 3
  • 14
0
votes
2 answers

Old records change (undesirably) after adding new Many-to-Many object

When I add new Many-to-Many object, some relationship fields value in old records are set to null or 0 (Reference: Image 1). Also some previous intermediate tables record are deleted (Reference: Image 2). Here is the code: Models: public class…
Anil
  • 193
  • 3
  • 14
0
votes
1 answer

SQLite and SQLite-Extensions can not perform OneToOne relationsip

I'm using SQLite-Net-Extensions. I'm attempting to define a OneToOne relationship so that when my Accounts model is loaded it will also include the Campaign so that I can access the campaign name. The problem is Accounts.Campaign is always null. I…
BugHunterUK
  • 8,346
  • 16
  • 65
  • 121
0
votes
1 answer

SQLite-Net Extensions unable to create tables with OneToOne relationship

I created two classes, Item and Warranty. Item holds a reference to Warranty, and Warranty is tagged with a foreign key attribute. I'm following the same pattern as on the wiki page, yet I keep getting "doesn't know about Warranty" error. Here's…
haosmark
  • 1,097
  • 2
  • 13
  • 27
0
votes
1 answer

Many to Many relationship not updating properly in Sqlite-Extensions

I'm creating a chat app in Android using sqlite-extensions for creating relationships between database tables. Here's the wall of code to set the stage: Conversation Table public class Conversation { [PrimaryKey, Unique, AutoIncrement] …
Ahmed Mujtaba
  • 2,110
  • 5
  • 36
  • 67
0
votes
1 answer

Delete Cascade not working

I have two tables in my database, one for recipes and one for their ingredients. When a particular recipe is deleted, I want all its ingredients gone as well. I have declared a one to many relationship with cascade attribute set but when I delete…
Tehreem
  • 939
  • 2
  • 14
  • 31
0
votes
1 answer

SQLite and SQLite Net Extensions - where's the Foreign Key Constraint?

I am just confused here (maybe I am missing something?) I've been pulling my hair out trying to work out why on earth my SQLite DB created using the sample on sqlite-net-extensions is not creating foreign key relationships
MemeDeveloper
  • 6,457
  • 2
  • 42
  • 58
0
votes
1 answer

Foreign Keys wont create in SQLite database using SQLite.net

I am trying to set up a SQLite database using SQLite.Net and SQLiteNetExtensions. I cant seem to get the foreign keys to create in the database. I have dropped all tables and used the model classes to recreate them again. I have checked the…
Ashley Goldstraw
  • 127
  • 1
  • 1
  • 4
0
votes
1 answer

Saved items are empty when retrieving at a later point

I am using Xamarin and C# to make a cross-platform app. SQLite.Net Extensions are being used for the local database. The User table contains a list of registers, as seen below: public class User { [PrimaryKey, AutoIncrement] public int…
user2283597
  • 229
  • 2
  • 20
1 2 3
…
9 10