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

SQLite.Net Extensions trigger not activated with recursive insert

I am using SQLite-Net PCL together with SQLite-Net extensions for the development of an application using Xamarin. I have a one to many relationship between two classes A and B defined as follows: public class A { [PrimaryKey,…
papafe
  • 2,959
  • 4
  • 41
  • 72
0
votes
1 answer

Sqlite.net doesn't create attributes of Sqlite.net Extension

My problem is that if I want to create two tables with a [OneToMany] relationship between these two. public class Order : BusinessEntity { [PrimaryKey] public Guid Id{ get; set; } [MaxLength(20)] public string Title{ get; set;} …
Thomas Loidolt
  • 41
  • 4
0
votes
1 answer

SQLite-Net Extensions Newtonsoft.Json version depedency

In the last version of the nuget package "SQLite-Net Extensions PCL", the required version of Newtonsoft.Json has been bumped to >= 6.0.0.5. Is there any particular reason for that ? Because of that I can't update the package in my Azure Mobile…
baramuse
  • 360
  • 2
  • 10
0
votes
1 answer

Version of SQLite.Net allowing page_size to be set on Xamarin?

Looking or some advice here. My Xamarin Forms PCL project is using SQLite.Net-PCL, SQLite.Net.Async-PCL, SQLiteNetExtensions and SQLiteNetExtensions.Async -- all of these are NuGets. It was disappointing to discover that SQLite.Net-PCL does not…
BillF
  • 1,034
  • 3
  • 13
  • 28
0
votes
0 answers

Allow NULL Foreign Keys with SQLite-net-extensions

I'd like to know if I can, with a SQLite database and SQLite-Net Exensions, add 2 foreign keys to the same table with, each time, one of the foreign keys empty. My structure is the following: [Table("Picture")] public class Picture { …
GwenGuts
  • 497
  • 1
  • 4
  • 12
0
votes
1 answer

SQLite.Net.Platform for Windows Phone 8.1

I can't find any SQLite.Net.Platform library that works with Windows Phone 8.1. These are not…
Vahid
  • 3,384
  • 2
  • 35
  • 69
0
votes
1 answer

Imitating an ObservableCollection class with an IList

I'm using SQLiteNet-Extensions to implement a OneToMany relation between a Playlist and an IList of Track. At the moment the only supported collection types by the library are List and array (I changed the library to allow IList as a List). Now I…
Benjamin Diele
  • 1,177
  • 1
  • 10
  • 26
0
votes
1 answer

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

I've a many to many relationship between students and classes using SQLite-net Extensions: public class Students { [PrimaryKey, AutoIncrement] public int StudentId { get; set; } public string Name { get; set; } …
user4126589
  • 51
  • 4
0
votes
1 answer

SQLite.Net Extensions with multiple foreign keys

I am getting the following error when attempting to create a one-to-many relationship that has a multi value foreign key... ** SQLite.Net.SQLiteException : foreign key mismatch - "Activity" referencing "Node" ** This is the table SQL (simplified for…
user3430360
  • 261
  • 1
  • 2
  • 6
-1
votes
2 answers

Binding dynamic query to DataGrid C# WPF

Is it possible to bind a query to a Data Grid without specifying the table or columns? Let's say I have this query: string query = "select PersonName from Persons' but it changes and next time I have: string query = "select Email from Persons' I'm…
user3688227
  • 123
  • 2
  • 12
-1
votes
1 answer

SQLite.Net Extensions - Delete Children on Update

I have the following two Classes. When I Save A with multiple Items (B) in it, I get the expected result. But when I save changes to A, such as an empty List of Items(B) I would expect that all elements in table B automatically get deleted because…
SYNT4X
  • 210
  • 2
  • 15
-1
votes
1 answer

SQLite net Extension one to many relationship Windows Phone

I'm using sqlite net extension to create one to many relationship for 2 tables that am using there are tables in my C# code i follow tutorial in official site https://bitbucket.org/twincoders/sqlite-net-extensions [Table("Stock")] public class…
adasd asdsad
  • 19
  • 1
  • 6
-1
votes
1 answer

How to use Sqlite-net Extensions for Windows 7?

I used sqlite-net library and I was creating sqlite connection similar to this : var db = new SqliteConnection(path); But Sqlite-net Extensions demand using Sqlite.Net.SqliteConnection that needs as a first parameter ISQlitePlatform and I didn't…
ig-melnyk
  • 2,769
  • 2
  • 25
  • 35
1 2 3
…
9
10