I have an ASP.NET Core 7 app that uses SQL Server as a database. I want to dockerize the app and connect to Microsoft SQL Server image to use the database. When I run docker-compose and build the image from…
I convert .NET apps with MySQL to SQL Server, before that working on hosted server after converting working from my local system successfully apps connecting to SQL Server, but same after publishing and on a live Windows Server with IIS,…
I have JSON like this: { "_key": { "id": "3b8d1ed7-c3ec-32ec-a083-2ddc17152e94", "rootId": "15c85327-9628-3685-b84a-375b546ba92a", }, "employeeInfo": { "idNumber": "3", "gender": "Male", "age": 20, .... }, "product": { "plan": "prod", "class": "1", "_type": "Product", ... } } And I want to receive new…
I have an ASP.NET Core 6 Web API (User.API) that I'm trying to run in a Docker container, alongside a separate SQL Server container. My goal is to deploy these containers on a friend's machine without requiring them to install…
I'm using next request to get json from some json type column in POSTGRES: SELECT jsonb_strip_nulls(json_build_object( 'employee', c."info"->'employee2', 'product', c."info"->'product2' )::jsonb) as info FROM item."Item" AS c WHERE "rootId" = '40a8cb67-84f8-33b5-87dc-e1b039858d43' GROUP BY "id") ...; jsonb_strip_nulls omits unnecessary fields with…
I'm trying to just have a basic connection with a SQL Server (not in a container) that is running on my local dev machine (Windows 11) and connect to it using a windows container. I keep getting an error similar…
I am trying to execute a stored procedure which inputs data to my database. I am setting up my parameters as follows: ($conn has my db creds, $xml contains data from an XML file) $params = array( array($xml->filenumber, SQLSRV_PARAM_IN, SQLSRV_SQLTYPE_VARCHAR(20)),…
I am facing issue with inserting the JSON array into tables Doc Table : Id, Name, Desc, RefName, IsActive Con Table : Id, Field, Criter, DId, Conjunction, IsActive We map doc table Id Column to DId column This is sample…
I have a table in SQL SERVER to keep all of the users app reviews. When the user reviews the app with 4 or 5 stars I recieve a Json like this one { "Calificacion": 5, "Cuestionario": "", "Comentarios": "",…
I've written a Python script that connects to SQL Server housed in a Virtual Machine hosted in our Azure Environment. I've been able to successfully connect and run the query locally within the Virtual Machine but when I deploy to…