Boilerplate of API in .NET Core 3.1 .NET 6

GitHub	Codecov

Boilerplate is a piece of code that helps you to quickly kick-off a project or start writing your source code. It is kind of a template - instead of starting an empty project and adding the same snippets each time, you can use the boilerplate that already contains such code.

1. [Autofac](https://autofac.org/) (Removed in PR19)
2. Swagger + Swashbuckle
3. FeatureManagement (Feature Flags, Feature Toggles)
4. HealthChecks
5. EF Core
   • MySQL provider from Pomelo Foundation
   • MsSQL from Microsoft
6. Tests
   • Integration tests with InMemory database
     • FluentAssertions
     • xUnit
     • Verify
     • TestServer
   • Unit tests
     • AutoFixture
     • FluentAssertions
     • Moq
     • Moq.AutoMock
     • xUnit
   • Load tests
     • FluentAssertions
     • NBomber
     • xUnit
7. Code quality
   • EditorConfig (.editorconfig)
   • Analizers
     • Microsoft.CodeAnalysis.Analyzers
     • Microsoft.AspNetCore.Mvc.Api.Analyzers
     • Microsoft.VisualStudio.Threading.Analyzers
   • CodeAnalysisRules HappyCode.NetCoreBoilerplate.ruleset
   • Code coverage
     • Coverlet
     • Codecov
   • CI Code analysis with CodeQL
8. Docker
   • Dockerfile
   • Docker-compose
     • mysql:8 with DB initialization
     • mcr.microsoft.com/mssql/server:2017-latest with DB initialization
     • netcore-boilerplate:local
9. Serilog
   • Sink: Async
   • Enrich: CorrelationId
10. DbUp as a db migration tool
11. Continuous integration
    • [Travis CI](https://travis-ci.org/) (travisci.yml)
    • GitHub Actions
      • dotnetcore.yml
      • codeql-analysis.yml
      • docker.yml

HappyCode.NetCoreBoilerplate.Api

• Simple Startup class - Startup.cs
  • MvcCore
  • DbContext (with MySQL)
  • DbContext (with MsSQL)
  • Swagger and SwaggerUI (Swashbuckle)
  • HostedService and HttpClient
  • FeatureManagement
  • HealthChecks
    • MySQL
    • MsSQL
• Filters
  • Simple ApiKey Authorization filter - ApiKeyAuthorizationFilter.cs
  • Action filter to validate ModelState - ValidateModelStateFilter.cs
  • Global exception filter - HttpGlobalExceptionFilter.cs
• Configurations
  • Dependency registration place - ContainerConfigurator.cs
  • Serilog configuration place - SerilogConfigurator.cs
  • Swagger configuration place - SwaggerConfigurator.cs
• Simple exemplary API controllers - EmployeesController.cs, CarsController.cs
• Example of BackgroundService - PingWebsiteBackgroundService.cs

HappyCode.NetCoreBoilerplate.Core

• Dto models
• DB models
• Registration module - GeneralRegisterModule.cs
• Exemplary MySQL repository - EmployeeRepository.cs
• Exemplary MsSQL service - CarService.cs
• AppSettings models
• Simple MySQL DbContext - EmployeesContext.cs
• Simple MsSQL DbContext - CarsContext.cs

HappyCode.NetCoreBoilerplate.Db

• Console application as a simple db migration tool - Program.cs
• Sample migration scripts, both .sql and .cs - S001_AddCarTypesTable.sql, S002_ModifySomeRows.cs

HappyCode.NetCoreBoilerplate.Api.IntegrationTests

• Infrastructure
  • Fixture with TestServer - TestServerClientFixture.cs
  • TestStartup with InMemory databases - TestStartup.cs
  • Simple data feeders - EmployeeContextDataFeeder.cs, CarsContextDataFeeder.cs
• Exemplary tests - EmployeesTests.cs, CarsTests.cs

HappyCode.NetCoreBoilerplate.Api.UnitTests

• Exemplary tests - EmployeesControllerTests.cs
• Unit tests of ApiKeyAuthorizationFilter.cs - ApiKeyAuthorizationFilterTests.cs

HappyCode.NetCoreBoilerplate.Core.UnitTests

• Extension methods to mock DbSet faster - EnumerableExtensions.cs
• Exemplary tests - EmployeeRepositoryTests.cs, CarServiceTests.cs

Keep in mind that entire environment has to be up and running.

HappyCode.NetCoreBoilerplate.Api.LoadTests

• Base class for controller - LoadTestsBase.cs
• Exemplary tests - EmployeesControllerTests.cs, CarsControllerTests.cs

Generally it is totally up to you! But in case you do not have any plan, You can follow below simple steps:

1. Download/clone/fork repository ⤵️
2. Remove components and/or classes that you do not need to 🔥
3. Rename files (e.g. sln, csproj, ruleset), folders, namespaces etc 📝
4. Appreciate the work ⭐

Just execute dotnet build in the root directory, it takes HappyCode.NetCoreBoilerplate.sln and build everything.

At first, you need to have up and running MySQL and MsSQL database servers on localhost with initialized database by mysql script and mssql script.

Then the application (API) can be started by dotnet run command executed in the src/HappyCode.NetCoreBoilerplate.Api directory. By default it will be available under http://localhost:5000/, but keep in mind that documentation is available under http://localhost:5000/swagger/.

Just run docker-compose up command in the root directory and after successful start of services visit http://localhost:5000/swagger/. To check that API has connection to both MySQL and MsSQL databases visit http://localhost:5000/health/.

When the entire environment is up and running, you can additionally run a migration tool to add some new schema objects into MsSQL DB. To do that, go to src/HappyCode.NetCoreBoilerplate.Db directory and execute dotnet run command.

Run dotnet test command in the root directory, it will look for test projects in HappyCode.NetCoreBoilerplate.sln and run them.

• any idea? Please create an issue.

If:

• you like this repo/code,
• you learn something,
• you are using it in your project/application,

then please give me a star, appreciate my work. Thanks!