Stack Overflow
Stack Overflow

Questions tagged [sqlite-net-pcl]

69 questions
0
votes
1 answer

SQLite no such table error when table exists in xamarin

This is How I define my table as what this link: SQLite no such table error when table exists said [Table("RegUserTable")] [Serializable] [DataContract] public class RegUserTable { [PrimaryKey] [DataMember] public Guid UserId { get; set;…
paraJdox1
  • 805
  • 9
  • 23
0
votes
1 answer

Use SQLiteConnection and SQLiteAsyncConnection together

Given I use SQLite-Net NuGet package. I have old synchronous API for database manipulations (SQLiteConnection). What I need I want to use new asynchronous API for database manipulations (SQLiteAsyncConnection) Problem Old synchronous API is big…
picolino
  • 4,856
  • 1
  • 18
  • 31
0
votes
2 answers

How to query user information based on its username in Xamarin

I am trying to get the user gender and display it on my login page, so I can pass it to the next page after login. I am using textchange event to see if the username exists or not. This is my code: private void…
paraJdox1
  • 805
  • 9
  • 23
0
votes
0 answers

System.MissingMethodException when creating table in sqlite-net-pcl

When calling for this function to create the database, an error occurs System.MissingMethodException: 'Method not found: int SQLite.SQLiteConnection.CreateTable(SQLite.CreateFlags)' This is where it throws the error during the call for database =…
Jen143
  • 815
  • 4
  • 17
  • 42
0
votes
1 answer

Injection of CRUD service in Xamarin Forms

I try to experiment with new platform for me, Xamarin Forms. Based on .Net Core and EF Core knowledge I decided to begin with injecting Sqlite ORM service (sqlite-net-pcl) in Xamarin Forms Shell template included in Visual Studio 2019. In this…
Marek Słowikowski
  • 54
  • 9
0
votes
0 answers

Xamarin.Forms sqlite-net-pcl does not fill query result with values

I am working with Visual Studio Mac 8.3.2 and Xamarin.Forms 4.2.0 to create an app for iOS and Android. As db interface library I am using sqlite-net-pcl 1.6.292. I tried older versions, but the result is the same. On iOS everything is working fine.…
mschmitt
  • 169
  • 1
  • 6
0
votes
1 answer

Xamarin Android SQLite data reading gives me the "SQLite.SQLiteException: no such table: tblLidhja" exception

I am trying to build an Android Xamarin Application. I have created an SQLite database named regjistri.sqlite . The database it's not corrupted, I can open it via SQLite browser on my PC. This database I have save it to my android Documents…
Adnand
  • 562
  • 1
  • 8
  • 25
0
votes
1 answer

How to use asynchronous method in constructor when .Result() makes the method hang?

I have an AppearingCommand called when a Page appears in my Xamarin.Forms project, that eventually executes the following sqlite-net-pcl line: (I already have a mechanism coping with loading time) AppearingCommand = new Command( async() => { …
iSpain17
  • 2,502
  • 3
  • 17
  • 26
0
votes
1 answer

How to use ".OrderBy" in Xamarin.Forms with SQLite-net-plc?

I want to order my calendar entries I save in an SQLite Database to show them in a Listview. How can I order them with SQLite-net-plc? I thought that I could just write: .OrderBy but it didn't work and I tried to use an…
Maximilian Bülowius
  • 13
  • 2
0
votes
2 answers

UWP sqlite-net Async database access

On my UWP app, I'm using sqlite-net to access the database. According to their GitHub Page I'm using Source Installation. Now I want to migrate to using the Nuget package (To get the latest updates) and they have mentioned getting the PCL package.…
SurenSaluka
  • 1,534
  • 3
  • 18
  • 36
0
votes
0 answers

Windows Forms Application Crash After Starting To Use SQLite-net-pcl only on some computers

I used OLEDB in a C# Windows Forms Application but then I decided to change everything to SQLite-net-pcl because it was easier for me. After I finished everything, made sure there was no bugs - it works only in 2 out of 7 computers. What can I do?…
rom_totach
  • 106
  • 8
0
votes
0 answers

Visual Studio 2019 'failed to retrieve information' when adding Nuget package

I'm using Visual Studio 2019 and I'm attempting to add SQLite-Net-PCL to my project. However, when I go to "Project > Add Nuget Packages" and then select the SQLite package my console tells me this Getting restore information for project…
Tariq Khan
  • 27
  • 2
  • 6
0
votes
1 answer

I found a xamarin forms project which uses Azure, I want to do the same thing using SQLite

The project is a quiz app in xamarin forms using SqLite, in the code there needs to be a way to load the questions, I will show how they do it in Azure, I need to do the same thing but in SqLite. I have also included a link to the source code for…
Ross Seward
  • 15
  • 3
0
votes
0 answers

C# SQLite-Net Extensions 'SQLiteConnection does not contain a definition for CreateTable'

I am trying to use the SQLite-Net Extensions NuGet package in a WinForms application. I have included a reference within a class and am trying to follow the documentation found here: https://bitbucket.org/twincoders/sqlite-net-extensions However, in…
JohnWick
  • 4,929
  • 9
  • 37
  • 74
0
votes
2 answers

Accessing math functions with sqlite-net-pcl and Xamarin.Forms

When writing a C# console App, and using System.Data.SQLite, I am able to perform SQL commands such as: string cosfun = string.Format("UPDATE test SET cosColumn = column1*cos(20)); However, when I try using a similar command in Xamarin.Forms, using…
TwoChain
  • 1
  • 5
1 2 3
4
5