How to create Web Api that handle CRUD operation on SQL Server

Question

User-1980778524 posted

HI,

I need to create Web Api to handle CRUD operation on SQL Server.

Any1 can provide me a good reference tutorial for this ?  How to handle the CRUD for SQL server?

How the Native Client like Win10 DeskTop app consume the Web Api ?

Thanks

Answer 1

User753101303 posted

Hi,

Have you tried https://www.asp.net/web-api already? You could use EF or ADO.NET as usual (being in a web API doesn't change anything to db access). On the client side you have an HttpClient class which is discussed at https://www.asp.net/web-api/overview/mobile-clients/calling-web-api-from-a-windows-phone-8-application

You could also have a look at https://blogs.windows.com/buildingapps/2015/11/23/demystifying-httpclient-apis-in-the-universal-windows-platform/

Or if you have seen this already do you run into particular issues?

Answer 2

User36583972 posted

Hi SkyDriving,

Any1 can provide me a good reference tutorial for this ?  How to handle the CRUD for SQL server?

The following links for your reference.

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

http://www.c-sharpcorner.com/uploadfile/97fc7a/webapi-restful-operations-in-webapi-using-ado-net-objects-a/

Asp.net Web API CRUD Operations in SQL Database Using Entity Framework:

https://code.msdn.microsoft.com/Aspnet-Web-API-CRUD-a4c1f7f1

How the Native Client like Win10 DeskTop app consume the Web Api ?

As PatriceSc said, you can call an ASP.NET WebAPI using HttpClient libraries:

HttpClient class:

https://msdn.microsoft.com/library/windows/apps/windows.web.http.httpclient.aspx?f=255&MSPPError=-2147217396

Web API With HttpClient Or Consume Web API From Console Application:

https://code.msdn.microsoft.com/Web-API-With-HttpClient-Or-87e07c98

Best Regards,

Yohann Lu