Aspire.Microsoft.Data.SqlClient 9.0.0

Prefix Reserved
.NET 8.0 This package targets .NET 8.0. The package is compatible with this framework or higher. 
dotnet add package Aspire.Microsoft.Data.SqlClient --version 9.0.0                

                    
                

            
NuGet\Install-Package Aspire.Microsoft.Data.SqlClient -Version 9.0.0
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.Microsoft.Data.SqlClient" Version="9.0.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
paket add Aspire.Microsoft.Data.SqlClient --version 9.0.0                

                    
                

            
#r "nuget: Aspire.Microsoft.Data.SqlClient, 9.0.0"
#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.Microsoft.Data.SqlClient as a Cake Addin
#addin nuget:?package=Aspire.Microsoft.Data.SqlClient&version=9.0.0

// Install Aspire.Microsoft.Data.SqlClient as a Cake Tool
#tool nuget:?package=Aspire.Microsoft.Data.SqlClient&version=9.0.0

Aspire.Microsoft.Data.SqlClient library

Registers 'Scoped' Microsoft.Data.SqlClient.SqlConnection factory in the DI container for connecting Azure SQL, MS SQL database. Enables health check and telemetry.

Getting started

Prerequisites

  • Azure SQL or MS SQL server database and the connection string for accessing the database.

Install the package

Install the .NET Aspire SQL Server SqlClient library with NuGet:

dotnet add package Aspire.Microsoft.Data.SqlClient

Usage example

In the Program.cs file of your project, call the AddSqlServerClient extension method to register a SqlConnection for use via the dependency injection container. The method takes a connection name parameter.

builder.AddSqlServerClient("sqldata");

You can then retrieve the SqlConnection instance using dependency injection. For example, to retrieve the connection from a Web API controller:

private readonly SqlConnection _connection;

public ProductsController(SqlConnection connection)
{
    _connection = connection;
}

Configuration

The .NET Aspire SqlClient component provides multiple options to configure the SQL connection based on the requirements and conventions of your project.

Use a connection string

When using a connection string from the ConnectionStrings configuration section, you can provide the name of the connection string when calling builder.AddSqlServerClient():

builder.AddSqlServerClient("myConnection");

And then the connection string will be retrieved from the ConnectionStrings configuration section:

{
  "ConnectionStrings": {
    "myConnection": "Data Source=myserver;Initial Catalog=master"
  }
}

See the ConnectionString documentation for more information on how to format this connection string.

Use configuration providers

The .NET Aspire SqlClient component supports Microsoft.Extensions.Configuration. It loads the MicrosoftDataSqlClientSettings from configuration by using the Aspire:Microsoft:Data:SqlClient key. Example appsettings.json that configures some of the options:

{
  "Aspire": {
    "Microsoft": {
      "Data": {
        "SqlClient": {
          "DisableHealthChecks": false
        }
      }
    }
  }
}

Use inline delegates

Also you can pass the Action<MicrosoftDataSqlClientSettings> configureSettings delegate to set up some or all the options inline, for example to disable health checks from code:

builder.AddSqlServerClient("sqldata", settings => settings.DisableHealthChecks = true);

AppHost extensions

In your AppHost project, install the Aspire.Hosting.SqlServer library with NuGet:

dotnet add package Aspire.Hosting.SqlServer

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

var sql = builder.AddSqlServer("sql").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:

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 (1)

Showing the top 1 NuGet packages that depend on Aspire.Microsoft.Data.SqlClient:

Package Downloads
FonsecaFramework.Aspire

Collection of classes and extensions for .NET Aspire

GitHub repositories (2)

Showing the top 2 popular GitHub repositories that depend on Aspire.Microsoft.Data.SqlClient:

Repository Stars
dotnet/aspire-samples
rstropek/Samples
Version Downloads Last updated
9.0.0 564 11/12/2024
9.0.0-rc.1.24511.1 813 10/15/2024
8.2.2 2,355 10/24/2024
8.2.1 4,167 9/26/2024
8.2.0 9,719 8/29/2024
8.1.0 5,944 7/23/2024
8.0.2 2,847 6/28/2024
8.0.1 4,887 5/21/2024
8.0.0 746 5/21/2024
8.0.0-preview.7.24251.11 1,108 5/7/2024
8.0.0-preview.6.24214.1 2,278 4/23/2024
8.0.0-preview.5.24201.12 1,737 4/9/2024
8.0.0-preview.4.24156.9 946 3/12/2024
8.0.0-preview.3.24105.21 912 2/13/2024
8.0.0-preview.2.23619.3 1,487 12/20/2023
8.0.0-preview.1.23557.2 394 11/14/2023