<div>
As a start, I would suggest you to create a <b>WCF service</b> architecture from <b>Visual Studio</b>.<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2020/03_w13/1447782/tmp.jpg" target="_blank" title="tmp.jpg (142 KB)"><img alt="tmp.jpg" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2020/03_w13/800_1447782/tmp.jpg" /></a><br />
And then from the back end, just linked it to SQL Server's Database Logic, like connecting with stored procedures, etc. You should able to find some relevant codes online too.
</div>


tmp.jpg

<div>
Why would a WCF service be better than a normal web api? Is it easier to implement in a already existing project? <br />
<br />
And would I be able to change the connection string of the WCF service? Since each server is hosted on the practices local network, the server settings must be able to be selected. In our VB.net project we use the SQL server browser to search for servers on the network and then set each application to the installed server (for example, &quot;SERVER-PC\SQL2017&quot;). &nbsp;This varies for each practice and I will have to be able to set this connection string in each instance.
</div>


<div>
Yes in my opinion, you would be better off with Web API instead of WCF. While it is entirely possible to store connection string in app.config and then load it during run time in WCF, today if I have to develop an API, I will go with Web APIs as it reduces complexity (or maybe it is perceived complexity).<br>I am bit confused about your multiple Database per practice scenario though. The api you are building is going to serve every Desktop app? or it is going to be hosted per practice?
</div>


<div>
<blockquote>
This varies for each practice and I will have to be able to set this connection string in each instance.
</blockquote>
<br />
well, it depends on the requirements to determine whether to implement a WCF or Web API structure. I believe we can read a lot regarding these comparison online. of course the use or store of connection string isn't really the show stopper to determine what technologies to be implementing.
</div>


<div>
@Ryan Chong- &nbsp;Would I be able to change the connection string dynamically if I used a WCF? Most people seem to reccomend a normal API, which is why im unsure? <br />
<br />
<br />
The scenario for each practice is as follows: &nbsp;we install a sql server 2017 on to a windows 10 machine, and then install our initial program as well (on as many computers as they want). &nbsp;This practice then all changes the connection string of each program (through a dropdown box using the sql browser), to connect to the SQL server on the &quot;server&quot; computer (which is just any computer that has the sql server). We only use the local network to connect to the server, so I need the API to be on the local network, and be able to set the connection string (if the server computer is named main-deskop, &nbsp;then the connection is &quot;main-desktop\SQL2017&quot;). &nbsp; Since each practice will have their own &quot;server&quot; computer, and the name and ip will vary each time, I will need to be able to point the api to the server computer at each practice. My newly developed app will then use the API to perform CRUD operations. <br />
<br />
I hope this makes more sense?
</div>


<div>
While most of the things will remain same, current version of .Net Core is 3.1, I would recommend going with it. All the best.
</div>


<div>
<div class="content wysiwyg-content">
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. <br />
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). &nbsp;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). &nbsp; 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. &nbsp;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.
</div>
</div>


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.

Best way to start writing an api for SQL server 2017

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Web applications are systems that run in browsers that perform functions normally associated with other client-based programs. One of the most commonly used web applications is email; instead of downloading individual emails to a local machine, the data is shown through a website. Other examples of web applications are collaborative systems like a wiki or an online game.

Web Applications

Windows 10 is a personal computer operating system featuring the "universal application architecture" (UAP); apps can be designed to run across multiple devices with nearly identical code, including PCs, tablets, smartphones, embedded systems, Xbox One, Surface Hub and HoloLens. Windows 10 also includes a virtual desktop system, a window and desktop management feature called Task View, the Microsoft Edge web browser, support for fingerprint and face recognition login, voice-based search (Cortana), new security features for enterprise environments, and DirectX 12 and WDDM 2.0 to improve the operating system's graphics capabilities for games.

Windows 10

Angular is a JavaScript open-source web application framework used to develop single-page applications. It aims to simplify both the development and the testing of such applications by providing a framework for client-side model–view–controller (MVC) and model–view–view-model (MVVM) architectures, along with components commonly used in rich Internet applications. Angular is the front-end part of the MEAN stack, together with Node.js runtime, Express.js backend framework and MongoDB database.

Angular

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.