I have a JSON string which is the following: [ { "id": 103001058774, "name": "status", "label": "Status", "description": "Ticket status", "choices": { "2": [ "Open", "Open" ], "3": [ "Pending", "Pending" ], "4": [ "Resolved", "Resolved" ], "5": [ "Closed",…
Following the tutorial on creating a web API with ASP.NET Core, with the tutorial's project files for reference, I created the exact project described with the DTO approach, which worked successfully using an in-memory database: builder.Services.AddDbContext<TodoContext>(opt => opt.UseInMemoryDatabase("TodoList")); Now I…
I am doing an API call which returns the following JSON as a string: [{ "id": 103000180455, "name": "Personal", "created_at": "2023-06-12T07:12:52Z", "updated_at": "2023-06-12T07:12:52Z", "personal": true, "responses_count": 1 }, { "id": 103000180454, "name": "General", "created_at": "2023-06-12T07:12:52Z", "updated_at": "2023-06-12T07:12:52Z", "personal": false, "responses_count":…
I have an xunit test fixture that uses testcontainers to spin up a docker container that is running sql server. When my test runs, I'd like to use EF Core to migrate the database - I can do this no…
I am trying to optimize my query for loading should be fast because once the data is 5000 thousand then records is coming after 2 minute of time. I am using two sps for my search for first SP by…
Following is the given JSON data: DECLARE @Jdata NVARCHAR(MAX) = '{ "EmployeeDetails": { "BusinessEntityID": 3, "NationalIDNumber": 509647174, "JobTitle": "Engineering Manager", "BirthDate": "1974-11-12", "MaritalStatus": "M", "Gender": "M", "StoreDetail": { "Store": [ { "AnnualSales": 800000, "AnnualRevenue": 80000, "BankName": "Guardian Bank", "BusinessType": "BM",…
I want to set variable either true or false based on Status column values, if any value is coming Cancel in Status column then I want to set variable as false OR want to set as true. I have query…
I want to display N numbers of table in ASP.NET webform based on user input. For example, user input -> PDO123045,PDO122111 In this case, user input two values seperated by commas, so if I split the comma, I get length…
I am trying to load a JSON file (output from Mongo's Export-MdbcData) into a SQL Server table using Powershell. The example JSON file data is as follows: { "code" : "0088", "name" : "BUTTON", "detail" : { "quantity" : 1…
I want integrate Flutter with an ASP.NET API. the problem is when I create minimal API, the JSON I retrieved from MapGet is a string, when I try to jsondecode() it give me: Expected a value of type 'String', but…