WebAPI: Restful CRUD Operations in WebAPI Using ADO.NET Objects and SQL Server

Sign in to leave a comment.

• SS

  Sohil Sanghavi6y agoPosted Sep 14, 2020, 1:53 AM

  How to test the put delete and post without using fiddler
• AA

  abdulrehman anwar7y agoPosted Jul 9, 2019, 8:26 AM

  You are missing this [ActionName("AddEmployee")] please wite this code below httppost, as you declare for others get , and delete
• VO

  Viral Ondhiya7y agoPosted Jun 20, 2019, 12:05 AM

  Hi, nice explanation by this articles. but i have error in POST method. Null Reference Exception. occur in WebAPIViral.dll but not was handled use code .
• MH

  monir hossain7y agoPosted Jan 6, 2019, 2:12 AM

  Good article. Thanks a lot.
• DP

  devi prasad8y agoPosted May 13, 2018, 4:18 AM

  Getting error message port 57888 is in use
• DG

  donlot ganol8y agoPosted Nov 14, 2017, 3:18 AM

  Hai, i wanna ask to part get method, how can i show all data? because i tried ur code, i got 1 data only. thank u so much.
• MG

  Marcos Galaviz9y agoPosted Sep 13, 2017, 10:11 AM

  Hi I realy apreciate your code, Im new with "C", I use your example to get data from my own database and is great, but if a want to make for example a GetAllEmployees, do I have to doit in the same controller? Im confused I realy apreciate any help to understand it better :(
  • 

    Rohan Rao7y agoPosted Jun 27, 2019, 12:47 PM

    You can use the same controller as well as you can use different controller as well. You can do both ways. Just make sure that whenever you define a method in Controller for GetAllEmployees, you must bind the ModelClass correctly so that it gets bind with your database.
• SR

  Shams Rehman9y agoPosted Jan 31, 2017, 5:49 AM

  I know these methods and i have test also.Now i need complete project which is design.
• PG

  pranav gautam9y agoPosted Jan 27, 2017, 4:17 AM

  In my case its returng the type like its returning webApiDemo.Models.Employee
• AR

  ali rad9y agoPosted Jan 19, 2017, 2:28 AM

  G'day mate. for HTTPPost request you must determine Content-Type : application/json in Fiddler. it works correctly
• 

  Pankaj Gupta9y agoPosted Dec 5, 2016, 2:09 PM

  Delete is working but insert means " public void AddEmployee(Employee employee)" employee is taking null values...Plz guide.
  • VD

    veerapuneni dhana9y agoPosted Feb 8, 2017, 4:16 AM

    Same thing happens me while working with this .If you get the answer please forward to me also. thanks
  • 

    Zeeshan Azim9y agoPosted May 20, 2017, 6:45 AM

    For HTTPPost request you must determine Content-Type : application/json in Fiddler. It will show you data and work correctly.
  • PK

    P.Suresh Kumar7y agoPosted Apr 29, 2019, 6:03 AM

    I'm also getting the same error in postman. Get and Delete methods are working fine, but post Add method is not working even though when I chose application/json as content-type. It is throwing an exception - NullReferenceException.
• SK

  shashi kant10y agoPosted Jul 14, 2016, 6:50 AM

  Please tell me how to consume this to add record as I am getting object reference exception error.
• 

  Arvind Chourasiya10y agoPosted Apr 30, 2016, 7:05 AM

  and connection string is- string cs = "data source=GSPSDELL102\\SQLEXPRESS;database=LoadTest2010;max pool size=500;Pooling=False;Integrated Security=SSPI";
• 

  Arvind Chourasiya10y agoPosted Apr 30, 2016, 7:05 AM

  Getting error 404 while debugging with fidler my url is http://localhost:29455/api/Emp/GetEmployeeById/20 my project Name-WebApiDemo Controller Name-EmpContrller and Model Name-Employee.
• RM

  ranveer markad10y agoPosted Mar 1, 2016, 3:03 PM

  not work post method AddEmployee and Delete
• RN

  Ryan Nz10y agoPosted Feb 29, 2016, 7:01 AM

  Sorry to come back and ask again. Now I am testing the Post action. But I keep getting the object reference not set an instance of an object. This was tested with the sample demo provided but it didn't work either. Thanks for your help.
  • 

    Sidharth Rath10y agoPosted Mar 7, 2016, 12:49 PM

    instantiate the object employee=New Employee(); It will work..works for me. but I am still encountering the error while posting.
• RN

  Ryan Nz10y agoPosted Feb 29, 2016, 5:34 AM

  Now I found the reason. In the WebApiConfig.cs, the routeTemplate needs to be routeTemplate: "api/{controller}/{action}/{id}", For some reason the action is missing.
• 

  Sachin Kalia10y agoPosted Feb 28, 2016, 11:50 AM

  were you able to manage get request perfectly?
• 

  Sachin Kalia10y agoPosted Feb 28, 2016, 11:49 AM

  You may be confronting this error because you didn't choose POST option from dropdown just left to http://localhost:57888/api/Employees/AddEmployee .Please share me exact steps what are you performing..
  • RN

    Ryan Nz10y agoPosted Feb 28, 2016, 9:28 PM

    Thanks for your reply. Here is the error I kept getting http://screencast.com/t/gE9NgrVpiM. I think it must be something missing with the steps in the description because I downloaded your sample and it's working. I have not tried POST yet. Just testing GET for now and still error so far.
• RN

  Ryan Nz10y agoPosted Feb 28, 2016, 6:21 AM

  same problem here. Are you able to fix this?
• UQ

  uzair qurashi10y agoPosted Nov 12, 2015, 3:09 PM

  Hi.. hope u r fine... i have a problem when i test to post method in wep api using fiddler ..HTTP/1.1 404 Not Found is shown