I am working on a middle size web application that handles projects, invoices etc. I struggle to optimize my filter query for a list of projects whenever I filter by subject's substring. It sometimes searches for up to one whole…
I am trying to delete a Record from Employee table based on EmpId which is the primary key (EmpId is also a foreign key for table Salary) using LINQ in asp.net web Api. But I am getting an error which…
I have a test which many records over time. I am using Postgresql to store these tests and records and I want to be able to search for tests that have records that fall within a certain time range. A…
Consider the following C# Code Fragment: public class Person { public int Id { get; set;} public string? Name { get; set;} public string? Description {get; set;} } List<Person>? _persons = new List<Person>(); // Something populates the _persons list; //Use…
I have an ASP.NET Web API project, and have implemented repository and unitOfWork patterns. I currently have a big SQL query that I want to implement in code, it includes a lot of tables and joins. My current solution is…
last time L had that type of retrieving data: var users = _context.Users.AsQueryable(); var userDtos = users.Select(user => new UserGetDto { Id = user.Id, Name = user.Name, SurName = user.SurName, Age = user.Age, Faculty = user.Faculty != null ? new…
I don't know why, when I execute this LINQ request, this exception is returned : System.InvalidOperationException: The LINQ expression '__ids_0 .Contains(StructuralTypeShaperExpression: Patron.Domain.RoleAggregate.Role ValueBufferExpression: ProjectionBindingExpression: EmptyProjectionMember IsNullable: False .Id.Value)' could not be translated. That is the code : public async Task<List<Role>>…
In this i have write two linq queries For Ascending order For Descending order i have done this in one way can you guy's suggest me to the another method for knowledge if exists. Here is the code // Specify…
So I've got two dbcontexts, to get data from various tables and I want to join them in a ViewModel. I know I should probably use .Join(), but I wondered if something like this was also possible: My Controller: public…
I want to know if this query I wrote for statistics is fast. It currently works in 3 seconds with the data and query I wrote below. Now I have a user table. Those whose role is Hr can create…