This code was generated by AspCoreGen 9.0 MVC using the Microsoft Northwind Database.  
The generated code shows the use of ADO.NET using Ad-Hoc SQL and Web API in an ASP.NET Core application.
The generated solution contains 3 projects/application all generated by AspCoreGen 9.0 MVC. 

- Open the solution file "AdHocWa.sln" in Visual Studio 2022 located in the AdHocWa folder.

- Open the "appsettings.json" located in the AdHocWaSrvcs web api project in the root folder.
- Locate this code: "ConnectionString" : "Data Source=localhost;Initial Catalog=Northwind;User ID=DatabaseUserName;Password=DatabasePassword"
- Update the following:
  - localhost - The server name where your Microsoft Northwind database is located.
  - DatabaseUserName - The Microsoft SQL Server user name with admin rights.
  - DatabasePassword - The Microsoft SQL Server password partnered with the DatabaseUserName.

- Open the "Functions.cs" class file located in the AdHocWaApi class library project, under the Helper folder.
- Locate the "public static string GetWebApiBaseAddress()" method.
- If you need to, update the: return "https://localhost:7111/";  
  - Note: When you run the web application, this is the Web API Project's base address in the browser.

- Right-click on the solution in the Visual Studio Solution Explorer window and choose "Set Startup Projects".
  - Choose "multiple startup projects".
  - Under the "Action" choose "Start" for both the AdHocWa and AdHocWaSrvcs projects. 
  - Click the "OK" button.

- You can now run the application by pressing F5 in Visual Studio 2022