Aspire.Hosting.Azure.Sql 8.2.1

Prefix Reserved
.NET 8.0 This package targets .NET 8.0. The package is compatible with this framework or higher.
There is a newer version of this package available.
See the version list below for details. 
dotnet add package Aspire.Hosting.Azure.Sql --version 8.2.1                

                    
                

            
NuGet\Install-Package Aspire.Hosting.Azure.Sql -Version 8.2.1
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package. 
<PackageReference Include="Aspire.Hosting.Azure.Sql" Version="8.2.1" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
paket add Aspire.Hosting.Azure.Sql --version 8.2.1                

                    
                

            
#r "nuget: Aspire.Hosting.Azure.Sql, 8.2.1"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package. 
// Install Aspire.Hosting.Azure.Sql as a Cake Addin
#addin nuget:?package=Aspire.Hosting.Azure.Sql&version=8.2.1

// Install Aspire.Hosting.Azure.Sql as a Cake Tool
#tool nuget:?package=Aspire.Hosting.Azure.Sql&version=8.2.1

Aspire.Hosting.Azure.Sql library

Provides extension methods and resource definitions for a .NET Aspire AppHost to configure Azure SQL Server.

Getting started

Prerequisites

Install the package

Install the .NET Aspire Azure SQL Server Hosting library with NuGet:

dotnet add package Aspire.Hosting.Azure.Sql

Configure Azure Provisioning for local development

Adding Azure resources to the .NET Aspire application model will automatically enable development-time provisioning for Azure resources so that you don't need to configure them manually. Provisioning requires a number of settings to be available via .NET configuration. Set these values in user secrets in order to allow resources to be configured automatically.

{
    "Azure": {
      "SubscriptionId": "<your subscription id>",
      "ResourceGroupPrefix": "<prefix for the resource group>",
      "Location": "<azure location>"
    }
}

NOTE: Developers must have Owner access to the target subscription so that role assignments can be configured for the provisioned resources.

Usage example

In the Program.cs file of AppHost, register a SqlServer database and consume the connection using the following methods:

var sql = builder.AddSqlServer("sql")
                 .AsAzureSqlDatabase()
                 .AddDatabase("sqldata");

var myService = builder.AddProject<Projects.MyService>()
                       .WithReference(sql);

The WithReference method configures a connection in the MyService project named sqldata. In the Program.cs file of MyService, the sql connection can be consumed using the client library Aspire.Microsoft.Data.SqlClient:

builder.AddSqlServerClient("sqldata");

Additional documentation

Feedback & contributing

https://github.com/dotnet/aspire

Product Compatible and additional computed target framework versions.
.NET net8.0 is compatible.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories (1)

Showing the top 1 popular GitHub repositories that depend on Aspire.Hosting.Azure.Sql:

Repository Stars
rstropek/Samples
Version Downloads Last updated
9.0.0 1,449 11/12/2024
9.0.0-rc.1.24511.1 831 10/15/2024
8.2.2 1,872 10/24/2024
8.2.1 4,446 9/26/2024
8.2.0 7,430 8/29/2024
8.1.0 3,756 7/23/2024
8.0.2 2,663 6/28/2024
8.0.1 3,089 5/21/2024
8.0.0 159 5/21/2024
8.0.0-preview.7.24251.11 505 5/7/2024
8.0.0-preview.6.24214.1 530 4/23/2024
8.0.0-preview.5.24201.12 735 4/9/2024