Create Read Operation in Web API Using MVC 4

private int _nextId = 1;

SqlConnection con;

SqlDataAdapter da;

DataSet ds=new DataSet();

public IEnumerable<product> GetAll()

{

con = new SqlConnection("Data Source=MYPC;Initial Catalog=MyDb;uid=sa;pwd=wintellect");

da = new SqlDataAdapter("select * from Employee", con);

da.Fill(ds);

foreach (DataRow dr in ds.Tables[0].Rows)

{

products.Add(new product() { Id=int.Parse(dr[0].ToString()),Name=dr[1].ToString(), desig=dr[2].ToString(),salary=int.Parse(dr[3].ToString())});

}

return products;

}

}

}

Step 7: Now, its time to create a Web API Controller that handles HTTP requests from the client. The Web API Controller contains two controllers in the Solution Explorer.

1. HomeController is a traditional ASP.NET MVC controller.
2. ValuesController is an example WebAPI controller.

Delete the ValuesController from the Solution Explorer under the controller folder.

Step 8: Now add a new controller, as follows:

• In Solution Explorer, right-click the the Controllers folder.
• Select Add and then select Controller.
• Name the controller EmpolyeeController.
• Select Empty API controller from dropdown list.
• Click the Add button.

Step 9: In this controller you can add an action for Get. The Get action is for fetching all Employee details from the database. It contains HTTP GET methods.

Here is the method to get the list of all products:

using System;

using System.Collections.Generic;

using System.Linq;

using System.Net;

using System.Net.Http;

using System.Web.Http;

using WebApi.Models;

namespace WebApi.Controllers

{

public class productController : ApiController

{

static readonly productdetails repository = new productdetails();

public IEnumerable<product> GetAllProducts()

{

return repository.GetAll();

}

}

}

In the above code we create a method name that starts with "Get" that automatically maps to GET requests from the client URI and has no parameters.

Step 10: Now, our Web API is ready to be used for read operations. Build and run this project on your local computer. It will generate a URL and the client will access the API at http://localhost:1240.

Step 11: The Client will get the complete list of Employees by entering this URI into your browser:

http://localhost:1240/api/product.