I have a .net web api that use postgresql. Backend is deployed on azure. Sometimes this error occures. I have max_connection set to 50, and I think it should be enough. In my code i use Entity Framework Core. How…
Table : Id, Name,Subject,Score 1 Pinky English 60 2 Pinky Maths 40 3 Mahesh Maths 50 4 Rani Maths 50 5 Rani Eco 50 I want to fetch record from table ,when Subject is maths, need record whose score should…
Table data: Id_Org_hierarchy Hierarchy_Name Parent_Id_Org_hierarchy 1 OGt 0 2 NHT 1 3 BATCH 1 2 3 Voice 1 I need result Like Below: Batch1(NHT,OGT) Details : Id_Org_hierarchy column value is present in Parent_Id_Org_hierarchy and so on its a tree struct…
I have a postgres database where I use ef to control my migrations code first. I currently have this table/class. public class Notification { [Key] public Guid Id { get; set; } = Guid.NewGuid(); public string ActionType { get; set;…
enter image description here I can't find exactly where I got the error because I took a break for a while, can you help me? As I said, when I search for possibilities, I can't find it exactly. There was…
I am using .NET 6 and PostgreSQL database. I have a hosted service, which periodically calls repository's function and is querying database entities using EF Core as so: public class NotificationRepository : INotificationRepository { public async Task<List<Notification>> GetUnreadDeviceNotifications() { using…
How to make a .NET API dynamically work with any table in the database without explicitly creating a separate class for each table? I tried to implement this using .NET reflection. I am currently using: .NET Entity Framework C# PostgreSQL…
I have a table SliceStatements (DB: PostgreSQL) that has a column Payload. The column's datatype is String but the string is in json format. The json has field rows which is an array of objects. It is known that each…
I've faced the problem with using ExecuteDelete in the abstract generic class. Can someone explain in what cases ExecuteDelete and ExecuteUpdate cannot be used? Tagret framework is set to .Net 7 Here is how my code looks: using Microsoft.EntityFrameworkCore; namespace…
I wonder how to initialize a property like this in EntityFramework: public class Activity : Model { public User User { get; set; } } User looks like: public class User : Model { public string Email { get; set;…