Create GET method in WEB API using .Net

WEB API is used to Create RESTFUL service with ease. Previously we have discussed how to create POST method, now we are going to create GET method using WEB API.

GET Method without parameter used to fetch all the records.

GET Method with parameter used to fetch the specific records which matches the parameter value.


 1.      Create new Project with WEB API as below


This will create the new project of WEBAPI in MVC framework.


2.      Right Click on the controllers and add new WEB API Controller as shown below.



Name your WEB API controller accordingly, I have named it as EmployeeController.      


3. Right click on the Model folder and add ADO.NET Entity Data Model as shown below.


Entity Data Model wizard asks you to select what the model should contain, Select EF designer from Database as shown below.   




Click on Next and Choose Data Connection by selecting new connection.


After Clicking New Connection, it will prompt the new popup to enter server details, userid, password and selecting the database.


After test connection is successful click on OK and your connection string will get generated as shown below


Select the Entity framework version and Click the Next button.


Select the Table that is necessary for accessing the data as shown below.


  Click on Finish that will generate the EDMX file with table name and columns as shown below.

  


On EmployeeController.cs we can find multiple functions remove all the except POST method and replace the code as below.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Net;
using System.Net.Http;
using System.Web.Http;
using WEBAPIGETPROJ.Models;

namespace WEBAPIGETPROJ.Controllers
{
    public class EmployeeController : ApiController
    {
        public HttpResponseMessage Get()
        {
            try
            {
                using (ACT2_MINIQEntities entities = new ACT2_MINIQEntities())
                {
                    var employeesList = entities.EmployeeDetails.ToList();
                    return Request.CreateResponse(HttpStatusCode.OK, employeesList);
                }
            }
            catch (Exception ex)
            {
                return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex);
            }
        }

        public HttpResponseMessage Get(int id)
        {
            try
            {
                using (ACT2_MINIQEntities entities = new ACT2_MINIQEntities())
                {
                    var employee = entities.EmployeeDetails.FirstOrDefault(x => x.ID == id);
                    if (employee != null)
                    {
                        return Request.CreateResponse(HttpStatusCode.OK, employee);
                    }
                    else
                    {
                        return Request.CreateErrorResponse(
                            HttpStatusCode.NotFound, "Employee with id" + id + " not found"
                            );
                    }
                }
            }
            catch (Exception ex)
            {
                return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex);
            }
        }
    }
}


Test Output using POSTMAN or Browser (because of Get request)