PostgreSql - NeoSOFT-Technologies/rest-dot-net-core GitHub Wiki

PostgreSql

You can create the Clean Architecture Project with PostgreSql Database either by CLI or by Visual Studio 2022

First we need to install clean architecture template using CLI and the command for the same is

dotnet new --install Neosoft.Technologies.Templates

Template3 1

The template is successfully installed.

CLI

  • Step 1:- Open the PowerShell in the folder where you need to create the project.

  • Step 2:- Write this command:-

    dotnet new neotech-ca -db PGSQL

PS

Your Project is created Successfully.

Visual Studio 2022

  • Step 1:- In Visual Studio 2022, select the template Neosoft Technologies Clean Architecture and then click on Next.

Template

  • Step 2:- Give the name of your Project and then click on Next.

Give Project Name

  • Step 3:- Select the PGSQL Database from the Database Provider Dropdown and then click on Create.

Select database

Code

The changes are reflected in the following file.

  • HealthcheckExtension.cs

HealthCheck

  • IdentityServiceExtension.cs

    Respective Migration files are also created

Identity

  • PersistenceServiceRegistration.cs

    Respective Migration files are also created

Persistence

  • DbFixture

IntegrationTest

HealthCheck Result

Health

Integration Test Result

postgresql

Load Testing Result

Postgres

To get the JMeter result click here.