Sample .NET Core REST API CQRS implementation with raw SQL and DDD using Clean Architecture.

Give a Star! ⭐

If you like this project, learn something or you are using it in your applications, please give it a star. Thanks!

Description

Sample .NET Core REST API application implemented with basic CQRS approach and Domain Driven Design.

Architecture Clean Architecture

CQRS

Read Model - executing raw SQL scripts on database views objects (using Dapper).

Write Model - Domain Driven Design approach (using Entity Framework Core).

Commands/Queries/Domain Events handling using MediatR library.

Domain

Validation

Data validation using FluentValidation

Problem Details for HTTP APIs standard implementation using ProblemDetails

Caching

Using Cache-Aside pattern and in-memory cache.

Integration

Outbox Pattern implementation using Quartz.NET

How to run application

1. Create empty database.
2. Execute InitializeDatabase.sql script.
3. Set connection string (in appsettings.json or by user secrets mechanism).
4. Run!

How to run Integration Tests

1. Create empty database.
2. Execute InitializeDatabase.sql script.
3. Set connection string using environment variable named ASPNETCORE_SampleProject_IntegrationTests_ConnectionString

• Run tests from project src/Tests/SampleProject.IntegrationTests