Web API - Get Data from SQLServer

Return Data from SQLServer

1.Create a DB(table) in SSMS

2.Create a new Project called EmployeeService

3.Add ADO.NET EntityDataModel to get the data

• add a reference to the main project

4.Add a APIController in EmployeeService

5.Add the connection string from App.config in DataAccess to WebConfig

​