create an api and get data from sql server in json format

Question

how can we make an api by which we can retrieve data from sql server in json form

Gnanavel Sekar · Answer

View these blog you will get know http://www.c-sharpcorner.com/blogs/generic-repository-pattern-with-webapi-and-entity-framework http://www.c-sharpcorner.com/blogs/get-data-from-webapi-using-jquery-ajax

Ravi Patel · Answer

Hi  refer this https://docs.microsoft.com/en-us/aspnet/web-api/overview/getting-started-with-aspnet-web-api/tutorial-your-first-web-api

Rafnas T P · Answer

well you can create wcf service for this try below link to create wcf servise http://www.c-sharpcorner.com/article/wcf-service-with-jwt-token/

Nitin Sontakke · Answer

In addition what is the version of SQL Server? It is only from 2016 version sql server has started giving native json support.

Tapan Patel · Answer

Did you try something? If so please share the code. The question you are asking is of broad discussion and design of system.