I have this code: foreach (ContactImportRequest row in toImport) { Contact contact = _mapper.Map<Contact>(row); // if first or last names are null, we fill them with anything because are required fields if (contact.FirstName == null || contact.FirstName.Equals("") || contact.FirstName ==…
I have a .NET application that’s trying to connect to a SQL Server instance running in a Docker container. I’m using Docker Compose to manage my services, which include my .NET application and SQL Server. Here’s the relevant part of…
When I try to update my .EDMX with update model from database, I get the following error: Query processor could not produce a query plan because of the hints defined in this query. Resubmit the query without specifying any hints…
I am designing an online store (ASP.NET Core 6) for an accounting software (C# Winforms). I started this using ASP.NET Core and Razor pages. I am new and inexperienced in this field. The accounting software has many tables in SQL…
I am trying to improve the performance of a query. I was thinking of using AsNoTracking(), but I am not sure if the location where it is put will make a difference i.e.(before Select() or after, before Include() or after,…
Screenshot of errorI am getting an SQLException pointing at the 'GetAllItems()' method below in the ItemsService. "Invalid column name OrderID1" I have two entities, the Order and Item and I wanted the OrderID associated with each item to be display…
I have the following function that takes a BookForUpdateDto and updates the Book entity based on the updated properties. When I try to update items inside of a ICollection of the Book it works all right when adding one item…
I am making project in asp.net 6 mvc, and i have to execute complex query contain joins, union and all. I want to fetch data from the database. How to do that through "FromSqlRaw"? We can fetch data through 'FromSqlRaw'…
I have problem with EntityFramework relationships. I want to create a relationship between User, Restaurant and Menu Item, the question is why is the Entity Framework screaming even though I have added an optional "int?" to the UserId property? After…
I want to create a relationship between the menu items and the restaurant - each menu item can have one restaurant and the restaurant can have multiple menu items, I would like to set this up in a one-to-many relationship,…