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

Edward Mahoney

5y5.9k.NET

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();
}

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Edward Mahoney5y ago
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];
}
Rijwan Ansari5y ago
Try something like this.
public async Taskoutput>> 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 Mahoney5y ago
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 Mohanty5y ago
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);
}