Return from ASP.NET Core Web API a dictionary, not List

Question

I found your article below excellent. Great job. https://www.c-sharpcorner.com/article/apiasp-net-core-web-api-entity-framewor-call-stored-procedure-part-ii/ My question is how do I get a non list JSON response returned. The person consuming the json wants a dictionary, not a list. My stored proc returns one row so no list is needed. So from your example I want { "appointmentId" : 2, "returnCode" : 1, "submittedTime" : "2020-12-06T15:19:10.87" } not this: [ { "appointmentId" : 2, "returnCode" : 1, "submittedTime" : "2020-12-06T15:19:10.87" } ] public async Task >> Getoutput(Input input) { string StoredProc = "exec CreateAppointment " + "@ClinicID = " + input.ClinicId + "," + "@AppointmentDate = '" + input.AppointmentDate + "'," + "@FirstName= '" + input.FirstName + "'," + "@LastName= '" + input.LastName + "'," + "@PatientID= " + input.PatientId + "," + "@AppointmentStartTime= '" + input.AppointmentStartTime + "'," + "@AppointmentEndTime= '" + input.AppointmentEndTime + "'" ; //return await _context.output.ToListAsync(); return await _context.output.FromSqlRaw(StoredProc).ToListAsync(); }

Rijwan Ansari · Answer

Try something like this. public async Task output >> Getoutput(Input input) { string StoredProc = "exec CreateAppointment " + "@ClinicID = " + input.ClinicId + "," + "@AppointmentDate = '" + input.AppointmentDate + "'," + "@FirstName= '" + input.FirstName + "'," + "@LastName= '" + input.LastName + "'," + "@PatientID= " + input.PatientId + "," + "@AppointmentStartTime= '" + input.AppointmentStartTime + "'," + "@AppointmentEndTime= '" + input.AppointmentEndTime + "'" ; // return await _context. output .ToListAsync(); var spOutput = await _context. output .FromSqlRaw(StoredProc).ToListAsync(); return await spOutput.firstordefaultasync(); } First get list response then take firstordefault value.

Edward Mahoney · Answer

Thank you Kiran and Rijwan. You definitely pushed me in the right direction. This is what you need to do: 1) Remove IEnumerable from method signature 2) Still use ToListAsync() on the SP result set 3) Instead of using return statement when executing SP exec SP into local variable 4) return hard coded first occurance of zero base List public async Task > GetOutput_spGetIntDeploymentInfo(args_spGetIntDeploymentInfo input) { string StoredProc = "exec spGetIntDeploymentInfo " + "@packageName= '" + input.PackageName + "'" ; var spOutput = await _context.result_spGetIntDeploymentInfo.FromSqlRaw(StoredProc).ToListAsync(); return spOutput[0]; }

Edward Mahoney · Answer

Kiran, Thanks for the quick reply. I have included screen shot below. I was hoping when I removed IEnumerable from the return this would allow me to move forward. I have tried your suggestionvplus quite a few others. No luck. Thoughts?

Kiran Mohanty · Answer

If your store procedure returns only 1 record then change API return type as below. public async Task > Getoutput(Input input) { //api logic return await _context.output.FromSqlRaw(StoredProc); }