Can't return a type of IHttpActionResult - WebAPI

L A

Hello all,

Firstly, this question is about WebAPI. But as i didnt found WebAPI under Category Dropdown, i posted under .NET General.

I'm working on MVC WebAPI, where WebAPI Performs a GET operation. But i'm unable to return type of IHttpActionResult.

Below is my WebAPI GET Action method.

public IHttpActionResult GetDataFromDB()
{
try
{
using (var ctx = new AdventureWorks2012Entities())
{
var query = (from d in ctx.Departments
join h in ctx.EmployeeDepartmentHistories
on d.DepartmentID equals h.DepartmentID
join s in ctx.Shifts on h.ShiftID equals s.ShiftID
join e in ctx.Employees
on h.BusinessEntityID equals e.BusinessEntityID
join p in ctx.People
on h.BusinessEntityID equals p.BusinessEntityID
select new
{
Name = ((p.FirstName == null ? "" : p.FirstName) + " " +
(p.MiddleName == null ? "" : p.MiddleName) + " " +
(p.LastName == null ? "" : p.LastName)), MaritalStatus = (e.MaritalStatus == "M" ? "Married" : "Single"),
Gender = (e.Gender == "M" ? "Male" : "FeMale"),
Designation = e.JobTitle,
Department = d.Name,
MajorBranch = d.GroupName
}).ToList();
if (query.Count == 0)
{
return NotFound();
}
return Ok(query);
}
}
catch (Exception) { return null; }
finally
{
}
}

Above code is working fine when i debug & Line # 29 show data in List format. But on browser it displaying as Error.

I can view output on Fiddler.

Please suggest me to figure out my mistake & achieve this.

Thanks in advance.

3 Replies

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

Manikandan Murugesan9y ago
Accepted answer
Refer the following Links : https://docs.microsoft.com/en-us/aspnet/web-api/overview/getting-started-with-aspnet-web-api/action-results

http://www.c-sharpcorner.com/UploadFile/89bfaf/action-results-in-web-api/
L A9y ago
Thanks Manikandan Murugesan, Ravi Patel for your suggestions/ comments.
Ravi Patel, i tried using your code but the same error showed up. Manikandan Murugesan, as per Micorsoft docs link shared by you, i created a new Model class with all the response data properties
public class ResponseDataModel
   {
       public string Name { get; set; }
       public string MaritalStatus { get; set; }
       public string Gender { get; set; }
       public string Designation { get; set; }
       public string Department { get; set; }
       public string MajorBranch { get; set; }
   }
and updated Line # 15 in above given code as
select new ResponseDataModel
and it worked.!!

Thanks again for helping me.
Ravi Patel9y ago
Hi ,
Try this

public IHttpActionResult GetDataFromDB()
{
try
{
using (var ctx = new AdventureWorks2012Entities())
{
var query = (from d in ctx.Departments
join h in ctx.EmployeeDepartmentHistories
on d.DepartmentID equals h.DepartmentID
join s in ctx.Shifts on h.ShiftID equals s.ShiftID
join e in ctx.Employees
on h.BusinessEntityID equals e.BusinessEntityID
join p in ctx.People
on h.BusinessEntityID equals p.BusinessEntityID
select new
{
Name = ((p.FirstName == null ? "" : p.FirstName) + " " +
(p.MiddleName == null ? "" : p.MiddleName) + " " +
(p.LastName == null ? "" : p.LastName)), MaritalStatus = (e.MaritalStatus == "M" ? "Married" : "Single"),
Gender = (e.Gender == "M" ? "Male" : "FeMale"),
Designation = e.JobTitle,
Department = d.Name,
MajorBranch = d.GroupName
}).ToList();
if (query.Count == 0)
{
ModelState.AddModelError("error","No record found");
return BadRequest(ModelState);
}
return Ok(query);
}
}
catch (Exception ex) {
ModelState.AddModelError("error", ex.Message);
return BadRequest(ModelState);
}

}