Step 1 - First we have to create Employee Table
Step 2 - Now we have to create MVC 4 Web Application
Step 3 - In that we have to choose Web API and click OK Button
Step 4 - Then you will get empty Project
Step 5 - In Solution Explorer within Controller folder you will see by default Controllers. And we have to delete both controllers.
Step 6 - After that we have to add Entity Framework (ADO.NET) in Models Folder. Right click on Models Folder select ADO.NET Entity data model.
Step 7 - Connect your database where you created employee table.
Step 8 - After creating Model you will see model diagram like this.
Step 9 - After we have to create Controller. Right click on Controller folder choose
Add->Controller and click Add button.
Step 10 - After clicking add Button you will get empty controller like this.
Step 11 - EmpController.cs Code Behind
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Net;
  5. using System.Net.Http;
  6. using System.Web.Http;
  7. using WebAPI.Models;
  8. namespace WebAPI.Controllers
  9. {
  10. public class EmpController : ApiController
  11. {
  12. guruapiEntities db = new guruapiEntities();
  13. // GET api/emp
  14. public IEnumerable<employee> Get()
  15. {
  16. return db.employees.ToList<employee>();
  17. }
  18. // GET api/emp/name
  19. public IEnumerable<employee> Get(string id)
  20. {
  21. var list = from g in db.employees where g.name == id select g;
  22. return list;
  23. }
  24. // POST api/emp
  25. public HttpResponseMessage Post(employee value)
  26. {
  27. try
  28. {
  29. if (ModelState.IsValid)
  30. {
  31. db.employees.Add(value);
  32. db.SaveChanges();
  33. return Request.CreateResponse(HttpStatusCode.OK);
  34. }
  35. else
  36. {
  37. return Request.CreateResponse(HttpStatusCode.InternalServerError, "Invalid Model");
  38. }
  39. }
  40. catch (Exception ex)
  41. {
  42. return Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message);
  43. }
  44. }
  45. // PUT api/emp/5
  46. public employee Put(int id, string name, string mobile, string email, string address,string pwd)
  47. {
  48. var obj = db.employees.Where(n => n.id == id).SingleOrDefault();
  49. if (obj != null)
  50. {
  51. obj.name = name;
  52. obj.mobile = mobile;
  53. obj.email = email;
  54. obj.address = address;
  55. obj.password = pwd;
  56. db.SaveChanges();
  57. }
  58. return obj;
  59. }
  60. // DELETE api/emp/5
  61. public void Delete(int id)
  62. {
  63. var obj = db.employees.Find(id);
  64. db.employees.Remove(obj);
  65. db.SaveChanges();
  66. }
  67. }
  68. }
Step 12 - Run the application. Then you will get browser like this. And write API link in URL box here.
Step 13 - Then you will get output in XML format
Step 14 - If you want output in JSON format then add below code in WebApiConfig.cs.
  1. var appXmlType = config.Formatters.XmlFormatter.SupportedMediaTypes.FirstOrDefault(t => t.MediaType == "application/xml");
  3. config.Formatters.XmlFormatter.SupportedMediaTypes.Remove(appXmlType);
Step 15 - JSON Format output is
Step 16 - If you want particular data then make it back slash after emp and write a name then you will get particular data. In this API we done in LINQ Query.