CommunityToolkit.Aspire.Hosting.SqlDatabaseProjects 9.1.0-beta.121

Prefix Reserved
This is a prerelease version of CommunityToolkit.Aspire.Hosting.SqlDatabaseProjects.
There is a newer version of this package available.
See the version list below for details.
dotnet add package CommunityToolkit.Aspire.Hosting.SqlDatabaseProjects --version 9.1.0-beta.121                
NuGet\Install-Package CommunityToolkit.Aspire.Hosting.SqlDatabaseProjects -Version 9.1.0-beta.121                
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-beta.121" />                
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-beta.121                
#r "nuget: CommunityToolkit.Aspire.Hosting.SqlDatabaseProjects, 9.1.0-beta.121"                
#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-beta.121&prerelease

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

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.197 30 18 hours ago
9.1.1-beta.196 27 19 hours ago
9.1.1-beta.195 27 19 hours ago
9.1.1-beta.194 25 19 hours ago
9.1.1-beta.193 24 21 hours ago
9.1.1-beta.192 43 a day ago
9.1.1-beta.191 49 2 days ago
9.1.1-beta.190 44 6 days ago
9.1.1-beta.189 37 6 days ago
9.1.1-beta.188 38 6 days ago
9.1.1-beta.187 46 7 days ago
9.1.1-beta.183 49 8 days ago
9.1.1-beta.182 48 8 days ago
9.1.1-beta.181 55 8 days ago
9.1.1-beta.180 46 8 days ago
9.1.1-beta.178 37 9 days ago
9.1.1-beta.177 38 13 days ago
9.1.1-beta.176 56 15 days ago
9.1.1-beta.175 46 15 days ago
9.1.1-beta.173 43 16 days ago
9.1.1-beta.169 39 20 days ago
9.1.1-beta.168 34 20 days ago
9.1.1-beta.166 94 21 days ago
9.1.1-beta.165 34 21 days ago
9.1.1-beta.164 42 22 days ago
9.1.1-beta.162 39 22 days ago
9.1.1-beta.155 36 a month ago
9.1.1-beta.154 38 a month ago
9.1.1-beta.153 34 a month ago
9.1.1-beta.152 14 a month ago
9.1.1-beta.150 36 a month ago
9.1.1-beta.148 36 a month ago
9.1.1-beta.147 32 a month ago
9.1.1-beta.146 34 a month ago
9.1.1-beta.145 31 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 12 a month ago
9.1.1-beta.128 16 2 months ago
9.1.1-beta.127 15 2 months ago
9.1.1-beta.126 16 2 months ago
9.1.1-beta.125 16 2 months ago
9.1.1-beta.124 11 2 months ago
9.1.0 1,191 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 46 2 months ago
9.1.0-beta.116 44 2 months ago
9.1.0-beta.114 44 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 44 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 49 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 433 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