locked
how to create restful web service json with sql server RRS feed

  • Question

  • User209803 posted

    can anyone help me how to create restful web service with my sql server database for get put request from app using json in .net

    Friday, June 3, 2016 7:00 AM

Answers

  • User205607 posted

    @"rohitkumar.6674" Not sure if you still need this several months later, but here's a walk-through using VS2017, ASP.NET Core and Entity Framework Core.

    https://docs.microsoft.com/en-us/aspnet/core/tutorials/first-web-api

    Azure App Service is a PAAS option. Stupid easy to get up and running. Simply create your entities with a POST request using Postman or cURL. Be careful if you don't have Azure credits, it can get pricey if you don't shut it down. Ask me how I know.

    https://azure.microsoft.com/en-us/services/app-service/

    When I want real CRUD (not just a mocked service) done fast and easy so I can get down to app coding ASAP, the quickest sol'n I've found is Sails JS.

    http://sailsjs.com/

    • Marked as answer by Anonymous Thursday, June 3, 2021 12:00 AM
    Monday, March 27, 2017 4:48 PM

All replies

  • User16200 posted

    Rohit,

    Creating WCF REST Service: http://www.codeproject.com/Articles/105273/Create-RESTful-WCF-Service-API-Step-By-Step-Guide

    For SQL Server Connection, Write your own Database class and configure the SQL Server configuration in Web config.

    Consuming WCF REST Service Data in Xamarin: https://developer.xamarin.com/guides/xamarin-forms/web-services/consuming/rest/

    Friday, June 3, 2016 7:57 AM
  • User209803 posted

    web service restful api in .net?

    Saturday, June 4, 2016 12:34 PM
  • User209803 posted

    mvc

    Saturday, June 4, 2016 12:35 PM
  • User12211 posted

    @rohitkumar.0378 said: web service restful api in .net?

    Did you actually follow the links @KathirVel provided? If so, you would already know the answer to that question.

    @rohitkumar.0378 said: mvc

    Is that a question or a statement?

    You need to be much more clear in your posts. I'm not sure how much help you expect to get with one word posts.

    Sunday, June 5, 2016 1:41 AM
  • User209803 posted

    i just want to make restful mvc api in .net the link is for wcf api

    Monday, June 6, 2016 4:23 AM
  • User179286 posted

    A much easier approach to a rest service is using nancyfx https://github.com/NancyFx/Nancy/wiki

    Monday, June 6, 2016 8:19 AM
  • User12211 posted

    @rohitkumar.0378 said: i just want to make restful mvc api in .net the link is for wcf api

    I'm not sure what RESTful and MVC have to do with each other. The RESTful service is just a mechanism for the client to say "I want something" and the server to say "Here you go". There's no MVC involved in that API.

    You've got to put a web service in front of your SQL server. How that web service is implemented doesn't matter as long as it has a way to enable RESTful access.

    Also, create a web service doesn't have anything to do with Xamarin. You won't be using Xamarin to implement the web service.

    Monday, June 6, 2016 6:45 PM
  • User247556 posted

    any sample project for create restful web service json with sql server

    Wednesday, August 24, 2016 6:47 AM
  • User283704 posted

    @KathirVel, thank you very much

    Friday, December 16, 2016 3:24 PM
  • User289171 posted

    Has any body used Coldfusion??? I used Coldfusion as RESTful service converting it to Json and using SQL Server in my Xamarin project. I tried making wcf api,just to compare it with Coldfusion, I found CF much easier and effective than wcf api.

    Sunday, March 26, 2017 6:10 PM
  • User205607 posted

    @"rohitkumar.6674" Not sure if you still need this several months later, but here's a walk-through using VS2017, ASP.NET Core and Entity Framework Core.

    https://docs.microsoft.com/en-us/aspnet/core/tutorials/first-web-api

    Azure App Service is a PAAS option. Stupid easy to get up and running. Simply create your entities with a POST request using Postman or cURL. Be careful if you don't have Azure credits, it can get pricey if you don't shut it down. Ask me how I know.

    https://azure.microsoft.com/en-us/services/app-service/

    When I want real CRUD (not just a mocked service) done fast and easy so I can get down to app coding ASAP, the quickest sol'n I've found is Sails JS.

    http://sailsjs.com/

    • Marked as answer by Anonymous Thursday, June 3, 2021 12:00 AM
    Monday, March 27, 2017 4:48 PM