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

Description

You can create clean architecture project with MSSQL database either by using CLI or 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

If you want to install the specific version of this template then you can refer this link.

Template3 1

The template is successfully installed.

Creating project using CLI

  • In the command prompt head over to the folder where you want to create project and enter the following command => dotnet new neotech-ca -db MSSQL

    CreateProject

    Your project is created successfully.

By using Visual Studio 2022

  • In the visual studio select Neosoft Technologies Clean Architecture (Neosoft Technologies) template and click next

    Template

  • Give a name to your project and click next

    Give Project Name

  • Now select MSSQL database from database provider dropdown and click create

    Select database

    Your project is created successfully.

Code

The changes are reflected in the following files-

  • HealthCheckExtension

    healthCheckExtension

  • IdentityServiceExtension

    Respective migration files are also added.

    IdentityService

  • PersistanceServiceRegistration

    Respective migration files are also added.

    persistanceServiceRegistration

  • DbFixture

    apiIntegrationtest(DbFixture)

HealthCheckUI

HealthCheckUI1

Integration Test Case Result

IntegrationTestCase

Load Testing Result

MsSql

To get the JMeter result click here.