ASP.Net Web API 2 method not showing correct data but row count is correct

Question

I have written a method in Repository class for which I have created a Controller in Web API project. Following is my Model class:

namespace Meijer.Merch.Space.Data
{
    public class FloorplanAnalyst
    {
        public int EmpId { get; set; }

        public string EmpName { get; set; }
    }
}

Following is the method in Repository class:

public IEnumerable<FloorplanAnalyst> GetFloorplanAnalyst()
        {
            return this.Database.SqlQuery<FloorplanAnalyst>("GET_FLOORPLAN_ANALYSTS").ToList();
        }

Following is my Controller method:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web.Http;

namespace SpaceWebApi.Controllers
{
    /// <summary>
    /// Controller used for the retrieving of FloorplanAnalyst information
    /// </summary>
    public class FloorplanAnalystController : ApiController
    {
        private ISpaceRepository db = new SpaceRepository();

        /// <summary>
        /// Returns a list of FloorplanAnalysts.        
        public IEnumerable<FloorplanAnalyst> GetFloorplanAnalyst()
        {
            return db.GetFloorplanAnalyst();
        }
    }
}

But I am getting following records as my result (27 rows are returned):

    {
        "EmpId": 0,
        "EmpName": null
      },
      {
        "EmpId": 0,
        "EmpName": null
      }
}

In SQL Server correct data is returned when the stored procedure is executed. But at Web API end it is not correct.

Is GET_FLOORPLAN_ANALYSTS as stored procedure ?

CodeNotFound
– CodeNotFound

2016-02-10 06:55:46 +00:00
Commented Feb 10, 2016 at 6:55 — CodeNotFound
– CodeNotFound, Commented Feb 10, 2016 at 6:55
yes it is a stored procedure

Sormita Chakraborty
– Sormita Chakraborty

2016-02-10 06:58:36 +00:00
Commented Feb 10, 2016 at 6:58 — Sormita Chakraborty
– Sormita Chakraborty, Commented Feb 10, 2016 at 6:58

CodeNotFound · Accepted Answer · 2016-02-10 06:58:41Z

1

You have this issue because EmpId and EmpName properties into FloorplanAnalyst class don't match the columns name returned by your GET_FLOORPLAN_ANALYSTS stored procedure.

To solve this, make sure that each property have an associated column name (same name as the property) in the result query from your stored procedure.

answered Feb 10, 2016 at 6:58

CodeNotFound

23.4k10 gold badges75 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Sormita Chakraborty Over a year ago

I cannot change my stored procedure column names but I need EmpID and EmpName at front end. How do I make it possible?

Collectives™ on Stack Overflow

ASP.Net Web API 2 method not showing correct data but row count is correct

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related