All Questions
28 questions
0
votes
1
answer
183
views
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 ...
- 450
0
votes
0
answers
70
views
Nested one-to-many tables SQLite-Net Extensions [duplicate]
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 ...
- 365
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 ...
- 365
1
vote
1
answer
546
views
How to create two foreign keys to the same table with SQLite in Xamari Form
I working in a project with Xamarin Form using C#. I'm trying to create two foreign keys to the same table, using this code:
[Table("Posts")]
public class Post
{
[PrimaryKey]
public long ...
- 51
2
votes
1
answer
394
views
Trouble forming data structure for SQLite in C#
I am trying to build a very simple Xamarin app that functions similarly to a Exercise/Day Planner. The SQLite database should hold a "Day"s table, and every day should relate to an "Activity"s table ...
- 35
0
votes
1
answer
122
views
How to use sqlite-net extension "https://bitbucket.org/twincoders/sqlite-net-extensions"?
How can I Implement sqlite-net extension "https://bitbucket.org/twincoders/sqlite-net-extensions"? I am downloading the code from the url but not getting how to use it.
- 1,459
0
votes
1
answer
884
views
sqlite-net-extensions - InsertWithChildrenAsync
I'm trying to create a table using the "sqlite-net-extensions". But the problem is always returning with error.
The error that returns is "Read only".
I created two models to create the tables.
...
1
vote
0
answers
780
views
sqlite-net-extensions -- Create Table Async
My problem is that I'm using the CreateTableAsync method and is always returning "0". I researched and saw that this return is a mistake.
I wanted to know what I'm doing wrong.
Class Service Table:
...
0
votes
1
answer
628
views
SQLite Extensions exception: ManyToOne relationship destination must have Primary Key
You can see the error in title.
There are my table classes:
public class Cars : Table
{
[NotNull]
public string name { get; set; }
[ForeignKey(typeof(Models)), NotNull]
public int ...
- 1,844
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 ...
- 20.3k
2
votes
1
answer
3k
views
Retrieve object with all child elements (and sub child elements)
I want to retrieve an object, which itself has some properties which are of type object. These child objects again contain some object as properties.
If I try to retrieve the data from the database I ...
- 20.3k
4
votes
1
answer
4k
views
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 ...
- 20.3k
2
votes
1
answer
746
views
Many-to-many relationship using Sqlite-net extensions, getting NotSupportedException: Don't know about System.Collections.Generic.List
I have a new Xamarin Forms application where I'm trying to make use of Sqlite-net and Sqlite-net extensions for an ORM. I've followed This guide to create the n:n. Here are my two objects, as well as ...
- 3,155
0
votes
1
answer
133
views
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 ...
- 16.8k
2
votes
2
answers
4k
views
GetAllWithChildren() performance issue
I used SQLite-Net Extensions
in the following code to retrieve 1000 rows with their children relationships from an Sqlite database:
var list =
SQLiteNetExtensions.Extensions.ReadOperations....
- 3,391