So, I’m building a function that works with models, which contains optional models of itself, which in all is working, except for on delete, where it leaves all children behind. After fighting this for a couple of hours without progress I ...
databaseanswers.net Latest Questions
We are using Entity Framework Core 6 and SQLlite with Spatial data in our tests (xunit). in our .csproj we have <PackageReference Include="Microsoft.EntityFrameworkCore.Sqlite" Version="6.0.2" /> <PackageReference Include="Microsoft.EntityFrameworkCore.Sqlite.NetTopologySuite" Version="6.0.2" /> <PackageReference Include="SQLitePCLRaw.provider.sqlite3" Version="2.0.4" /> here is how we setup SQLite: var builder = new DbContextOptionsBuilder<DataContext>(); builder.UseSqlite("Data Source=:memory:", ...
I want to store date & time in my Db in format DD/MM/YYYY HH24:MI:SS:MS. E.g, 15/10/2022 22:42:43:682. But it is actually stored in DB as Oct 15 22:42:43. I couldn’t find any relative info except for to_char method which actually converts ...
I know similar questions have been asked but here me out. As stated in the title, an exception is thrown when trying to add data to a table that has an identity column as its primary key. Identity is ticked for ...
Good morning. I am using c # and sqlite3. In sqlite3 I created an Archive table with 100 rows and 20 columns. In these 100 lines there are 20 numbers per line ranging from 1 to 90 which are displayed ...
I am trying to allow remote access to my SQL Server. The purpose is to check user status, which is located on a database in my SQL Server. When accessing the Server is attempted, an error message is ...
I create maui windows app that show over 3000 person’s data in listview in one of pages . the problem is : when enter the page of list view the memory usage increase but when back memory usage not released.
I have a GamingLimit class with a composite key that uses the properties PersonalNationalIdHash and Timeframe as composite key. // GamingLimit.cs public class GamingLimit { public string? PlayerNationalIdHash { get; set; } public decimal Limit ...
I have a C# query using linq with two datetime fields Im trying to compare. The datetime field in the Postgres DB is stored as timestamp with time zone. However for some reason I am receiving "function date_trunc(unknown, timestamp with ...
i’m trying to put in place a relation with a distriminator (i think) in EfCore 6 I have Users, Posts and Groups linked to multiple Tag through a many-to-many relationship defined with an entity Tagging. We are on PostGreSQL. I can’t figure ...