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

Inserting and updating with children in SQLiteNetExtensions is not working

I have followed the example in https://bitbucket.org/twincoders/sqlite-net-extensions and mine appears a really strange error "System.ArgumentException: Object of type 'System.Int32' cannot be converted to type 'System.String'." public class…
Lucas Koyashiki
  • 11
  • 6
1
vote
0 answers

sqlite references conflict when installing sqlite-net-extensions

I'm trying to add sqlite-net-extensions to my project, but seems like it's installing sqlite 3.05 instead of working with the existing 3.10 Getting this- Severity Code Description Project File Line Column Source Suppression State…
Oyiwai
  • 449
  • 1
  • 3
  • 20
1
vote
0 answers

Very slow sqlite (SQLite-Net Extensions)

I am using SQLite-Net Extensions on my Windows phone 8.1, insertion of 2000 rows tooks over 20 minuts due speed of my SD cart I think. But selection from database seems to be very slow too. Selecting of all my (2000) rows by ID(int) tooks about 120…
Josef
  • 43
  • 7
1
vote
2 answers

How to use SQLite-Net Extensions without Json.Net dependency (with alternative ITextBlobSerializer)?

I am writing a plugin (.Net Framework 4.61) that uses the SQLite-Net Extensions. These require Newtonsoft's Json.NET to be present for the ITextBlobSerializer. Json.NET in turn requires System.Numerics as a reference. The plugin can not use any…
Patrick
  • 1,235
  • 1
  • 12
  • 15
1
vote
1 answer

SQLite.NET Extensions Many To Many, no join table records created

I am new to using SQLite.NET and the Extensions. To my best ability I have followed the guides I've found but no records are being created in the many to many join tables and I've no idea why. I have a solution NuGet dependency on the…
Syntax
  • 2,155
  • 2
  • 23
  • 34
1
vote
0 answers

Inserting External Data in intermediate Table whith sqlite-net windows phone 8.1

I take a good moment trying to insert information in a table that has a relation created many to many in windows phone 8.1. Since I can do in order that the information is inserted automatic in the intermediate table? I am using sqlite-net for the…
Fernando
  • 21
  • 4
1
vote
1 answer

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 have had simple SQlite access working fine, but…
Kinetic
  • 700
  • 8
  • 15
1
vote
1 answer

How can a foreign key be mapped onto an object field in SQLite-Net Extensions?

Context: We are using SQLite-Net Extensions for local data caching with Xamarin. We plan on deploying to iOS, Android and Windows Phone. We have existing data structures used throughout our system (all implementing a common interface) that we would…
TomTom
  • 301
  • 5
  • 16
1
vote
1 answer

SQLite-Net populate ListView partially

I'm using SQLite-Net-PCL to read and write data to a local SQLite database. On one page of my app I need all entries from a specific table that match a query. I also need to retrieve the child entities with relationships to the parent model.…
nor0x
  • 1,213
  • 1
  • 15
  • 41
1
vote
1 answer

SQLite Async Connection missing WithChildren Methods

I have a Xamarin Forms project that uses SQLite. I have a parent and child Model with the correct Foreign Key, ManyToOne and Cascading options on relevant fields. I have been using Scott Hanselman's AsyncLock class…
callisto
  • 4,921
  • 11
  • 51
  • 92
1
vote
1 answer

Windows phone app with sqlite local storage

I'm trying to save my objects that I got back from my JSON into a local storage db with SQLite I've imported a lot of packages and also the SQLite framework. I've also made these two classes: Activity public class Activity : INotifyPropertyChanged …
Steaphann
  • 2,797
  • 6
  • 50
  • 109
1
vote
1 answer

SQLite-Net Extensions how to correctly update object recursively

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

SQLite-Net Extensions not inserting in cascade in some cases

I am using SQLite-Net PCL together with SQLite-Net extensions for the development of an application using Xamarin. In my model I have an entity (let's call it A) which is connected to other four entities through one-to-many relationships (that are…
papafe
  • 2,959
  • 4
  • 41
  • 72
1
vote
2 answers

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; } [ForeignKey(typeof(User))] public int ProjectManagerID {…
veeroo
  • 752
  • 6
  • 25
1
vote
1 answer

How can I create a OneToOne relationship using Sqlite Extensions

Basically I have a Clientclass and an Address class like the following public class Client { [PrimaryKey, AutoIncrement] public int Id { get; set; } public string Description{ get; set; } public string Email { get; set; } public…
codingpitch
  • 59
  • 8
1 2 3
…
9 10