Create a new database, table, and producer. Just use the below query.

USE [ABCDB] G /****** Object: StoredProcedure [dbo].[PC_EmpMaster] Script Date: 7/22/2017 1:20:35 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO   CREATE PROCEDURE [dbo].[PC_EmpMaster] @Row_id BIGINT=NULL, @MODE VARCHAR(10)=NULL   AS BEGIN   SET NOCOUNT ON; IF(@MODE ='GET') BEGIN SELECT Row_id,Emp_Code,Emp_FName,Emp_Status,CONVERT(VARCHAR(12),Emp_DOB) AS Emp_DOB,Emp_Maritalstatus,Emp_Profilestatus,Emp_Expriance,Create_By,CONVERT(VARCHAR(12),Create_Date) AS Create_Date FROM EmpMaster   END ELSE IF(@MODE ='GETBYID') BEGIN SELECT Emp_Code,Emp_FName,Emp_LName,Emp_Role,Emp_Department,Emp_Address FROM EmpMaster WHERE Row_id=@Row_id END SET NOCOUNT OFF;   END GO /***** Object: Table [dbo].[EmpMaster] Script Date: 7/22/2017 1:20:35 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[EmpMaster](   [Row_id] [numeric](18, 0) IDENTITY(1,1) NOT NULL,   [Emp_Code] [varchar](10) NULL,   [Emp_FName] [varchar](50) NULL,   [Emp_LName] [varchar](50) NULL,   [Emp_Status] [bit] NULL,   [Emp_DOB] [datetime] NULL,   [Emp_Maritalstatus] [varchar](10) NULL,   [Emp_Role] [varchar](50) NULL,   [Emp_Department] [varchar](50) NULL,   [Emp_Address] [varchar](500) NULL,   [Emp_Profilestatus] [int] NULL,   [Emp_Expriance] [int] NULL,   [Create_By] [varchar](50) NULL,   [Create_Date] [datetime] NULL   ) ON [PRIMARY]

Simply insert some employee details in this table:

Create an EmployeeVM model class and convert as a list.

public class EmployeeVM   {   public List loadEmployeeList { get; set; }   }   public class EmployeeDetails   {   public long Row_id { get; set; }   public string Emp_Code { get; set; }   public string Emp_FName { get; set; }   public string Emp_LName { get; set; }   public string Emp_DOB { get; set; }   public string Emp_Maritalstatus { get; set; }   public string Emp_Role { get; set; }     public string Emp_Department { get; set; }   public string Emp_Address { get; set; }     public int Emp_Profilestatus { get; set; }   public int Emp_Expriance { get; set; }   public string Create_By { get; set; }   public string Create_Date { get; set; }   public string Mode { get; set; }   public bool Emp_Status { get; set; }   }

Create a SQL Data Access class MasterImplementation in the Implementation folder.

public EmployeeVM GetEmployeeDetails(EmployeeDetails empDetails)  { EmployeeVM vmGetGrid = new EmployeeVM();   SqlParameter[] prms = new SqlParameter[2];   prms[0] = new SqlParameter("@Row_id", "");   prms[1] = new SqlParameter("@MODE", "GET");     DataSet ds = new DataSet();   ds = (new DBHelper().GetDatasetFromSP)("dbo.PC_EmpMaster", prms);   if (ds != null)   {   if (ds.Tables[0].Rows.Count > 0)   {   vmGetGrid.loadEmployeeList = ds.Tables[0].ToList().ToList();   }     }   return vmGetGrid;   }   Now, you can access this class from the Web API controller:

  [HttpGet]   #region GetEmployeeDetails   public HttpResponseMessage GetEmployeeDetails(EmployeeDetails empDetails)   { try   { var Response = EmployeeMaster.GetEmployeeDetails(empDetails);   var Result = this.Request.CreateResponse(HttpStatusCode.OK, Response, new JsonMediaTypeFormatter());     return Result;   }   catch (Exception ex)   { HttpError Error = new HttpError(ex.Message) { { "IsSuccess", false } };   return this.Request.CreateErrorResponse(HttpStatusCode.OK, Error);   } } #endregion

Create an HTML file and set this as the start page.

Web api Service is up

Once running the application, the Web API REST services are ready for consuming.

You can easily check the custom HTTP request using an advanced REST client. After downloading, open it from your Chrome Apps List.

Enter the correct URL and select the right HTTP verbs on the header.

Once you click Send, it should hit the Web API Service.

Finally, the Web API is working perfectly. You get your result in JSON format and RESTful connection.

Conclusion

In this article, we have seen the technique of using the SQL Helper class in building Web APIs. If you have any queries, please tell me through the comments section.

Happy Coding!