Stack Overflow
Stack Overflow

Questions tagged [sqlite-net-pcl]

69 questions
1
vote
1 answer

Visual Studio Installer Project packaging DotNetCore instead of Framework

I've been going circles on this one for over a day now. I have a WPF project that is making use of sqlite-net-pcl. I'm ready to package this project up into an MSI for distribution (x64). The first hitch was that I need to directly add the nuget for…
JKoplo
  • 1,562
  • 1
  • 10
  • 13
1
vote
1 answer

Unable to build my app after connecting it to sqlite

Ok so when i run my app i just get a : System.AggregateException which i tried to spot with the debuguer and it brings me to this function in the AgendaDatabase.cs file : public AgendaDatabase(string dbPath) { database = new…
codejourney
  • 319
  • 4
  • 15
1
vote
1 answer

SQLite System.DllNotFoundException: e_sqlite3 using sqlite-net-pcl

Hello,i'm trying to use SQLite in a Xamarin Forms project.But i'm getting a hard time making it work.I'm going to give information about my project configuration : Xamarin version -> 4.6.0.726 The strategy of code sharing -> .NET standard…
Jesé Abraham Chavez Rivas
  • 111
  • 1
  • 2
  • 9
1
vote
1 answer

Is calling 'Create Table' to keep database up to date a good practise?

I am new to Xamarin and SQLite so I'm asking myself what is a good practise to keep the database structure up to date, when a new column is added or so. To use the SQLite DB I am using SQLite-net-pcl. I have read about some solutions that use a…
CactusJack
  • 93
  • 1
  • 13
1
vote
1 answer

SQLite Database locking on reads

We are having an issue with a Xamarin.Android application we are building where there is database locking. As an overview of what the application does: Table A get's inserts into it. User presses a button to run a Scheduled Job to sync the data…
SmiffyKmc
  • 801
  • 1
  • 16
  • 34
1
vote
1 answer

create Multiple tables using Sqlite-net-pcl

I am using xamarin forms and Sqlite-net-pcl (nuget). I need help on creating multiple tables. I have set up the requirements as below. I need to do the following: 1) I need to create tables and database when the App launches. How to do this in…
MilkBottle
  • 4,242
  • 13
  • 64
  • 146
1
vote
1 answer

SQLiteAsyncConnection -> CreateTablesAsync() requires two type arguments

OS/X Mac Xamarin Forms Visual Studio Pro 2017 I'm trying to follow the wonderful course by Mosh Hamedani on Xamarin forms. I try to write the same code from lecture 89: var connection =…
Robert Achmann
  • 1,986
  • 3
  • 40
  • 66
1
vote
1 answer

Xamarin Sqlite-pcl-net Maximum value of a column

I am using latest version of Sqlite-net-pcl Nuget by Frank A. Krueger . I need to get the maximum value of the column AccountNumber from the table AccountMasterModel. I tried this public Task> GetAccountMaxAsync() { …
mohammed mazin
  • 445
  • 3
  • 15
1
vote
1 answer

Querying a table only returns null to a list in sqlite-net-pcl

so I've been trying a bit around sqlite-net-pcl and this just doesn't seem to be able to update the status... After trying around a bit with a teststring to somewhere localize the problem it starts with the first list which appears to be filled with…
Kael Tharas
  • 15
  • 5
1
vote
0 answers

SQlitedatabase unable to update and delete row

I am working with Xamarin forms and I have implemented SQLite database using Sqlite-net-pcl nuget package. The problem is that the database is initially saving a row but is unable to update or delete any row. Here is the code in which I save and…
Anshuman Singh
  • 1,018
  • 15
  • 17
0
votes
1 answer

No result with sqlite-net-pcl, xamarin at ios only

I am trying to use sqlite on Xamarin and has been implemented sqlite-net-pcl to create and access local database. Works very well on Android but I can't read records on iOS. Experiences experience = new Experiences() …
carlosbou
  • 3
  • 2
0
votes
0 answers

SQLite `GetWithChildren` methods stuck on iOS 16.2

I've been testing my Xamarin.Forms on iOS and ran into an error with the WithChildren methods in SQLiteNetExtensions. My code seems to get stuck in lines containing GetAllWithChildren and GetWithChildren, as if there's some deadlock issue in the…
E. Epstein
  • 739
  • 2
  • 11
  • 26
0
votes
2 answers

"System.TypeInitializationException: 'The type initializer for 'SQLite.SQLiteConnection' threw an exception.'"

So I am currently trying to develop a MAUI app using the sqlite-net-pcl nugget package. My app works fine in a Windows(Win11) enviroment, but throw an exception when I am using it on an Android device(Android 12). To sum up the porpuse of this app…
Bence Hérincs
  • 21
  • 3
0
votes
0 answers

Set password in sqlite .db3 file in xamarin forms

I'm using sqlite-net-pcl to develop a xamarin forms application using C#. I want to protect my .db3 with password but no property or function was found that fulfill my requirements. I need to know is there any solution to protect my db3 file? I need…
Morning Glimpse
  • 1
  • 1
0
votes
0 answers

sqlite-net-pcl order items by distance

I am trying to sort a SQLite table that contains coordinates by their distance to a reference position. I would like to execute this on the SQLite level, to avoid retrieving 100.000 items from the database. The problem is, that the Sqlite-net-pcl…
Dokug
  • 123
  • 8
1
2
3 4 5