In production, my ASP.NET project works well and returns the query below, in about 12 seconds: [HttpGet("suggest/{id1}/{id2}/{id3}")] public async Task<List<int>> GetRecommendedShows(int id1, int id2, int id3) { List<int> showIds = new List<int>() { id1, id2, id3 }; // Fetch all…
I have a .NET 7 solution with an API Gateway: one API is the Gateway, and two others WebAPI1 and WebAPI2. These three APIS are dockerized projects. I have another container - a SQL Server dockerized database. My computer OS…
Existing Data { "Attr1": "AAAAAAAAA", "Attr2": 70, "Attr3": null, "Attr4": false } I want to insert in below format right after the Attr2 both exists "NewAttr": { "SourceTable1.Column1": "12xx12", "SourceTable2.Column2": "0192xx" } Column1 exists but not Column2 "NewAttr": { "SourceTable1.Column1":…
I've got a table in my database that contains a bunch of JSON paths and the values at those paths. I want to take the data in that table and construct a JSON object out of it. I'm more of…
I am using ASP.NET as a backend to an application to update some data in a separate system's SQL Server. I have a query that needs to insert many rows to a table. In each row, the values being inserted…
There is this error and I tried to change my Dockerfile but nothing seems to work. I'm currently on MacOS 14.3 and working with Docker for Desktop Heres part of my file that's probably causing problems: FROM php:8.3-fpm RUN apt-get…
I need to remove some values in a JSON array if they match with values from another table, if match id and pax: Here is some data declare @T1 Table (id int ,pax int ,rooms nvarchar(512)) declare @T2 Table (id…
I am hosting a site on IIS (Windows Server 2022), and trying to implement a simple register-login system via simple ASP.Net Core Web API, but while I can manipulate database internally, I cannot do it externally, nor via the curl…
I'm trying to load a Handsontable with JSON data from SQL Server using SQL Server's "FOR JSON AUTO" option and the jQuery AJAX POST method. The issue is the data being returned from the WebMethod function I use to retrieve…
I have an API in AWS that cannot connect to SQL Server (different EC2 instances) I am able to connect to the database using SSMS on my laptop, and the API is using the same connection string Both EC2 instances…