SQL Server

SQL Server is a durable provider option for environments standardized on Microsoft data infrastructure.

It supports shared run coordination across workers through the same DurableStack contract.

Registration

using DurableStack.Hosting.DependencyInjection;

var connectionString = "Server=localhost;Database=durable_stack;User Id=sa;Password=Password123!;TrustServerCertificate=true";

builder.Services.AddDurableStackSqlServer(connectionString, options =>
{
    options.WorkerName = $"billing-api-{Environment.MachineName}-{Environment.ProcessId}";
});

Operational notes

• Prefer secure transport settings in production (Encrypt=True, trusted cert chain).
• Validate lock/throughput behavior under expected concurrency.
• Keep table-prefix strategy consistent across environments if used.