اسنیپت‌ها، ترفندها و کدهای کاربردی

// Simple Method
SqlConnection CreateConnection(IServiceProvider sp)
{
    return new SqlConnection(
        builder.Configuration.GetConnectionString("DefaultConnection")
    );
}

// Convert to lumbda
SqlConnection CreateConnection(IServiceProvider sp)
{
    return new SqlConnection(
        builder.Configuration.GetConnectionString("DefaultConnection")
    );
}

// Use in Program Services
builder.Services.AddSingleton(sp =>
    new SqlConnection(
        builder.Configuration.GetConnectionString("DefaultConnection")
    )
);