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
2
votes
3 answers

How to create connection?

On this page https://bitbucket.org/twincoders/sqlite-net-extensions I found how to use SQLite-Net Extensions. But in order to start using it, there is a call: var db = Utils.CreateConnection(); How to implement this method?
Uros
  • 2,099
  • 7
  • 23
  • 50
2
votes
0 answers

Password protect a SQLite database with SQLite-Net Extensions

I want to password protect a SQLite database (not fully encrypt it) in a Xamarin project that uses MVVMCross and SQLite-Net Extensions. Even if the default SQLite Nuget seems to have a password option on creating the database connection, the…
Bogdan
  • 93
  • 6
2
votes
1 answer

Xamarin Sqlite-Net Insert (Object reference not set to an instance of an object)

I have a very strange problem that I can't figure out. I cannot insert a new item into my Sqlite DB. I keep receiving this error:- System.NullReferenceException: Object reference not set to an instance of an object. I literally have no idea why and…
Phill Wiggins
  • 2,577
  • 4
  • 28
  • 33
2
votes
2 answers

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.GetAllWithChildren(connection); The problem is…
a.toraby
  • 3,232
  • 5
  • 41
  • 73
2
votes
1 answer

Issue with SQLite and DateTime Accuracy

I am using SQLite.NET with Extensions in a UWP app to store an object containing a DateTime field and I'm getting weird results. It seems that dates are stored with a few hours off from what they should be, sometimes pushing the Day of the DateTime…
AndrewPno
  • 41
  • 4
2
votes
3 answers

Poor Performance Sqlite.net extensions

Hi I am developing a Xamarin app that load lots of lines ( around 10K ) I got really poor performance something like 2 minutes to insert 5K lines of an object. I use InsertOrReplaceWithChildren: public bool Insert_Update_Many(List obj) …
Ayrton Werck
  • 334
  • 4
  • 15
2
votes
1 answer

How to iterate throught multiple releated tables with SQLite-Net Extensions?

I'm trying to iterate throught multiple releated tables with SQLite-Net Extensions. But it didn't work. What am I doing wrong? foreach (var topTableItem in Database.GetAllWithChildren()) { foreach (var middleTableItem…
xyzabc
  • 45
  • 5
2
votes
1 answer

UWP SQLite-Net Extensions can't Insert Children

I install SQLiteNetExtensions from nuget using Visual Studio 2015 in a UWP project. This is my model: public class MovieItem { [PrimaryKey] public string Url { get; set; } [OneToMany(CascadeOperations = CascadeOperation.All)] …
Vinh Le
  • 101
  • 1
  • 3
2
votes
1 answer

Multiple one-to-one relationships to same table

Which is the best way to model multiple one-to-one relationships to a same table (sqlite-net-extensions)? I am looking for a solution like this: Class WayBill { [PrimaryKey, AutoIncrement] public int Id {get; set;} …
user2261054
  • 31
  • 4
2
votes
1 answer

Arrays of multiple (related) class types in SQLite-Net Extensions

Is there a way to have a collection of different class types which inherit from the same parent class in SQLite.Net Extensions? Ideally I would like to have an array of objects which conform to an interface or abstract class, however I can't even…
GS_Dan
  • 113
  • 2
  • 8
2
votes
1 answer

Sqlite.net extentions, Cant get data with GetWithChildren

I'm creating a database with serveral classes as children of other classes. Writing with foreign keys works fine however when i try to get the data back it throws the error: An unhandled exception of type…
Jurjen Biewenga
  • 43
  • 5
2
votes
1 answer

UpdateWithChildren not updating Lists (OneToMany) relationships

Here is some sample code to reproduce the problem: Customer class public class Customer { private int _id; [Column("_id"), PrimaryKey, AutoIncrement] public int Id { get { return _id; } set { if…
Ertay Shashko
  • 1,247
  • 2
  • 12
  • 21
2
votes
1 answer

How to set up an A -> B -> C relationship using SQLite-Net Extensions

I'm using MVVMCross and the SQLite-Net Extensions package to accomplish the following: public class StockGrouping { [PrimaryKey, AutoIncrement] public int Id { get; set; } public string Description { get; set; } …
PkL728
  • 955
  • 8
  • 21
2
votes
1 answer

Integrate SQLiteNetExtension with SQLite-net into a solution Xamarin

I want to try using SQLiteNetExtension with SQLite-net for a project in Xamarin. For the moment, I create a solution which contains : an Android Application (for the UI layer) an Android Library Project (which contains my data, business layer) I…
BlackRabbit
  • 78
  • 10
2
votes
3 answers

SQLite-Net Extensions Example on Xamarin Forms

I am intersted in using SQlite-Net Extensions (https://bitbucket.org/twincoders/sqlite-net-extensions) with Xamarin Forms. I am using Visual Studio 2013, SQlite.Net PCL 2.3.0 from NuGet, and a blank Hello World Xamarin Forms PLC project. As a first…
thedigitalsean
  • 269
  • 1
  • 3
  • 10
1 2
3
…
9 10