I am new to writing API's, and was wondering where the best place to start was with writing a RESTful API for a locally hosted SQL2017 server. I have written an app using angular, and wish to access my data that is located on the local network (installed on a windows 10 machine) through a API.
I already have a VB.net project that connects to the database (each practice has a local server and program that connects through the local network). I am writing a app to give more functionality to the clients, and need to access this data from the newly written app (using ionics and angular, writen in visual studio code). As I am new to API's, I was wondering where the best place was to start, or any good examples on how to build a basic api. I would also like to know if I can integrate this into the existing VB.net project, as the project and sql server are already at clients.
Our community of experts have been thoroughly vetted for their expertise and industry experience.