In Entity Framework Core 9.0.9, the query builder fails with SQLite Syntax builder.Services.AddDbContext<MyDbContext>(fun options -> options.UseSqlite(connectionString) |> ignore It ...

I am very new to all of this (coding in general, C#, .NET MAUI, MVVM practices, SQLite) so excuse me if my inexperience shows. The context I have an app that has a database with a table Cars. To make ...

I have a UNO platform application that is trying to use SQLite-net-pcl. While this seems to work fine in iOS in release mode in MacCatalyst in release mode i get the following error I am trying to ...

I am working on a MAUI application which uses sqlite-net-pcl as its ORM. When I try to delete the DB file from the app (System.IO.File.Delete(dbFilePath)) I get the following exception on Windows: ...

Here is necessary code segments in my program. My .NET project is .NET MAUI multiproject application. It has different projects for different platforms; WinUI, iOS, Maccatalyst, and Android too. I'm ...

I have a database in a Maui app that has two tables. The first table was setup with a class like this: public class Groups { [PrimaryKey, AutoIncrement] public long Id { get; set; } public ...

I've configured the ASP.NET Core Web API using controller to use Sqlite as the database, and after the request of adding new item, the item is not being saved to the database. The POST request ...

I have the following method which is inside a database context class for a .NET MAUI project. I have tested the SQL query in a DBMS without an error, so know it should be working. Using Debug....

I'm trying to create a counter for a card game, and I'm trying to store the "Matches" with the points on a Database. I have installed the nuget package sqlite-net-pcl, and I'm getting the ...

I have a field in my Model that I want to [Ignore] during SqliteConnection.CreateTable<myModel> but I also use the CommunityToolkit.Mvvm [ObservableProperty] and this is causing an error for ...

I am an amateur, trying to write an app that uses a sqlite database. I want the app to have read/write access to the Documents folder on my Android phone. However, I am having trouble with read/write ...

I have a database created with SQLite in my C# project. In a function, I like to filter the record in a table using Linq. For this reason, using this code for the And function, I wrote Expression<...

Currently when I insert a new object in my database, it goes to the same table based on the data type. For example: sqlDatabase.Insert(myObject); // -> goes to MyObject table. Is it possible to ...

I want to fetch data from SQLite database in Maui using raw Query. But while trying this function I am getting error: >{System.ArgumentNullException: Value cannot be null. (Parameter 'type') at ...

Running the following code, there is an error in the OrdersPrice=g. Sum (p=>p.TotalPrice) line, Why? I want to query the sales data of the corresponding Managers for Orders within the past month, ...