15 questions
10 votes
3 answers
5k views
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 { ...
7 votes
1 answer
10k views
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 ...
3 votes
2 answers
6k views
Android - The type initializer for 'SQLite.SQLiteConnection' threw an exception. ---> System.DllNotFoundException: e_sqlite3
On our Xamarin Android project we are trying to switch from sqlite-net to official sqlite-net-pcl package. However after this switch when creating a new SQLiteConnection I am getting following ...
1 vote
1 answer
4k views
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]...
0 votes
1 answer
1k views
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 ...
7 votes
6 answers
6k views
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. ...
4 votes
1 answer
9k views
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 ...
4 votes
1 answer
2k views
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 ...
2 votes
1 answer
2k views
SQLite: Retrieve child element from object in list
There is a Basket, which stores a List<Fruit>. Each Fruit has one Pip. If I store this relationship and retrieve it later, the ForeignKey PipId has a value, but the object Pip is null, despite I ...
1 vote
2 answers
2k views
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-...
1 vote
1 answer
960 views
Method 'SQLiteConnection.InsertAll' not found
I'm trying to get many-to-many database relationships working in my database on (currently) an Android Samsung S6 mobile. To this end I am using SQLite.Net-PCL 3.0.5 and SQLiteNetExtensions 1.3.0. I ...
1 vote
2 answers
1k views
ManyToOne constraint not working
I have very simple relationship, my model looks like this: public class Project { [PrimaryKey, AutoIncrement] public int ID { get; set; } public string Name { get; set; } [...
1 vote
4 answers
1k views
Use SQLiteNetextensions with Xamarin for Android-App
I've read some threads about SQLite for Xamarin but I'm still not able to set up SQLiteNetExtensions in a proper way. I'm currently developing an android app with Target Framework Android 7.1(API ...
0 votes
1 answer
2k views
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 working: https://www.nuget.org/packages/SQLite.Net.Platform.WindowsPhone8/ https://www.nuget.org/packages/...
0 votes
1 answer
1k views
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 ...