Dotnet Backend Patterns
Seth HobsonCommunityCreated by Seth Hobson
- Skill
- Guidelines
- Software development
- MIT
- Low risk
- Has scripts
AutoGineer summary
Written by AutoGineer from the skill’s own files, not by the author
This skill provides a structured approach to .NET backend development, covering architectural patterns, dependency injection, asynchronous programming, and data access strategies. It includes guidance on implementing clean architecture, managing application configuration, handling errors with result patterns, and optimizing database interactions using Entity Framework Core and Dapper. Additionally, it offers patterns for caching and testing to support the development of robust enterprise applications.
What it does
- Defines project structures using clean architecture principles.
- Demonstrates dependency injection patterns including keyed services and lifetime management.
- Provides best practices for asynchronous programming and task management.
- Outlines configuration management using IOptions, IOptionsSnapshot, and IOptionsMonitor.
- Details data access strategies for Entity Framework Core and Dapper.
- Offers patterns for multi-level caching and unit/integration testing.
When to use it
- When developing new .NET Web APIs or MCP servers.
- When reviewing C# code for adherence to established patterns.
- When designing service architectures or implementing dependency injection.
- When optimizing database access or implementing caching strategies.
- When writing unit and integration tests for .NET services.
Advantages
- Promotes consistent project organization and code structure.
- Provides clear examples for modern .NET dependency injection techniques.
- Offers guidance on avoiding common pitfalls in asynchronous code.
- Includes practical patterns for database operations and caching.
- Supports test-driven development with xUnit and WebApplicationFactory examples.
Usage examples
- “How should I structure my .NET project for clean architecture?”
- The skill provides a directory layout separating Domain, Application, Infrastructure, and API layers to ensure clear separation of concerns.
- “What is the recommended way to handle configuration in .NET?”
- The skill explains the use of IOptions, IOptionsSnapshot, and IOptionsMonitor for managing application settings.
- “How do I implement a repository pattern with Dapper?”
- The skill provides code examples for implementing repositories with Dapper, including connection management and multi-mapping for related data.
- “How can I test my API endpoints in .NET?”
- The skill demonstrates using WebApplicationFactory to perform integration testing with an in-memory database.
Install
Download the skill as a ZIP:
https://autogineer.com/agent-skills/wshobson/dotnet-backend-patterns/downloadUnzip it into the cross-client skills folder of your project:
mkdir -p .agents/skills && unzip dotnet-backend-patterns.zip -d .agents/skills
Documentation by Seth Hobson
.NET Backend Development Patterns
Master C#/.NET patterns for building production-grade APIs, MCP servers, and enterprise backends with modern best practices (2024/2025).
When to Use This Skill
Developing new .NET Web APIs or MCP servers
Reviewing C# code for quality and performance
Designing service architectures with dependency injection
Implementing caching strategies with Redis
Writing unit and integration tests
Optimizing database access with EF Core or Dapper
Configuring applications with IOptions pattern
Handling errors and implementing resilience patterns
Core Concepts
1. Project Structure (Clean Architecture)
src/
├── Domain/ # Core business logic (no dependencies)
│ ├── Entities/
│ ├── Interfaces/
│ ├── Exceptions/
│ └── ValueObjects/
├── Application/ # Use cases, DTOs, validation
│ ├── Services/
│ ├── DTOs/
│ ├── Validators/
│ └── Interfaces/
├── Infrastructure/ # External implementations
│ ├── Data/ # EF Core, Dapper repositories
│ ├── Caching/ # Redis, Memory cache
│ ├── External/ # HTTP clients, third-party APIs
│ └── DependencyInjection/ # Service registration
└── Api/ # Entry point
├── Controllers/ # Or MinimalAPI endpoints
├── Middleware/
├── Filters/
└── Program.cs2. Dependency Injection Patterns
// Service registration by lifetime
public static class ServiceCollectionExtensions
{
public static IServiceCollection AddApplicationServices(
this IServiceCollection services,
IConfiguration configuration)
{
// Scoped: One instance per HTTP request
services.AddScoped<IProductService, ProductService>();
services.AddScoped<IOrderService, OrderService>();
// Singleton: One instance for app lifetime
services.AddSingleton<ICacheService, RedisCacheService>();
services.AddSingleton<IConnectionMultiplexer>(_ =>
ConnectionMultiplexer.Connect(configuration["Redis:Connection"]!));
// Transient: New instance every time
services.AddTransient<IValidator<CreateOrderRequest>, CreateOrderValidator>();
// Options pattern for configuration
services.Configure<CatalogOptions>(configuration.GetSection("Catalog"));
services.Configure<RedisOptions>(configuration.GetSection("Redis"));
// Factory pattern for conditional creation
services.AddScoped<IPriceCalculator>(sp =>
{
var options = sp.GetRequiredService<IOptions<PricingOptions>>().Value;
return options.UseNewEngine
? sp.GetRequiredService<NewPriceCalculator>()
: sp.GetRequiredService<LegacyPriceCalculator>();
});
// Keyed services (.NET 8+)
services.AddKeyedScoped<IPaymentProcessor, StripeProcessor>("stripe");
services.AddKeyedScoped<IPaymentProcessor, PayPalProcessor>("paypal");
return services;
}
}
// Usage with keyed services
public class CheckoutService
{
public CheckoutService(
[FromKeyedServices("stripe")] IPaymentProcessor stripeProcessor)
{
_processor = stripeProcessor;
}
}3. Async/Await Patterns
// ✅ CORRECT: Async all the way down
public async Task<Product> GetProductAsync(string id, CancellationToken ct = default)
{
return await _repository.GetByIdAsync(id, ct);
}
// ✅ CORRECT: Parallel execution with WhenAll
public async Task<(Stock, Price)> GetStockAndPriceAsync(
string productId,
CancellationToken ct = default)
{
var stockTask = _stockService.GetAsync(productId, ct);
var priceTask = _priceService.GetAsync(productId, ct);
await Task.WhenAll(stockTask, priceTask);
return (await stockTask, await priceTask);
}
// ✅ CORRECT: ConfigureAwait in libraries
public async Task<T> LibraryMethodAsync<T>(CancellationToken ct = default)
{
var result = await _httpClient.GetAsync(url, ct).ConfigureAwait(false);
return await result.Content.ReadFromJsonAsync<T>(ct).ConfigureAwait(false);
}
// ✅ CORRECT: ValueTask for hot paths with caching
public ValueTask<Product?> GetCachedProductAsync(string id)
{
if (_cache.TryGetValue(id, out Product? product))
return ValueTask.FromResult(product);
return new ValueTask<Product?>(GetFromDatabaseAsync(id));
}
// ❌ WRONG: Blocking on async (deadlock risk)
var result = GetProductAsync(id).Result; // NEVER do this
var result2 = GetProductAsync(id).GetAwaiter().GetResult(); // Also bad
// ❌ WRONG: async void (except event handlers)
public async void ProcessOrder() { } // Exceptions are lost
// ❌ WRONG: Unnecessary Task.Run for already async code
await Task.Run(async () => await GetDataAsync()); // Wastes thread4. Configuration with IOptions
// Configuration classes
public class CatalogOptions
{
public const string SectionName = "Catalog";
public int DefaultPageSize { get; set; } = 50;
public int MaxPageSize { get; set; } = 200;
public TimeSpan CacheDuration { get; set; } = TimeSpan.FromMinutes(15);
public bool EnableEnrichment { get; set; } = true;
}
public class RedisOptions
{
public const string SectionName = "Redis";
public string Connection { get; set; } = "localhost:6379";
public string KeyPrefix { get; set; } = "mcp:";
public int Database { get; set; } = 0;
}
// appsettings.json
{
"Catalog": {
"DefaultPageSize": 50,
"MaxPageSize": 200,
"CacheDuration": "00:15:00",
"EnableEnrichment": true
},
"Redis": {
"Connection": "localhost:6379",
"KeyPrefix": "mcp:",
"Database": 0
}
}
// Registration
services.Configure<CatalogOptions>(configuration.GetSection(CatalogOptions.SectionName));
services.Configure<RedisOptions>(configuration.GetSection(RedisOptions.SectionName));
// Usage with IOptions (singleton, read once at startup)
public class CatalogService
{
private readonly CatalogOptions _options;
public CatalogService(IOptions<CatalogOptions> options)
{
_options = options.Value;
}
}
// Usage with IOptionsSnapshot (scoped, re-reads on each request)
public class DynamicService
{
private readonly CatalogOptions _options;
public DynamicService(IOptionsSnapshot<CatalogOptions> options)
{
_options = options.Value; // Fresh value per request
}
}
// Usage with IOptionsMonitor (singleton, notified on changes)
public class MonitoredService
{
private CatalogOptions _options;
public MonitoredService(IOptionsMonitor<CatalogOptions> monitor)
{
_options = monitor.CurrentValue;
monitor.OnChange(newOptions => _options = newOptions);
}
}5. Result Pattern (Avoiding Exceptions for Flow Control)
// Generic Result type
public class Result<T>
{
public bool IsSuccess { get; }
public T? Value { get; }
public string? Error { get; }
public string? ErrorCode { get; }
private Result(bool isSuccess, T? value, string? error, string? errorCode)
{
IsSuccess = isSuccess;
Value = value;
Error = error;
ErrorCode = errorCode;
}
public static Result<T> Success(T value) => new(true, value, null, null);
public static Result<T> Failure(string error, string? code = null) => new(false, default, error, code);
public Result<TNew> Map<TNew>(Func<T, TNew> mapper) =>
IsSuccess ? Result<TNew>.Success(mapper(Value!)) : Result<TNew>.Failure(Error!, ErrorCode);
public async Task<Result<TNew>> MapAsync<TNew>(Func<T, Task<TNew>> mapper) =>
IsSuccess ? Result<TNew>.Success(await mapper(Value!)) : Result<TNew>.Failure(Error!, ErrorCode);
}
// Usage in service
public async Task<Result<Order>> CreateOrderAsync(CreateOrderRequest request, CancellationToken ct)
{
// Validation
var validation = await _validator.ValidateAsync(request, ct);
if (!validation.IsValid)
return Result<Order>.Failure(
validation.Errors.First().ErrorMessage,
"VALIDATION_ERROR");
// Business rule check
var stock = await _stockService.CheckAsync(request.ProductId, request.Quantity, ct);
if (!stock.IsAvailable)
return Result<Order>.Failure(
$"Insufficient stock: {stock.Available} available, {request.Quantity} requested",
"INSUFFICIENT_STOCK");
// Create order
var order = await _repository.CreateAsync(request.ToEntity(), ct);
return Result<Order>.Success(order);
}
// Usage in controller/endpoint
app.MapPost("/orders", async (
CreateOrderRequest request,
IOrderService orderService,
CancellationToken ct) =>
{
var result = await orderService.CreateOrderAsync(request, ct);
return result.IsSuccess
? Results.Created($"/orders/{result.Value!.Id}", result.Value)
: Results.BadRequest(new { error = result.Error, code = result.ErrorCode });
});Data Access Patterns
Entity Framework Core
// DbContext configuration
public class AppDbContext : DbContext
{
public DbSet<Product> Products => Set<Product>();
public DbSet<Order> Orders => Set<Order>();
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
// Apply all configurations from assembly
modelBuilder.ApplyConfigurationsFromAssembly(typeof(AppDbContext).Assembly);
// Global query filters
modelBuilder.Entity<Product>().HasQueryFilter(p => !p.IsDeleted);
}
}
// Entity configuration
public class ProductConfiguration : IEntityTypeConfiguration<Product>
{
public void Configure(EntityTypeBuilder<Product> builder)
{
builder.ToTable("Products");
builder.HasKey(p => p.Id);
builder.Property(p => p.Id).HasMaxLength(40);
builder.Property(p => p.Name).HasMaxLength(200).IsRequired();
builder.Property(p => p.Price).HasPrecision(18, 2);
builder.HasIndex(p => p.Sku).IsUnique();
builder.HasIndex(p => new { p.CategoryId, p.Name });
builder.HasMany(p => p.OrderItems)
.WithOne(oi => oi.Product)
.HasForeignKey(oi => oi.ProductId);
}
}
// Repository with EF Core
public class ProductRepository : IProductRepository
{
private readonly AppDbContext _context;
public async Task<Product?> GetByIdAsync(string id, CancellationToken ct = default)
{
return await _context.Products
.AsNoTracking()
.FirstOrDefaultAsync(p => p.Id == id, ct);
}
public async Task<IReadOnlyList<Product>> SearchAsync(
ProductSearchCriteria criteria,
CancellationToken ct = default)
{
var query = _context.Products.AsNoTracking();
if (!string.IsNullOrWhiteSpace(criteria.SearchTerm))
query = query.Where(p => EF.Functions.Like(p.Name, $"%{criteria.SearchTerm}%"));
if (criteria.CategoryId.HasValue)
query = query.Where(p => p.CategoryId == criteria.CategoryId);
if (criteria.MinPrice.HasValue)
query = query.Where(p => p.Price >= criteria.MinPrice);
if (criteria.MaxPrice.HasValue)
query = query.Where(p => p.Price <= criteria.MaxPrice);
return await query
.OrderBy(p => p.Name)
.Skip((criteria.Page - 1) * criteria.PageSize)
.Take(criteria.PageSize)
.ToListAsync(ct);
}
}Dapper for Performance
public class DapperProductRepository : IProductRepository
{
private readonly IDbConnection _connection;
public async Task<Product?> GetByIdAsync(string id, CancellationToken ct = default)
{
const string sql = """
SELECT Id, Name, Sku, Price, CategoryId, Stock, CreatedAt
FROM Products
WHERE Id = @Id AND IsDeleted = 0
""";
return await _connection.QueryFirstOrDefaultAsync<Product>(
new CommandDefinition(sql, new { Id = id }, cancellationToken: ct));
}
public async Task<IReadOnlyList<Product>> SearchAsync(
ProductSearchCriteria criteria,
CancellationToken ct = default)
{
var sql = new StringBuilder("""
SELECT Id, Name, Sku, Price, CategoryId, Stock, CreatedAt
FROM Products
WHERE IsDeleted = 0
""");
var parameters = new DynamicParameters();
if (!string.IsNullOrWhiteSpace(criteria.SearchTerm))
{
sql.Append(" AND Name LIKE @SearchTerm");
parameters.Add("SearchTerm", $"%{criteria.SearchTerm}%");
}
if (criteria.CategoryId.HasValue)
{
sql.Append(" AND CategoryId = @CategoryId");
parameters.Add("CategoryId", criteria.CategoryId);
}
if (criteria.MinPrice.HasValue)
{
sql.Append(" AND Price >= @MinPrice");
parameters.Add("MinPrice", criteria.MinPrice);
}
if (criteria.MaxPrice.HasValue)
{
sql.Append(" AND Price <= @MaxPrice");
parameters.Add("MaxPrice", criteria.MaxPrice);
}
sql.Append(" ORDER BY Name OFFSET @Offset ROWS FETCH NEXT @PageSize ROWS ONLY");
parameters.Add("Offset", (criteria.Page - 1) * criteria.PageSize);
parameters.Add("PageSize", criteria.PageSize);
var results = await _connection.QueryAsync<Product>(
new CommandDefinition(sql.ToString(), parameters, cancellationToken: ct));
return results.ToList();
}
// Multi-mapping for related data
public async Task<Order?> GetOrderWithItemsAsync(int orderId, CancellationToken ct = default)
{
const string sql = """
SELECT o.*, oi.*, p.*
FROM Orders o
LEFT JOIN OrderItems oi ON o.Id = oi.OrderId
LEFT JOIN Products p ON oi.ProductId = p.Id
WHERE o.Id = @OrderId
""";
var orderDictionary = new Dictionary<int, Order>();
await _connection.QueryAsync<Order, OrderItem, Product, Order>(
new CommandDefinition(sql, new { OrderId = orderId }, cancellationToken: ct),
(order, item, product) =>
{
if (!orderDictionary.TryGetValue(order.Id, out var existingOrder))
{
existingOrder = order;
existingOrder.Items = new List<OrderItem>();
orderDictionary.Add(order.Id, existingOrder);
}
if (item != null)
{
item.Product = product;
existingOrder.Items.Add(item);
}
return existingOrder;
},
splitOn: "Id,Id");
return orderDictionary.Values.FirstOrDefault();
}
}Caching Patterns
Multi-Level Cache with Redis
public class CachedProductService : IProductService
{
private readonly IProductRepository _repository;
private readonly IMemoryCache _memoryCache;
private readonly IDistributedCache _distributedCache;
private readonly ILogger<CachedProductService> _logger;
private static readonly TimeSpan MemoryCacheDuration = TimeSpan.FromMinutes(1);
private static readonly TimeSpan DistributedCacheDuration = TimeSpan.FromMinutes(15);
public async Task<Product?> GetByIdAsync(string id, CancellationToken ct = default)
{
var cacheKey = $"product:{id}";
// L1: Memory cache (in-process, fastest)
if (_memoryCache.TryGetValue(cacheKey, out Product? cached))
{
_logger.LogDebug("L1 cache hit for {CacheKey}", cacheKey);
return cached;
}
// L2: Distributed cache (Redis)
var distributed = await _distributedCache.GetStringAsync(cacheKey, ct);
if (distributed != null)
{
_logger.LogDebug("L2 cache hit for {CacheKey}", cacheKey);
var product = JsonSerializer.Deserialize<Product>(distributed);
// Populate L1
_memoryCache.Set(cacheKey, product, MemoryCacheDuration);
return product;
}
// L3: Database
_logger.LogDebug("Cache miss for {CacheKey}, fetching from database", cacheKey);
var fromDb = await _repository.GetByIdAsync(id, ct);
if (fromDb != null)
{
var serialized = JsonSerializer.Serialize(fromDb);
// Populate both caches
await _distributedCache.SetStringAsync(
cacheKey,
serialized,
new DistributedCacheEntryOptions
{
AbsoluteExpirationRelativeToNow = DistributedCacheDuration
},
ct);
_memoryCache.Set(cacheKey, fromDb, MemoryCacheDuration);
}
return fromDb;
}
public async Task InvalidateAsync(string id, CancellationToken ct = default)
{
var cacheKey = $"product:{id}";
_memoryCache.Remove(cacheKey);
await _distributedCache.RemoveAsync(cacheKey, ct);
_logger.LogInformation("Invalidated cache for {CacheKey}", cacheKey);
}
}
// Stale-while-revalidate pattern
public class StaleWhileRevalidateCache<T>
{
private readonly IDistributedCache _cache;
private readonly TimeSpan _freshDuration;
private readonly TimeSpan _staleDuration;
public async Task<T?> GetOrCreateAsync(
string key,
Func<CancellationToken, Task<T>> factory,
CancellationToken ct = default)
{
var cached = await _cache.GetStringAsync(key, ct);
if (cached != null)
{
var entry = JsonSerializer.Deserialize<CacheEntry<T>>(cached)!;
if (entry.IsStale && !entry.IsExpired)
{
// Return stale data immediately, refresh in background
_ = Task.Run(async () =>
{
var fresh = await factory(CancellationToken.None);
await SetAsync(key, fresh, CancellationToken.None);
});
}
if (!entry.IsExpired)
return entry.Value;
}
// Cache miss or expired
var value = await factory(ct);
await SetAsync(key, value, ct);
return value;
}
private record CacheEntry<TValue>(TValue Value, DateTime CreatedAt)
{
public bool IsStale => DateTime.UtcNow - CreatedAt > _freshDuration;
public bool IsExpired => DateTime.UtcNow - CreatedAt > _staleDuration;
}
}Testing Patterns
Unit Tests with xUnit and Moq
public class OrderServiceTests
{
private readonly Mock<IOrderRepository> _mockRepository;
private readonly Mock<IStockService> _mockStockService;
private readonly Mock<IValidator<CreateOrderRequest>> _mockValidator;
private readonly OrderService _sut; // System Under Test
public OrderServiceTests()
{
_mockRepository = new Mock<IOrderRepository>();
_mockStockService = new Mock<IStockService>();
_mockValidator = new Mock<IValidator<CreateOrderRequest>>();
// Default: validation passes
_mockValidator
.Setup(v => v.ValidateAsync(It.IsAny<CreateOrderRequest>(), It.IsAny<CancellationToken>()))
.ReturnsAsync(new ValidationResult());
_sut = new OrderService(
_mockRepository.Object,
_mockStockService.Object,
_mockValidator.Object);
}
[Fact]
public async Task CreateOrderAsync_WithValidRequest_ReturnsSuccess()
{
// Arrange
var request = new CreateOrderRequest
{
ProductId = "PROD-001",
Quantity = 5,
CustomerOrderCode = "ORD-2024-001"
};
_mockStockService
.Setup(s => s.CheckAsync("PROD-001", 5, It.IsAny<CancellationToken>()))
.ReturnsAsync(new StockResult { IsAvailable = true, Available = 10 });
_mockRepository
.Setup(r => r.CreateAsync(It.IsAny<Order>(), It.IsAny<CancellationToken>()))
.ReturnsAsync(new Order { Id = 1, CustomerOrderCode = "ORD-2024-001" });
// Act
var result = await _sut.CreateOrderAsync(request);
// Assert
Assert.True(result.IsSuccess);
Assert.NotNull(result.Value);
Assert.Equal(1, result.Value.Id);
_mockRepository.Verify(
r => r.CreateAsync(It.Is<Order>(o => o.CustomerOrderCode == "ORD-2024-001"),
It.IsAny<CancellationToken>()),
Times.Once);
}
[Fact]
public async Task CreateOrderAsync_WithInsufficientStock_ReturnsFailure()
{
// Arrange
var request = new CreateOrderRequest { ProductId = "PROD-001", Quantity = 100 };
_mockStockService
.Setup(s => s.CheckAsync(It.IsAny<string>(), It.IsAny<int>(), It.IsAny<CancellationToken>()))
.ReturnsAsync(new StockResult { IsAvailable = false, Available = 5 });
// Act
var result = await _sut.CreateOrderAsync(request);
// Assert
Assert.False(result.IsSuccess);
Assert.Equal("INSUFFICIENT_STOCK", result.ErrorCode);
Assert.Contains("5 available", result.Error);
_mockRepository.Verify(
r => r.CreateAsync(It.IsAny<Order>(), It.IsAny<CancellationToken>()),
Times.Never);
}
[Theory]
[InlineData(0)]
[InlineData(-1)]
[InlineData(-100)]
public async Task CreateOrderAsync_WithInvalidQuantity_ReturnsValidationError(int quantity)
{
// Arrange
var request = new CreateOrderRequest { ProductId = "PROD-001", Quantity = quantity };
_mockValidator
.Setup(v => v.ValidateAsync(request, It.IsAny<CancellationToken>()))
.ReturnsAsync(new ValidationResult(new[]
{
new ValidationFailure("Quantity", "Quantity must be greater than 0")
}));
// Act
var result = await _sut.CreateOrderAsync(request);
// Assert
Assert.False(result.IsSuccess);
Assert.Equal("VALIDATION_ERROR", result.ErrorCode);
}
}Integration Tests with WebApplicationFactory
public class ProductsApiTests : IClassFixture<WebApplicationFactory<Program>>
{
private readonly WebApplicationFactory<Program> _factory;
private readonly HttpClient _client;
public ProductsApiTests(WebApplicationFactory<Program> factory)
{
_factory = factory.WithWebHostBuilder(builder =>
{
builder.ConfigureServices(services =>
{
// Replace real database with in-memory
services.RemoveAll<DbContextOptions<AppDbContext>>();
services.AddDbContext<AppDbContext>(options =>
options.UseInMemoryDatabase("TestDb"));
// Replace Redis with memory cache
services.RemoveAll<IDistributedCache>();
services.AddDistributedMemoryCache();
});
});
_client = _factory.CreateClient();
}
[Fact]
public async Task GetProduct_WithValidId_ReturnsProduct()
{
// Arrange
using var scope = _factory.Services.CreateScope();
var context = scope.ServiceProvider.GetRequiredService<AppDbContext>();
context.Products.Add(new Product
{
Id = "TEST-001",
Name = "Test Product",
Price = 99.99m
});
await context.SaveChangesAsync();
// Act
var response = await _client.GetAsync("/api/products/TEST-001");
// Assert
response.EnsureSuccessStatusCode();
var product = await response.Content.ReadFromJsonAsync<Product>();
Assert.Equal("Test Product", product!.Name);
}
[Fact]
public async Task GetProduct_WithInvalidId_Returns404()
{
// Act
var response = await _client.GetAsync("/api/products/NONEXISTENT");
// Assert
Assert.Equal(HttpStatusCode.NotFound, response.StatusCode);
}
}Best Practices
DO
Use async/await all the way through the call stack
Inject dependencies through constructor injection
Use IOptions<T> for typed configuration
Return Result types instead of throwing exceptions for business logic
Use CancellationToken in all async methods
Prefer Dapper for read-heavy, performance-critical queries
Use EF Core for complex domain models with change tracking
Cache aggressively with proper invalidation strategies
Write unit tests for business logic, integration tests for APIs
Use record types for DTOs and immutable data
DON'T
Don't block on async with
.Resultor.Wait()Don't use async void except for event handlers
Don't catch generic Exception without re-throwing or logging
Don't hardcode configuration values
Don't expose EF entities directly in APIs (use DTOs)
Don't forget
AsNoTracking()for read-only queriesDon't ignore CancellationToken parameters
Don't create
new HttpClient()manually (use IHttpClientFactory)Don't mix sync and async code unnecessarily
Don't skip validation at API boundaries
Common Pitfalls
N+1 Queries: Use
.Include()or explicit joinsMemory Leaks: Dispose IDisposable resources, use
usingDeadlocks: Don't mix sync and async, use ConfigureAwait(false) in libraries
Over-fetching: Select only needed columns, use projections
Missing Indexes: Check query plans, add indexes for common filters
Timeout Issues: Configure appropriate timeouts for HTTP clients
Cache Stampede: Use distributed locks for cache population
Files
- ATTRIBUTION.mdAdded by AutoGineer1007 B
- LICENSELicence file added by AutoGineer1.0 KiB
- SKILL.md25.8 KiB
- assets/repository-template.csScript16.4 KiB
- assets/service-template.csScript12.2 KiB
- references/dapper-patterns.md15.1 KiB
- references/ef-core-best-practices.md8.7 KiB
references/dapper-patterns.md
Dapper Patterns and Best Practices
Advanced patterns for high-performance data access with Dapper in .NET.
Why Dapper?
| Aspect | Dapper | EF Core |
|---|---|---|
| Performance | ~10x faster for simple queries | Good with optimization |
| Control | Full SQL control | Abstracted |
| Learning curve | Low (just SQL) | Higher |
| Complex mappings | Manual | Automatic |
| Change tracking | None | Built-in |
| Migrations | External tools | Built-in |
Use Dapper when:
Performance is critical (hot paths)
You need complex SQL (CTEs, window functions)
Read-heavy workloads
Legacy database schemas
Use EF Core when:
Rich domain models with relationships
Need change tracking
Want LINQ-to-SQL translation
Complex object graphs
Connection Management
1. Proper Connection Handling
// Register connection factory
services.AddScoped<IDbConnection>(sp =>
{
var connectionString = sp.GetRequiredService<IConfiguration>()
.GetConnectionString("Default");
return new SqlConnection(connectionString);
});
// Or use a factory for more control
public interface IDbConnectionFactory
{
IDbConnection CreateConnection();
}
public class SqlConnectionFactory : IDbConnectionFactory
{
private readonly string _connectionString;
public SqlConnectionFactory(IConfiguration configuration)
{
_connectionString = configuration.GetConnectionString("Default")
?? throw new InvalidOperationException("Connection string not found");
}
public IDbConnection CreateConnection() => new SqlConnection(_connectionString);
}2. Connection Lifecycle
public class ProductRepository
{
private readonly IDbConnectionFactory _factory;
public ProductRepository(IDbConnectionFactory factory)
{
_factory = factory;
}
public async Task<Product?> GetByIdAsync(string id, CancellationToken ct)
{
// Connection opens automatically, closes on dispose
using var connection = _factory.CreateConnection();
return await connection.QueryFirstOrDefaultAsync<Product>(
new CommandDefinition(
"SELECT * FROM Products WHERE Id = @Id",
new { Id = id },
cancellationToken: ct));
}
}Query Patterns
3. Basic CRUD Operations
// SELECT single
var product = await connection.QueryFirstOrDefaultAsync<Product>(
"SELECT * FROM Products WHERE Id = @Id",
new { Id = id });
// SELECT multiple
var products = await connection.QueryAsync<Product>(
"SELECT * FROM Products WHERE CategoryId = @CategoryId",
new { CategoryId = categoryId });
// INSERT with identity return
var newId = await connection.QuerySingleAsync<int>(
"""
INSERT INTO Products (Name, Price, CategoryId)
VALUES (@Name, @Price, @CategoryId);
SELECT CAST(SCOPE_IDENTITY() AS INT);
""",
product);
// INSERT with OUTPUT clause (returns full entity)
var inserted = await connection.QuerySingleAsync<Product>(
"""
INSERT INTO Products (Name, Price, CategoryId)
OUTPUT INSERTED.*
VALUES (@Name, @Price, @CategoryId);
""",
product);
// UPDATE
var rowsAffected = await connection.ExecuteAsync(
"""
UPDATE Products
SET Name = @Name, Price = @Price, UpdatedAt = @UpdatedAt
WHERE Id = @Id
""",
new { product.Id, product.Name, product.Price, UpdatedAt = DateTime.UtcNow });
// DELETE
await connection.ExecuteAsync(
"DELETE FROM Products WHERE Id = @Id",
new { Id = id });4. Dynamic Query Building
public async Task<IReadOnlyList<Product>> SearchAsync(ProductSearchCriteria criteria)
{
var sql = new StringBuilder("SELECT * FROM Products WHERE 1=1");
var parameters = new DynamicParameters();
if (!string.IsNullOrWhiteSpace(criteria.SearchTerm))
{
sql.Append(" AND (Name LIKE @SearchTerm OR Sku LIKE @SearchTerm)");
parameters.Add("SearchTerm", $"%{criteria.SearchTerm}%");
}
if (criteria.CategoryId.HasValue)
{
sql.Append(" AND CategoryId = @CategoryId");
parameters.Add("CategoryId", criteria.CategoryId.Value);
}
if (criteria.MinPrice.HasValue)
{
sql.Append(" AND Price >= @MinPrice");
parameters.Add("MinPrice", criteria.MinPrice.Value);
}
if (criteria.MaxPrice.HasValue)
{
sql.Append(" AND Price <= @MaxPrice");
parameters.Add("MaxPrice", criteria.MaxPrice.Value);
}
// Pagination
sql.Append(" ORDER BY Name");
sql.Append(" OFFSET @Offset ROWS FETCH NEXT @PageSize ROWS ONLY");
parameters.Add("Offset", (criteria.Page - 1) * criteria.PageSize);
parameters.Add("PageSize", criteria.PageSize);
using var connection = _factory.CreateConnection();
var results = await connection.QueryAsync<Product>(sql.ToString(), parameters);
return results.ToList();
}5. Multi-Mapping (Joins)
// One-to-One mapping
public async Task<Product?> GetProductWithCategoryAsync(string id)
{
const string sql = """
SELECT p.*, c.*
FROM Products p
INNER JOIN Categories c ON p.CategoryId = c.Id
WHERE p.Id = @Id
""";
using var connection = _factory.CreateConnection();
var result = await connection.QueryAsync<Product, Category, Product>(
sql,
(product, category) =>
{
product.Category = category;
return product;
},
new { Id = id },
splitOn: "Id"); // Column where split occurs
return result.FirstOrDefault();
}
// One-to-Many mapping
public async Task<Order?> GetOrderWithItemsAsync(int orderId)
{
const string sql = """
SELECT o.*, oi.*, p.*
FROM Orders o
LEFT JOIN OrderItems oi ON o.Id = oi.OrderId
LEFT JOIN Products p ON oi.ProductId = p.Id
WHERE o.Id = @OrderId
""";
var orderDictionary = new Dictionary<int, Order>();
using var connection = _factory.CreateConnection();
await connection.QueryAsync<Order, OrderItem, Product, Order>(
sql,
(order, item, product) =>
{
if (!orderDictionary.TryGetValue(order.Id, out var existingOrder))
{
existingOrder = order;
existingOrder.Items = new List<OrderItem>();
orderDictionary.Add(order.Id, existingOrder);
}
if (item != null)
{
item.Product = product;
existingOrder.Items.Add(item);
}
return existingOrder;
},
new { OrderId = orderId },
splitOn: "Id,Id");
return orderDictionary.Values.FirstOrDefault();
}6. Multiple Result Sets
public async Task<(IReadOnlyList<Product> Products, int TotalCount)> SearchWithCountAsync(
ProductSearchCriteria criteria)
{
const string sql = """
-- First result set: count
SELECT COUNT(*) FROM Products WHERE CategoryId = @CategoryId;
-- Second result set: data
SELECT * FROM Products
WHERE CategoryId = @CategoryId
ORDER BY Name
OFFSET @Offset ROWS FETCH NEXT @PageSize ROWS ONLY;
""";
using var connection = _factory.CreateConnection();
using var multi = await connection.QueryMultipleAsync(sql, new
{
CategoryId = criteria.CategoryId,
Offset = (criteria.Page - 1) * criteria.PageSize,
PageSize = criteria.PageSize
});
var totalCount = await multi.ReadSingleAsync<int>();
var products = (await multi.ReadAsync<Product>()).ToList();
return (products, totalCount);
}Advanced Patterns
7. Table-Valued Parameters (Bulk Operations)
// SQL Server TVP for bulk operations
public async Task<IReadOnlyList<Product>> GetByIdsAsync(IEnumerable<string> ids)
{
// Create DataTable matching TVP structure
var table = new DataTable();
table.Columns.Add("Id", typeof(string));
foreach (var id in ids)
{
table.Rows.Add(id);
}
using var connection = _factory.CreateConnection();
var results = await connection.QueryAsync<Product>(
"SELECT p.* FROM Products p INNER JOIN @Ids i ON p.Id = i.Id",
new { Ids = table.AsTableValuedParameter("dbo.StringIdList") });
return results.ToList();
}
// SQL to create the TVP type:
// CREATE TYPE dbo.StringIdList AS TABLE (Id NVARCHAR(40));8. Stored Procedures
public async Task<IReadOnlyList<Product>> GetTopProductsAsync(int categoryId, int count)
{
using var connection = _factory.CreateConnection();
var results = await connection.QueryAsync<Product>(
"dbo.GetTopProductsByCategory",
new { CategoryId = categoryId, TopN = count },
commandType: CommandType.StoredProcedure);
return results.ToList();
}
// With output parameters
public async Task<(Order Order, string ConfirmationCode)> CreateOrderAsync(Order order)
{
var parameters = new DynamicParameters(new
{
order.CustomerId,
order.Total
});
parameters.Add("OrderId", dbType: DbType.Int32, direction: ParameterDirection.Output);
parameters.Add("ConfirmationCode", dbType: DbType.String, size: 20, direction: ParameterDirection.Output);
using var connection = _factory.CreateConnection();
await connection.ExecuteAsync(
"dbo.CreateOrder",
parameters,
commandType: CommandType.StoredProcedure);
order.Id = parameters.Get<int>("OrderId");
var confirmationCode = parameters.Get<string>("ConfirmationCode");
return (order, confirmationCode);
}9. Transactions
public async Task<Order> CreateOrderWithItemsAsync(Order order, List<OrderItem> items)
{
using var connection = _factory.CreateConnection();
await connection.OpenAsync();
using var transaction = await connection.BeginTransactionAsync();
try
{
// Insert order
order.Id = await connection.QuerySingleAsync<int>(
"""
INSERT INTO Orders (CustomerId, Total, CreatedAt)
OUTPUT INSERTED.Id
VALUES (@CustomerId, @Total, @CreatedAt)
""",
order,
transaction);
// Insert items
foreach (var item in items)
{
item.OrderId = order.Id;
}
await connection.ExecuteAsync(
"""
INSERT INTO OrderItems (OrderId, ProductId, Quantity, UnitPrice)
VALUES (@OrderId, @ProductId, @Quantity, @UnitPrice)
""",
items,
transaction);
await transaction.CommitAsync();
order.Items = items;
return order;
}
catch
{
await transaction.RollbackAsync();
throw;
}
}10. Custom Type Handlers
// Register custom type handler for JSON columns
public class JsonTypeHandler<T> : SqlMapper.TypeHandler<T>
{
public override T Parse(object value)
{
if (value is string json)
{
return JsonSerializer.Deserialize<T>(json)!;
}
return default!;
}
public override void SetValue(IDbDataParameter parameter, T value)
{
parameter.Value = JsonSerializer.Serialize(value);
parameter.DbType = DbType.String;
}
}
// Register at startup
SqlMapper.AddTypeHandler(new JsonTypeHandler<ProductMetadata>());
// Now you can query directly
var product = await connection.QueryFirstAsync<Product>(
"SELECT Id, Name, Metadata FROM Products WHERE Id = @Id",
new { Id = id });
// product.Metadata is automatically deserialized from JSONPerformance Tips
11. Use CommandDefinition for Cancellation
// Always use CommandDefinition for async operations
var result = await connection.QueryAsync<Product>(
new CommandDefinition(
commandText: "SELECT * FROM Products WHERE CategoryId = @CategoryId",
parameters: new { CategoryId = categoryId },
cancellationToken: ct,
commandTimeout: 30));12. Buffered vs Unbuffered Queries
// Buffered (default) - loads all results into memory
var products = await connection.QueryAsync<Product>(sql); // Returns list
// Unbuffered - streams results (lower memory for large result sets)
var products = await connection.QueryUnbufferedAsync<Product>(sql); // Returns IAsyncEnumerable
await foreach (var product in products)
{
// Process one at a time
}13. Connection Pooling Settings
{
"ConnectionStrings": {
"Default": "Server=localhost;Database=MyDb;User Id=sa;Password=xxx;TrustServerCertificate=True;Min Pool Size=5;Max Pool Size=100;Connection Timeout=30;"
}
}Common Patterns
Repository Base Class
public abstract class DapperRepositoryBase<T> where T : class
{
protected readonly IDbConnectionFactory ConnectionFactory;
protected readonly ILogger Logger;
protected abstract string TableName { get; }
protected DapperRepositoryBase(IDbConnectionFactory factory, ILogger logger)
{
ConnectionFactory = factory;
Logger = logger;
}
protected async Task<T?> GetByIdAsync<TId>(TId id, CancellationToken ct = default)
{
var sql = $"SELECT * FROM {TableName} WHERE Id = @Id";
using var connection = ConnectionFactory.CreateConnection();
return await connection.QueryFirstOrDefaultAsync<T>(
new CommandDefinition(sql, new { Id = id }, cancellationToken: ct));
}
protected async Task<IReadOnlyList<T>> GetAllAsync(CancellationToken ct = default)
{
var sql = $"SELECT * FROM {TableName}";
using var connection = ConnectionFactory.CreateConnection();
var results = await connection.QueryAsync<T>(
new CommandDefinition(sql, cancellationToken: ct));
return results.ToList();
}
protected async Task<int> ExecuteAsync(
string sql,
object? parameters = null,
CancellationToken ct = default)
{
using var connection = ConnectionFactory.CreateConnection();
return await connection.ExecuteAsync(
new CommandDefinition(sql, parameters, cancellationToken: ct));
}
}Anti-Patterns to Avoid
// ❌ Bad - SQL injection risk
var sql = $"SELECT * FROM Products WHERE Name = '{userInput}'";
// ✅ Good - Parameterized query
var sql = "SELECT * FROM Products WHERE Name = @Name";
await connection.QueryAsync<Product>(sql, new { Name = userInput });
// ❌ Bad - Not disposing connection
var connection = new SqlConnection(connectionString);
var result = await connection.QueryAsync<Product>(sql);
// Connection leak!
// ✅ Good - Using statement
using var connection = new SqlConnection(connectionString);
var result = await connection.QueryAsync<Product>(sql);
// ❌ Bad - Opening connection manually when not needed
await connection.OpenAsync(); // Dapper does this automatically
var result = await connection.QueryAsync<Product>(sql);
// ✅ Good - Let Dapper manage connection
var result = await connection.QueryAsync<Product>(sql);Requirements and compatibility
Works with: Claude Code, Claude apps, OpenAI Codex, GitHub Copilot, Cursor, Gemini CLI, Kiro, OpenCode, Goose, Amp, Roo Code, JetBrains Junie, Factory Droid, Devin (ex-Windsurf), Mistral Vibe, OpenHands, Letta
“Works with” means the tool reads the open Agent Skills format; a skill written for one tool may use features others lack.
Needs: Needs an MCP server
Security
What our scanner noticed· Low risk
- Scripts that your agent may run
This skill includes scripts that your agent may run. Read them before you use it.
A static scan is not a guarantee. Skills are third-party content: review a skill before you let an agent use it.
Attribution and licence
- Created by
- Seth Hobson
- Publisher
- Seth Hobson (Community)
- Source
- wshobson/agents · plugins/dotnet-contribution/skills/dotnet-backend-patterns · commit 4bde316
- Licence
- MIT License (redistribution allowed)
- LICENSE (added by AutoGineer from LICENSE)
- ATTRIBUTION.md (written by AutoGineer)
- Synced
AutoGineer is not affiliated with or endorsed by Seth Hobson or Seth Hobson.
Download ZIP
The ZIP holds the skill’s files, its licence files and an ATTRIBUTION.md. Download dotnet-backend-patterns.zip