Introduction

An ASP.NET Core Web Api to access and manipulate project data using EF Core on a PostgreSQL or SQL Server database.

Data Entity Relationship Diagram

Endpoint Swagger View

Getting Started

1. Installation process:

(See "Build and Test" section of this document.)

2. Software dependencies:

• ASP.NET Core 8.0
• Entity Framework Core
• C#

3. Web API, languages and technology stack references:

• https://docs.microsoft.com/en-us/dotnet/csharp/
• https://docs.microsoft.com/en-us/ef/
• https://www.postgresql.org/docs/
• https://www.microsoft.com/en-us/sql-server/developer-tools?msockid=02f21cdf3f0c66e81a900e5e3e256728
• https://www.iis.net/
• https://azure.microsoft.com/en-us/

Build and Test

1. Web or folder deploy to IIS or Azure Cloud App (.NET Core 8.0 application pool), configure appsettings.json as needed.

2. Build and execute Visual Studio solution.