troubleshooting Question

Best way to start writing an api for SQL server 2017

Avatar of LIBRALEX
LIBRALEXFlag for South Africa asked on
Microsoft SQL ServerWeb ApplicationsWindows 10AngularSQL
7 Comments1 Solution131 ViewsLast Modified:
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.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 7 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros