Questions tagged [microsoft.data.sqlite]
26 questions
0
votes
1 answer
Error parsing connection string with AAD user credentials
On Azure account, I have created an AAD user.
I created Azure SQL database and assigned the newly created AAD user as a Server administrator.
The server has both AAD account login and SQL Server login.
I tested connecting to server through SSMS…
Andrija
- 14,037
- 18
- 60
- 87
0
votes
1 answer
How can i use e_sqlcipher with microsoft.data.sqlite?
I'm trying to switch my app over from access to SQLite, and id like to have encryption. I am trying to use "Microsoft.data.sqlite" with "SQLitePCLRaw.bundle_e_sqlcipher", but setting the password seemingly does nothing. Following the official guide…
bdwixx
- 37
- 1
- 6
0
votes
1 answer
How to deal with SQLite in an asynchronous project
SQLite is not asynchronous, and the exposed Microsoft.Data.Sqlite ADO.net *Async methods are implemented synchronously under the hood.
My question: how would you use SQLite in a asp.net core 5 API project which could benefit from asynchronous code,…
Ynv
- 1,824
- 3
- 20
- 29
0
votes
1 answer
SQLite encryption in Microsoft.EntityFrameWork
I’m currently trying to encrypt SQLite database with official SEE extension when using Microsoft entity framework.
I’m able to encrypt database when using ADO.NET. However getting an error “You specified a password in the connection string, but the…
0
votes
3 answers
Open SQLite connection in UWP right after moving StorageFile
Prologue:
I am writing SQLite GUI client for UWP. I use Microsoft.Data.Sqlite library for SQLite API with C#. Also I use a redirection table to be able to open database within my sandbox app which is published in Microsoft Store. Redirection table…
fnc12
- 2,241
- 1
- 21
- 27
0
votes
0 answers
Why is my SQLite database table not being found, when it is is in the expected location?
I'm getting this err msg:
...with this code:
SqliteConnection conn = new SqliteConnection(connStr);
String query = "INSERT INTO dbo.CartographerMain " +
"(MapName, MapNotes) " +
…
B. Clay Shannon-B. Crow Raven
- 8,547
- 144
- 472
- 862
0
votes
1 answer
How can I build my SQLite connection string in a UWP App?
In my Windows Form app, I was able to build my SQLite connection string like this (after adding the .db file to my project via Add > Existing Item):
string connStr = string.Format(@"Data source={0}F4F.db", Application.StartupPath);
So I tried the…
B. Clay Shannon-B. Crow Raven
- 8,547
- 144
- 472
- 862
0
votes
0 answers
Registered conversion for Entity Framework Core in C# is not called when querying with Contains? Any workaround?
I am trying to figure out why the conversions defined for my SqliteDbContext below are not considered when a Contains is necessary in a request:
public static class FSharpOptionExtensions
{
public static T DefaultFromOption(this…
Natalie Perret
- 8,013
- 12
- 66
- 129
0
votes
1 answer
When running test project in Dot Net 4.6.1, SQLitePCLRaw throws TypeInitializationException
I have a test project targeting net452, net461, and netcoreapp20. Everything runs fine under net452 and netcoreapp20, however, when I run net461 I get a System.TypeInitializationException
here is the stack trace
Unhandled exception:…
BenCamps
- 1,694
- 15
- 25
0
votes
1 answer
Sqlite metadata query fails with Microsoft.Data.Sqlite, works with System.Data.SQLite
I have a simple query taken directly from Microsoft's documentation (see https://learn.microsoft.com/en-us/dotnet/standard/data/sqlite/metadata) that is failing. According to the documentation, queries against sqlite_master should work as intended,…
joelc
- 2,687
- 5
- 40
- 60
-1
votes
2 answers
WITH RECURSIVE looping through every day in the database and SUM number between two dates for each
I struggle with the last part below, the "with recursive". Of course I could loop over TimestampOrigin using C#, for every day in the database. Which would mean hundreds of times the same query. But it may be possible with one query using "with…
Rene M
- 103
- 2
- 7