CommunityToolkit.Aspire.Hosting.SqlDatabaseProjects 9.1.0

Prefix Reserved
There is a newer prerelease version of this package available.
See the version list below for details.
dotnet add package CommunityToolkit.Aspire.Hosting.SqlDatabaseProjects --version 9.1.0                
NuGet\Install-Package CommunityToolkit.Aspire.Hosting.SqlDatabaseProjects -Version 9.1.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="CommunityToolkit.Aspire.Hosting.SqlDatabaseProjects" Version="9.1.0" />                
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add CommunityToolkit.Aspire.Hosting.SqlDatabaseProjects --version 9.1.0                
#r "nuget: CommunityToolkit.Aspire.Hosting.SqlDatabaseProjects, 9.1.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 CommunityToolkit.Aspire.Hosting.SqlDatabaseProjects as a Cake Addin
#addin nuget:?package=CommunityToolkit.Aspire.Hosting.SqlDatabaseProjects&version=9.1.0

// Install CommunityToolkit.Aspire.Hosting.SqlDatabaseProjects as a Cake Tool
#tool nuget:?package=CommunityToolkit.Aspire.Hosting.SqlDatabaseProjects&version=9.1.0                

CommunityToolkit.Aspire.Hosting.SqlDatabaseProjects library

This package provides .NET Aspire integration for SQL Server Database Projects. It allows you to publish SQL Database Projects as part of your .NET Aspire AppHost projects. It currently works with both MSBuild.Sdk.SqlProj and Microsoft.Build.Sql (aka .sqlprojx) based projects.

Usage

To use this package, install it into your .NET Aspire AppHost project:

dotnet add package CommunityToolkit.Aspire.Hosting.SqlDatabaseProjects

Next, add a reference to the MSBuild.Sdk.SqlProj or Microsoft.Build.Sql project you want to publish in your .NET Aspire AppHost project:

dotnet add reference ../MySqlProj/MySqlProj.csproj

Note: Adding this reference will currently result in warning ASPIRE004. This is a known issue and will be resolved in a future release.

Finally add the project as a resource to your .NET Aspire AppHost:

var builder = DistributedApplication.CreateBuilder(args);

var sql = builder.AddSqlServer("sql")
                 .AddDatabase("test");

builder.AddSqlProject<Projects.MySqlProj>("mysqlproj")
       .WithReference(sql);

builder.Build().Run();

Now when you run your .NET Aspire AppHost project you will see the SQL Database Project being published to the specified SQL Server.

Local .dacpac file support

If you are sourcing your .dacpac file from somewhere other than a project reference, you can also specify the path to the .dacpac file directly:

var builder = DistributedApplication.CreateBuilder(args);

var sql = builder.AddSqlServer("sql")
                 .AddDatabase("test");

builder.AddSqlProject("mysqlproj")
       .WithDacpac("path/to/mysqlproj.dacpac")
       .WithReference(sql);

builder.Build().Run();

Deployment options support

Define options that affect the behavior of package deployment.

var builder = DistributedApplication.CreateBuilder(args);

var sql = builder.AddSqlServer("sql")
                 .AddDatabase("test");

builder.AddSqlProject("mysqlproj")
       .WithConfigureDacDeployOptions(options => options.IncludeCompositeObjects = true)
       .WithReference(sql);

