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

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

Hi ,

refer this

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

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/

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

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