I am trying to write a web API which can generate XML, which canbe consumed by other application

See more:

web

API

I have a SP which is accepting two parameters and returning one table as data is coming from more than 3 tables.

I need to consume my SP in Web API to Generate desired XML.

PROC [dbo].[Sp_DATA1]
(
@schemecode nvarchar(10),
@month nvarchar(10)
)
AS
BEGIN
DECLARE
@totalnoofemployees int ,

.
.
.
.
.
.
.
 
 Savings int,
 remarks  nvarchar(500) 

 )
select @totalnoofemployees=count(employeedetails.name_of_employee)  from employeedetails where schemecode=schemecode  and month=@month 
select .
.
.
.

.
select @remark =remark from saving_details  where schemecode=@schemecode  and month=@month  




insert into @tab([Number_of_employees],
.
.
.
.
, Other_saving_due_to_process_improvement,savings,remarks)
 values
(@totalnoofemployees,
.
.
.
.
 @savingamount , @remark )

SELECT * from @tab
END

What I have tried:

when i am generating it by table it is showing data

public class EmployeesController : ApiController
  {
       public IEnumerable<beneficiarydetail> Get([ModelBinder]List<int> id)
      {
          emp_misEntities entities = new emp_misEntities();

          return entities.beneficiarydetails.ToList();
      }

  }

but when i tried to get data from SP :(