builder.Build().Run();
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.  net9.0 is compatible.  net9.0-android was computed.  net9.0-browser was computed.  net9.0-ios was computed.  net9.0-maccatalyst was computed.  net9.0-macos was computed.  net9.0-tvos was computed.  net9.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

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
9.1.1-beta.190 35 a day ago
9.1.1-beta.189 32 2 days ago
9.1.1-beta.188 33 2 days ago
9.1.1-beta.187 37 2 days ago
9.1.1-beta.183 37 3 days ago
9.1.1-beta.182 36 3 days ago
9.1.1-beta.181 43 3 days ago
9.1.1-beta.180 34 4 days ago
9.1.1-beta.178 27 4 days ago
9.1.1-beta.177 32 8 days ago
9.1.1-beta.176 51 10 days ago
9.1.1-beta.175 39 10 days ago
9.1.1-beta.173 38 11 days ago
9.1.1-beta.169 38 15 days ago
9.1.1-beta.168 31 16 days ago
9.1.1-beta.166 91 16 days ago
9.1.1-beta.165 31 16 days ago
9.1.1-beta.164 39 17 days ago
9.1.1-beta.162 38 17 days ago
9.1.1-beta.155 35 22 days ago
9.1.1-beta.154 32 22 days ago
9.1.1-beta.153 33 22 days ago
9.1.1-beta.152 13 23 days ago
9.1.1-beta.150 35 23 days ago
9.1.1-beta.148 35 a month ago
9.1.1-beta.147 31 a month ago
9.1.1-beta.146 34 a month ago
9.1.1-beta.145 29 a month ago
9.1.1-beta.144 31 a month ago
9.1.1-beta.142 31 a month ago
9.1.1-beta.140 30 a month ago
9.1.1-beta.139 31 a month ago
9.1.1-beta.138 30 a month ago
9.1.1-beta.137 35 a month ago
9.1.1-beta.136 31 a month ago
9.1.1-beta.135 11 a month ago
9.1.1-beta.134 10 a month ago
9.1.1-beta.128 14 a month ago
9.1.1-beta.127 15 a month ago
9.1.1-beta.126 16 a month ago
9.1.1-beta.125 16 a month ago
9.1.1-beta.124 11 a month ago
9.1.0 1,081 2 months ago
9.1.0-beta.123 50 2 months ago
9.1.0-beta.122 50 2 months ago
9.1.0-beta.121 46 2 months ago
9.1.0-beta.120 44 2 months ago
9.1.0-beta.119 40 2 months ago
9.1.0-beta.118 44 2 months ago
9.1.0-beta.116 44 2 months ago
9.1.0-beta.114 42 2 months ago
9.1.0-beta.113 42 2 months ago
9.1.0-beta.112 42 2 months ago
9.1.0-beta.110 48 2 months ago
9.1.0-beta.109 42 2 months ago
9.0.1-beta.108 51 2 months ago
9.0.1-beta.107 46 2 months ago
9.0.1-beta.106 45 2 months ago
9.0.1-beta.104 45 2 months ago
9.0.1-beta.102 47 3 months ago
9.0.1-beta.99 49 3 months ago
9.0.1-beta.98 47 3 months ago
9.0.1-beta.95 50 3 months ago
9.0.1-beta.94 48 3 months ago
9.0.1-beta.93 42 3 months ago
9.0.1-beta.92 141 3 months ago
9.0.1-beta.91 41 3 months ago
9.0.1-beta.90 48 3 months ago
9.0.1-beta.89 49 3 months ago
9.0.1-beta.88 49 3 months ago
9.0.1-beta.87 41 3 months ago
9.0.1-beta.86 48 3 months ago
9.0.1-beta.84 54 3 months ago
9.0.1-beta.83 54 3 months ago
9.0.1-beta.82 54 3 months ago
9.0.1-beta.81 44 3 months ago
9.0.1-beta.80 38 3 months ago
9.0.1-beta.79 46 3 months ago
9.0.1-beta.77 45 3 months ago
9.0.0 430 3 months ago
9.0.0-beta.76 48 3 months ago
9.0.0-beta.75 44 3 months ago
9.0.0-beta.74 48 3 months ago
9.0.0-beta.73 171 3 months ago
9.0.0-beta.72 45 3 months ago
9.0.0-beta.71 46 3 months ago
9.0.0-beta.70 104 3 months ago
9.0.0-beta.69 54 3 months ago
9.0.0-beta.68 54 3 months ago
9.0.0-beta.67 48 3 months ago
9.0.0-beta.66 85 3 months ago
9.0.0-beta.63 59 3 months ago