Questions tagged [sqlite-net-pcl]
69 questions
0
votes
1 answer
xamarin forms sqlite-net-pcl table not in db3 file
I am trying to make a cross platform app using a local sqlite db and I got the plumming for IOS and Android set up.
I get to the point where I can get the db using "adb.exe and pull". I use DB browser for Sqlite to view the db file. The file has no…
Jimmy
- 1
- 1
0
votes
1 answer
Xamarin SQLite-Pcl-Net DateTIme in Query
I am using Xamarin Prism along with Sqlite-pcl-net Nuget .
While I write Query to obtain the elements of table between a range of dates as follows
public Task> GetRecieptListAsync(DateTime startdate,DateTime enddate)
{
…
mohammed mazin
- 445
- 3
- 15
0
votes
1 answer
Xamarin sqlite-net-pcl accessing values of database internal
I'm using Visual Studio 2017, new to SQLite and can't get my head behind how I get to access the values saved in the database and get it back to the elements of the class.
public class MyObject
{
[PrimaryKey, AutoIncrement]
public int…
Kael Tharas
- 15
- 5
0
votes
1 answer
How can I update a SQLite record's attributes in C#?
I'm trying to update a SQLite record's boolean "Large" attribute in my code-behind. I'm using the sqlite-net-pcl Nuget package in Xamarin.Forms shared project.
I've figured out how to pass my record through to my method, but I can't get the…
Joe Morano
- 1,715
- 10
- 50
- 114
0
votes
0 answers
Xamarin app crash after installing a nuget package
In visual studio 2017 I have created a Xamarin PCL project and the app works fine but after installing a nuget package called sqlite-net-pcl it crashes at startup.
I have tried installing other versions of it and tried changing build to 259 from 111…
borop01
- 1
- 1
0
votes
2 answers
error while referencing sqlite-net-pcl package in Xamarin forms Android project
I am getting the following error when i attempt to reference the sqlite-net-pcl package in the Android project of Xamarin forms project. I get this error when building in release mode but debug mode seems to be fine.
I am using
sqlite-net-pcl…
TrustyCoder
- 4,749
- 10
- 66
- 119
-1
votes
1 answer
How to update every row using this function in database by getting the id of every row?
How do I update every row in sqlite-net-pcl database using this function by getting the id of every row even though i create new rows later on. To break it down, I need the id of every existing row in my table, and i need each one of that id to be…
Tejas Sethi
- 15
- 4
-1
votes
1 answer
Select exists vs count
I am using Sqlite-net-pcl. I need to which query is better to use.
I am searching in a table if there is at least one record.
First query
Select exists(Select 1 from invnentory where itemname='box2')
Second query
Select count(*) from inventory…
test test
- 9
- 3
-1
votes
1 answer
is sqlite-net-pcl library support one to many or many to many relationship - Xamarin
I am totally new to xamarin form and I want to create one to many relationships with sqlite-net-pcl library. Please help me to solve this problem.
Tayeb Himel
- 306
- 2
- 15