89 questions with no answers
1
vote
0
answers
67
views
Microsoft.EntityFrameworkCore.Sqlite TOP and LIMIT SQL syntax error
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 ...
- 760k
0
votes
0
answers
35
views
How can I force my own app to release a lock over its SQLite DB file?
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: ...
- 770
0
votes
0
answers
70
views
Sqlite is not saving new items after POST Request through ASP.NET Core
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 ...
- 51
0
votes
0
answers
269
views
Conflict between .NET Maui permissions and sqlite-net-pcl?
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 ...
1
vote
0
answers
429
views
How can I fetch data to dynamic List of Table in Maui from Sqlite Database?
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 ...
- 134k
2
votes
0
answers
261
views
Can't get case-insensitive searches on SQLite
Using SQLite I'm trying to do a case-insensitive search on a string column, however it's only returning results when the case matches the column exactly.
The connection is setup as:
new ...
- 2,933
0
votes
0
answers
48
views
Rank on SQLite SubQuery
I have a table Person with ID(Guid), FirstName(string), LastName(string) and 3000 entries. What I desperately need is the rank of a certain entry by ID in a sorted query by FirstName and LastName.
So ...
- 3,660
0
votes
0
answers
138
views
Clearing a SQLite table before saving data in it
I'm using SQLite.net (https://github.com/praeclarum/sqlite-net) in my Xamarin Forms project and trying to save a user's projects in the database.
In order to make sure there won't be any duplicates, I ...
- 31k
0
votes
0
answers
102
views
Using custom methods with SQlite.NET Filter predicates
We are using SQLite.NET (1.5.231) in a Xamarin project
We execute Get queries like this
var result = await db.Table<T>().Where(query).ToListAsync();
Where db is a SQLiteAsyncConnection and ...
- 3,438
0
votes
0
answers
331
views
Could not able to install SQLite.Interop.dll in .NETFramework,Version=v4.6.1 windows application
I have created the Desktop application with .NET Framework, Version=v4.6.1.
I have SQLite database.
I can able to communicate with the database in the development environment.
When I have created the ...
CommunityBot
- 1
0
votes
0
answers
328
views
Sqlite-net linq GroupBy cannot be translated
I am using Xamarin c# linq with sqlite-net pcl (https://github.com/praeclarum/sqlite-net). I found that all my linq groupby cannot be properly translated into SQL. Linq translates the Where clause but ...
- 27.1k
0
votes
0
answers
133
views
SQLITE One-To-One to same entity
I've been stuck for this whole day on one thing. Im using SQLITE to build a local database for my xamarin app and I wanted to insert some data as follow :
[Table("Localisations")]
public ...
- 123
1
vote
0
answers
386
views
SQLite in ASP.NET Core uses more and more RAM with every call
Queries that return a lot of data from an SQLite database use RAM that is never released. The RAM use is many times larger than the database and eventually leads to Windows out of memory errors and ...
- 675
1
vote
0
answers
386
views
Is there any way I can implement the views across multiple databases in SQLite?
I'm developing a cross-platform app using Xamarin. Now, for data storage I'm using both Online (through API) and offline(SQLite). The app I want to develop has dynamic UI and the UI configuration is ...
- 24.5k
0
votes
0
answers
42
views
I can't add data in to variable. Xamarin
Here I am trying to get the user which logged on the login page but I don't understand why _id, name and class can't get any data in the method.
public class Login
{
SQLiteConnection ...
- 4,832
0
votes
0
answers
1k
views
SQLite.TableQuery Member access failed to compile expression
Getting SQLite.TableQuery Member access failed to compile expression, while registering Async Table query
public AsyncTableQuery<AppStateEvent> AppStateEvents => this.Table<...
- 107
0
votes
0
answers
48
views
Allow User to Query Database flexibly but Preventing SQL Injection
One of the functionality that I'm developing allows end-user to view their own database like a Database Browser. I would like to allow them to Select and Update freely but not Drop or Delete. I'm ...
- 39.3k
3
votes
0
answers
154
views
Retrieve data from sqlite net with parameters and blob
I'm using sqlite-net and sqlite-net-extensions for the blob in a Xamarin.Android project.
I have this schema:
public enum TemplateCategories
{
Emojis,
Stars,
Hearts,
...
- 2,548
2
votes
0
answers
1k
views
Access is denied debugging ASP.NET Core app referencing Sqlite running in IIS
The ASP.NET Core 2.2 project references Microsoft.EntityFrameworkCore.Sqlite (2.2.3) as a PackageReference.
Debugging the app in IIS Express works fine, because of the elevated user process.
Problem:...
- 760k
1
vote
0
answers
189
views
Error creating table in sqlite when changing android to x64 on Xamarin
I had to change android build from x86 to x64, and after doing that an error occurs while trying to create a table in sqllite using xamarin
public ObraDao(ISqliteConnectionService connectionService)
...
- 718
0
votes
0
answers
84
views
UWP SQLite concurrency clarification
On my UWP app, I have a class named DBContext which provides a live connection to an SQLite DB on a singleton manner. I have a few heavy DB write statements to execute periodically which might take ...
- 1,593
0
votes
0
answers
237
views
How can I share local database of an existing app with a new app and make both work on it simultaneously?
One of my client's inventory management project supports online as well as offline mode to manage huge inventory data and is built using Xamarin.Forms & sqlite-net. Now, the client wants to create ...
- 125
1
vote
0
answers
715
views
Xamarin.Forms Shared Project: System.DllNotFoundException: /system/lib/libsqlite.so
I have been using the SQLite.cs and SQLiteAsync.cs classes in my Shared Poject for over a year without issue. However, Google now requires that you set Android projects with a target of at least 8.0 (...
- 3,881
0
votes
0
answers
504
views
Xamarin sqliteAsyncConnection Could not open database file
I'm using Visual Studio For Mac. I'm getting an exception error in my previewer stating
"An exception occurred while rendering the control".
When I click the exclamation mark for details it states
...
- 4,515
0
votes
0
answers
397
views
libmonosgen-64bit-2.0.so unauthorized access to "/system/lib64/libsqlite.so" Android 8.1
I'm using SQLite.Net-PCL nugget and when I try to deploy in a Android Device with API Level 24 I get this error "libmonosgen-64bit-2.0.so unauthorized access to "/system/lib64/libsqlite.so" The thing ...
