Global query filters are very handy when implementing tenant and soft deletion features. But my problem is is that when i write a query with joins, for instance
I am basically trying to implement CRUD using EntityFrameWork core and .Net core 3.1. I have an issue with my update operation where I am not able update the co
There are some times where I have a user and would like to check whether they are in the organization that owns the item they are trying to access. Let's say th
I'm trying to process DB migrations during application startup in a Azure-hosted web API. However, no matter where I try to put it, I get the exception: ObjectD
I'm using EF core TPH inheritance to model some data and I'm trying to write a query that will query across different subtypes. My current attempt at writing a
I have a problem, in database I have an object of class Catalog with 3 elements in CatalogUsers. I want to replace that list with 2 element list being the orgin
I am trying to use JSON_ARRAYAGG(JSON_OBJECT(...)) in Entity Framework Core but I don't know much how to trick Entity Framework Core to use this function with a
I had some changes in my ef context and I added new Migraions dotnet ef migrations add changed98112601 then I run the below command dotnet ef database upd
I have an OData endpoint which query collection of Cosmos entity. The Cosmos DB container name is dynamic so that I cannot use entity.ToContainer("<container
I am trying seed the database with some data, using ASP.NET CORE 3.0 and EF Core. I've created my DbContext and according to documentation, online sources, or
I have an error on update entities use efcore and automapper: Entity cannot be tracked because another instance is with the same key value I saw some answers an
I deployed a test console app to a linux server and everything works fine but when the code execute an Entity Framework Core query, I get this message in the co
I have built a Book app in ASP.NET Core razor pages CRUD using Entity Framework. However, when I run the app and view it on https://localhost:44370/, the Foreig
I have this sample query: context.BarcodeTipiDoc.AsQueryable().Where(d => d.Barcode.CompareTo(minBarcode) > 0); That query runs very slow because Entit
My error: The corresponding CLR type for entity type 'Employee' is not instantiable and there is no derived entity type in the model that corresponds to a conc
I am currently working on a school project with a classmate. We've decided on making the classic setup of an Administration-client (Blazor Server) and a Member-
I faced pretty strange behavior in my tests, when only one record from the set is not added to the database and this happens from time to time, not always. Here
What is the best way to insert data into multiple tables with one or more new rcords containing a foreign key to the first table using Entity Framework Core?
I have a database-first .net core 3.1 web application which connects to SQL Server database table with a geography column. The database scaffolding and applicat
I have a .NET Core 3.1 Web Api and I created an ApplicationUser class that inherits from IdentityUser because I need to register some others properties. But whe