w3ti.OpenBaseNET.SQLServer.Template 10.3.5

OpenBaseNET SQLServer Template

.NET 10 template for quickly building robust Web APIs with Clean Architecture, DDD, CQRS, and SQL Server.

Starting a new project requires a lot of repetitive setup: structuring layers, configuring data access, defining validation pipelines, wiring up the logger, and so on. This template eliminates that boilerplate. With a single command, you get a complete, production-ready .NET solution — so you can focus on business logic.

Architecture

The template follows Clean Architecture principles with Domain-Driven Design (DDD), organizing responsibilities into independent, testable layers.

MyApi/
├── src/
│   ├── MyApi.Domain          # Entities, interfaces, domain services
│   ├── MyApi.Application     # Use cases, commands, queries, DTOs
│   ├── MyApi.Infrastructure  # EF Core, Dapper, repositories, UoW
│   └── MyApi.API             # Controllers, middlewares, Program.cs
└── tests/
    └── MyApi.Tests.Unit      # Unit tests

Features

Data Access

• Entity Framework Core 10 with extensions for automatic retry
• Dapper integrated for high-performance SQL queries
• Generic Repository Pattern with support for pagination, filters, and includes
• Unit of Work for transactional control with EF Core + Dapper in the same transaction

CQRS and Mediator

• MediatR 14 for command and query separation
• Pre-configured Pipeline Behaviors:
  • ValidationBehaviour — runs FluentValidation before any handler
  • LoggingBehaviour — automatic logging for every processed request

Validation

• FluentValidation integrated into the MediatR pipeline — errors are automatically returned as 422 Unprocessable Entity

Mapping

• AutoMapper configured via dependency injection, with support for null destinations and collections

Resilience

• Polly with an exponential retry pipeline with jitter (3 attempts, 2s initial delay) for:
  • SQL Server operations (via Dapper and EF Core)
  • HTTP calls
  • Azure Storage

Observability

• Serilog with structured JSON output (CompactJsonFormatter)
• Automatic enrichment with machine name and environment name
• Configurable via appsettings.json
• Automatic logging of repository operations (add, update, remove, query, execute)

Exception Handling

• GlobalExceptionHandlerMiddleware with responses following RFC 9457 (ProblemDetails):
  • ValidationException → 422 Unprocessable Entity
  • KeyNotFoundException → 404 Not Found
  • ArgumentException → 400 Bad Request
  • All other exceptions → 500 Internal Server Error

API and Documentation

• Swagger / OpenAPI configured and available in the development environment
• HTTPS and authentication pre-configured in the pipeline

Testing

• Unit test project with xUnit, Moq, and Coverlet

Technologies

Getting Started

Prerequisites

• .NET SDK 10.0 or later
• SQL Server (local or remote)

1. Install the template

dotnet new install w3ti.OpenBaseNET.SQLServer.Template

2. Create a new project

mkdir MyApi
cd MyApi
dotnet new openbasenet-sql -n MyApi

3. Configure the connection string

Edit src/MyApi.Presentation.Api/appsettings.json:

{
  "ConnectionStrings": {
    "OpenBaseSQLServer": "Server=.;Database=MyApi;Trusted_Connection=True;TrustServerCertificate=True"
  }
}

4. Run

dotnet run --project src/MyApi.Presentation.Api/MyApi.Presentation.Api.csproj

The API will be available with Swagger at https://localhost:{port}/swagger.

Contact and Feedback

Rodrigo S. Brito — rodrigo@w3ti.com.br

Feedback and contributions are always welcome.