c# - REST api does not Return Values in SmartObject tester

Question

I Have a Problem. I have a REST Api thats working pretty well. Does everything i want it to Do. Now when I Load it inside Postman, it works fine Like this

REST on Postman

Now it works fine in Postman, Should i then move it into the Smartobject Tester, it does not show anything. Looking Like this in Smartobject Tester

REST API in SmartObject Tester

Could it be because I didnt make it to Return the Values in Json?

PS

My code Looks somewhat Like this ::

using EmployeeRESTAPI.Models;
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Net;
using System.Net.Http;
using System.Web.Http;

namespace EmployeeRESTAPI.Controllers
{
    public class EmployeeDBController : ApiController
    {
        string MyconnectionString = "Data Source=DLX;Initial Catalog=EmployeeDB;Integrated Security=True";
        // GET api/<controller>
        public IEnumerable<EmployeeDB> Get()
        {
            SqlConnection con = new SqlConnection(MyconnectionString);
            DataTable dt = new DataTable();
            con.Open();

            string query = "select* from [EmployeeDB].[dbo].[EmployeeTable]";
            SqlDataAdapter adapter = new SqlDataAdapter(query, con);
            adapter.Fill(dt);

            List<EmployeeDB> empdb = new List<Models.EmployeeDB>(dt.Rows.Count);
            if (dt.Rows.Count > 0)
            {
                foreach (DataRow empdbrecord in dt.Rows)
                {
                    empdb.Add(new ReadEmployee(empdbrecord));
                }
            }
            return empdb;
        }

        // GET api/<controller>/5
        public IEnumerable<EmployeeDB> Get(string accountnumber)
        {
            SqlConnection con = new SqlConnection(MyconnectionString);
            DataTable dt = new DataTable();
            con.Open();

            string query = "select * from [EmployeeDB].[dbo].[EmployeeTable] where accountnumber = '" + accountnumber + "'";
            SqlDataAdapter adapter = new SqlDataAdapter(query, con);
            adapter.Fill(dt);

            List<EmployeeDB> empdb = new List<Models.EmployeeDB>(dt.Rows.Count);
            if (dt.Rows.Count > 0)
            {
                foreach (DataRow empdbrecord in dt.Rows)
                {
                    empdb.Add(new ReadEmployee(empdbrecord));
                }
            }
            return empdb;
        }

        // POST api/<controller>
        public void Post([FromBody]string value)
        {
        }

        // PUT api/<controller>/5
        public void Put(int id, [FromBody]string value)
        {
        }

        // DELETE api/<controller>/5
        public void Delete(int id)
        {
        }
    }
}

标签： c#sql-serverrestk2