AzureSqlExtensions Methods
Class Methods 6 members
Provides extension methods for adding the Azure SQL resources to the application model.
AddAzureSqlServer(IDistributedApplicationBuilder, string) Section titled AddAzureSqlServer(IDistributedApplicationBuilder, string) extension IResourceBuilder<AzureSqlServerResource> Adds an Azure SQL Database (server) resource to the application model.
public static class AzureSqlExtensions{ public static IResourceBuilder<AzureSqlServerResource> AddAzureSqlServer( this IDistributedApplicationBuilder builder, string name) { // ... }}Parameters
builder IDistributedApplicationBuilder The builder for the distributed application. name string The name of the resource. Returns
IResourceBuilder<AzureSqlServerResource> A reference to the ApplicationModel.IResourceBuilder`1 builder. AddDatabase(IResourceBuilder<AzureSqlServerResource>, string, string?) Section titled AddDatabase(IResourceBuilder<AzureSqlServerResource>, string, string?) extension IResourceBuilder<AzureSqlDatabaseResource> Adds an Azure SQL Database to the application model. The Free Offer option will be used when deploying the resource in Azure
public static class AzureSqlExtensions{ public static IResourceBuilder<AzureSqlDatabaseResource> AddDatabase( this IResourceBuilder<AzureSqlServerResource> builder, string name, string? databaseName = null) { // ... }}Parameters
builder IResourceBuilder<AzureSqlServerResource> The builder for the Azure SQL resource. name string The name of the resource. This name will be used as the connection string name when referenced in a dependency. databaseName string? optional The name of the database. If not provided, this defaults to the same value as name. Returns
IResourceBuilder<AzureSqlDatabaseResource> A reference to the ApplicationModel.IResourceBuilder`1. AsAzureSqlDatabase(IResourceBuilder<SqlServerServerResource>) Section titled AsAzureSqlDatabase(IResourceBuilder<SqlServerServerResource>) extension IResourceBuilder<SqlServerServerResource> Configures SQL Server resource to be deployed as Azure SQL Database (server).
public static class AzureSqlExtensions{ public static IResourceBuilder<SqlServerServerResource> AsAzureSqlDatabase( this IResourceBuilder<SqlServerServerResource> builder) { // ... }}Parameters
builder IResourceBuilder<SqlServerServerResource> The builder for the SQL Server resource. Returns
IResourceBuilder<SqlServerServerResource> A reference to the ApplicationModel.IResourceBuilder`1. PublishAsAzureSqlDatabase(IResourceBuilder<SqlServerServerResource>) Section titled PublishAsAzureSqlDatabase(IResourceBuilder<SqlServerServerResource>) extension IResourceBuilder<SqlServerServerResource> Configures SQL Server resource to be deployed as Azure SQL Database (server).
public static class AzureSqlExtensions{ public static IResourceBuilder<SqlServerServerResource> PublishAsAzureSqlDatabase( this IResourceBuilder<SqlServerServerResource> builder) { // ... }}Parameters
builder IResourceBuilder<SqlServerServerResource> The builder for the SQL Server resource. Returns
IResourceBuilder<SqlServerServerResource> A reference to the ApplicationModel.IResourceBuilder`1. RunAsContainer(IResourceBuilder<AzureSqlServerResource>, Action<IResourceBuilder<SqlServerServerResource>>) Section titled RunAsContainer(IResourceBuilder<AzureSqlServerResource>, Action<IResourceBuilder<SqlServerServerResource>>) extension IResourceBuilder<AzureSqlServerResource> Configures an Azure SQL Database (server) resource to run locally in a container.
public static class AzureSqlExtensions{ public static IResourceBuilder<AzureSqlServerResource> RunAsContainer( this IResourceBuilder<AzureSqlServerResource> builder, Action<IResourceBuilder<SqlServerServerResource>>? configureContainer = null) { // ... }}Parameters
builder IResourceBuilder<AzureSqlServerResource> The builder for the Azure SQL resource. configureContainer Action<IResourceBuilder<SqlServerServerResource>> optional Callback that exposes underlying container to allow for customization. Returns
IResourceBuilder<AzureSqlServerResource> A reference to the ApplicationModel.IResourceBuilder`1 builder. Remarks
The following example creates an Azure SQL Database (server) resource that runs locally in a SQL Server container and referencing that resource in a .NET project.
var builder = DistributedApplication.CreateBuilder(args);
var data = builder.AddAzureSqlServer("data") .RunAsContainer();
builder.AddProject<Projects.ProductService>() .WithReference(data);
builder.Build().Run();WithDefaultAzureSku(IResourceBuilder<AzureSqlDatabaseResource>) Section titled WithDefaultAzureSku(IResourceBuilder<AzureSqlDatabaseResource>) extension IResourceBuilder<AzureSqlDatabaseResource> Configures the Azure SQL Database to be deployed use the default SKU provided by Azure. Please be aware that the Azure default Sku might not take advantage of the free offer.
public static class AzureSqlExtensions{ public static IResourceBuilder<AzureSqlDatabaseResource> WithDefaultAzureSku( this IResourceBuilder<AzureSqlDatabaseResource> builder) { // ... }}Parameters
builder IResourceBuilder<AzureSqlDatabaseResource> The builder for the Azure SQL resource. Returns
IResourceBuilder<AzureSqlDatabaseResource> A reference to the ApplicationModel.IResourceBuilder`1.