CommunityToolkit.Aspire.Hosting.SqlDatabaseProjects 9.5.1-beta.303

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.5.1-beta.303
                    
NuGet\Install-Package CommunityToolkit.Aspire.Hosting.SqlDatabaseProjects -Version 9.5.1-beta.303
                    
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.5.1-beta.303" />
                    
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="CommunityToolkit.Aspire.Hosting.SqlDatabaseProjects" Version="9.5.1-beta.303" />
                    
Directory.Packages.props
<PackageReference Include="CommunityToolkit.Aspire.Hosting.SqlDatabaseProjects" />
                    
Project file
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package.
paket add CommunityToolkit.Aspire.Hosting.SqlDatabaseProjects --version 9.5.1-beta.303
                    
#r "nuget: CommunityToolkit.Aspire.Hosting.SqlDatabaseProjects, 9.5.1-beta.303"
                    
#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.
#:package CommunityToolkit.Aspire.Hosting.SqlDatabaseProjects@9.5.1-beta.303
                    
#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package.
#addin nuget:?package=CommunityToolkit.Aspire.Hosting.SqlDatabaseProjects&version=9.5.1-beta.303&prerelease
                    
Install as a Cake Addin
#tool nuget:?package=CommunityToolkit.Aspire.Hosting.SqlDatabaseProjects&version=9.5.1-beta.303&prerelease
                    
Install as a Cake Tool

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

Support for existing SQL Server

Instead of using the AddSqlServer method to use a SQL Server container, you can specify a connection string to an existing server:

var builder = DistributedApplication.CreateBuilder(args);

// Get an existing connection string from the configuration
var connection = builder.AddConnectionString("Aspire");

builder.AddSqlProject<Projects.SdkProject>("mysqlproj")
       .WithReference(connection);

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.  net10.0 was computed.  net10.0-android was computed.  net10.0-browser was computed.  net10.0-ios was computed.  net10.0-maccatalyst was computed.  net10.0-macos was computed.  net10.0-tvos was computed.  net10.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.8.0 755 13 days ago
9.8.0-beta.402 114 10 days ago
9.8.0-beta.401 110 10 days ago
9.8.0-beta.399 119 13 days ago
9.8.0-beta.398 122 13 days ago
9.8.0-beta.397 123 13 days ago
9.8.0-beta.395 115 15 days ago
9.8.0-beta.394 121 16 days ago
9.8.0-beta.393 121 16 days ago
9.8.0-beta.392 117 16 days ago
9.8.0-beta.389 246 21 days ago
9.8.0-beta.388 252 23 days ago
9.8.0-beta.386 222 24 days ago
9.8.0-beta.385 199 24 days ago
9.8.0-beta.384 47 a month ago
9.8.0-beta.376 131 a month ago
9.8.0-beta.375 62 a month ago
9.8.0-beta.373 134 a month ago
9.8.0-beta.372 134 a month ago
9.8.0-beta.370 120 a month ago
9.8.0-beta.364 120 a month ago
9.7.2 2,556 a month ago
9.7.2-beta.362 165 a month ago
9.7.2-beta.361 165 a month ago
9.7.2-beta.360 168 a month ago
9.7.2-beta.359 166 a month ago
9.7.2-beta.358 163 a month ago
9.7.2-beta.357 169 a month ago
9.7.1 791 a month ago
9.7.1-beta.355 168 a month ago
9.7.1-beta.354 169 a month ago
9.7.1-beta.353 165 a month ago
9.7.1-beta.352 166 a month ago
9.7.1-beta.351 172 a month ago
9.7.1-beta.348 136 2 months ago
9.7.1-beta.344 75 2 months ago
9.7.1-beta.343 199 2 months ago
9.7.1-beta.342 200 2 months ago
9.7.1-beta.341 201 2 months ago
9.7.1-beta.340 184 2 months ago
9.7.1-beta.339 183 2 months ago
9.7.0 1,829 2 months ago
9.7.0-beta.337 80 2 months ago
9.7.0-beta.336 93 2 months ago
9.7.0-beta.335 95 2 months ago
9.7.0-beta.333 97 2 months ago
9.6.1-beta.332 97 2 months ago
9.6.1-beta.331 98 2 months ago
9.6.1-beta.330 100 2 months ago
9.6.1-beta.329 99 2 months ago
9.6.1-beta.328 190 2 months ago
9.6.1-beta.327 119 2 months ago
9.6.1-beta.326 115 2 months ago
9.6.0 2,943 3 months ago
9.6.0-beta.324 123 3 months ago
9.5.1-beta.323 120 3 months ago
9.5.1-beta.322 125 3 months ago
9.5.1-beta.321 126 3 months ago
9.5.1-beta.320 126 3 months ago
9.5.1-beta.319 124 3 months ago
9.5.1-beta.318 125 3 months ago
9.5.1-beta.317 122 3 months ago
9.5.1-beta.315 123 3 months ago
9.5.1-beta.314 135 4 months ago
9.5.1-beta.313 123 4 months ago
9.5.1-beta.312 116 4 months ago
9.5.1-beta.311 128 4 months ago
9.5.1-beta.310 141 4 months ago
9.5.1-beta.309 122 4 months ago
9.5.1-beta.308 139 4 months ago
9.5.1-beta.307 137 4 months ago
9.5.1-beta.306 291 4 months ago
9.5.1-beta.305 122 4 months ago
9.5.1-beta.304 113 4 months ago
9.5.1-beta.303 167 4 months ago
9.5.1-beta.302 132 4 months ago
9.5.1-beta.301 144 4 months ago
9.5.1-beta.300 137 4 months ago
9.5.0 7,852 4 months ago
9.5.0-beta.299 142 4 months ago
9.5.0-beta.298 152 4 months ago
9.5.0-beta.297 87 4 months ago
9.5.0-beta.296 93 4 months ago
9.5.0-beta.295 79 4 months ago
9.4.1-beta.291 146 5 months ago
9.4.1-beta.289 159 5 months ago
9.4.1-beta.288 217 5 months ago
9.4.1-beta.287 206 5 months ago
9.4.1-beta.286 214 5 months ago
9.4.1-beta.285 208 5 months ago
9.4.1-beta.284 223 5 months ago
9.4.1-beta.283 221 5 months ago
9.4.1-beta.282 134 5 months ago
9.4.1-beta.280 144 5 months ago
9.4.1-beta.279 132 5 months ago
9.4.1-beta.277 142 6 months ago
9.4.1-beta.276 157 6 months ago
9.4.1-beta.275 157 6 months ago
9.4.1-beta.274 162 6 months ago
9.4.1-beta.273 148 6 months ago
9.4.1-beta.272 160 6 months ago
9.4.1-beta.271 152 6 months ago
9.4.1-beta.270 160 6 months ago
9.4.0 4,260 6 months ago
9.4.0-beta.269 159 6 months ago
9.4.0-beta.268 154 6 months ago
9.3.1-beta.267 161 6 months ago
9.3.1-beta.266 89 6 months ago
9.3.1-beta.265 288 6 months ago
9.3.1-beta.264 169 6 months ago
9.3.1-beta.263 184 6 months ago
9.3.1-beta.262 199 6 months ago
9.3.1-beta.260 158 6 months ago
9.3.1-beta.259 1,696 6 months ago
9.3.1-beta.258 157 6 months ago
9.3.1-beta.257 147 6 months ago
9.3.1-beta.256 160 6 months ago
9.3.1-beta.255 146 6 months ago
9.3.1-beta.254 164 6 months ago
9.3.1-beta.253 165 6 months ago
9.3.1-beta.252 404 6 months ago
9.3.1-beta.250 121 6 months ago
9.3.1-beta.249 121 6 months ago
9.3.1-beta.248 121 6 months ago
9.3.1-beta.247 136 6 months ago
9.3.1-beta.244 484 6 months ago
9.3.1-beta.242 468 6 months ago
9.3.1-beta.241 160 7 months ago
9.3.0 7,270 7 months ago
9.3.0-beta.239 135 7 months ago
9.2.2-beta.237 148 7 months ago
9.2.2-beta.236 115 7 months ago
9.2.2-beta.230 163 7 months ago
9.2.2-beta.229 150 7 months ago
9.2.2-beta.228 165 7 months ago
9.2.2-beta.227 153 7 months ago
9.2.2-beta.226 151 7 months ago
9.2.2-beta.225 155 7 months ago
9.2.2-beta.224 143 7 months ago
9.2.2-beta.223 170 7 months ago
9.2.2-beta.222 172 7 months ago
9.2.2-beta.220 156 7 months ago
9.2.2-beta.218 149 7 months ago
9.2.2-beta.217 208 7 months ago
9.2.2-beta.216 188 7 months ago
9.2.2-beta.215 189 7 months ago
9.2.2-beta.214 198 7 months ago
9.2.2-beta.213 191 7 months ago
9.2.2-beta.212 181 7 months ago
9.2.2-beta.211 195 7 months ago
9.2.2-beta.210 197 7 months ago
9.2.2-beta.208 85 7 months ago
9.2.1 1,607 7 months ago
9.2.1-beta.207 136 7 months ago
9.2.1-beta.206 89 7 months ago
9.2.1-beta.205 83 7 months ago
9.2.1-beta.204 95 7 months ago
9.2.1-beta.203 84 7 months ago
9.2.0 867 7 months ago
9.2.0-beta.202 91 7 months ago
9.2.0-beta.201 112 7 months ago
9.2.0-beta.199 84 7 months ago
9.2.0-beta.198 75 7 months ago
9.1.1-beta.197 109 7 months ago
9.1.1-beta.196 89 7 months ago
9.1.1-beta.195 99 7 months ago
9.1.1-beta.194 79 7 months ago
9.1.1-beta.193 87 7 months ago
9.1.1-beta.192 87 7 months ago
9.1.1-beta.191 106 7 months ago
9.1.1-beta.190 95 8 months ago
9.1.1-beta.189 93 8 months ago
9.1.1-beta.188 90 8 months ago
9.1.1-beta.187 103 8 months ago
9.1.1-beta.183 108 8 months ago
9.1.1-beta.182 85 8 months ago
9.1.1-beta.181 110 8 months ago
9.1.1-beta.180 96 8 months ago
9.1.1-beta.178 98 8 months ago
9.1.1-beta.177 111 8 months ago
9.1.1-beta.176 113 8 months ago
9.1.1-beta.175 108 8 months ago
9.1.1-beta.173 98 8 months ago
9.1.1-beta.169 97 8 months ago
9.1.1-beta.168 93 8 months ago
9.1.1-beta.166 158 8 months ago
9.1.1-beta.165 84 8 months ago
9.1.1-beta.164 97 8 months ago
9.1.1-beta.162 77 8 months ago
9.1.1-beta.155 107 8 months ago
9.1.1-beta.154 103 8 months ago
9.1.1-beta.153 73 8 months ago
9.1.1-beta.152 89 8 months ago
9.1.1-beta.150 97 8 months ago
9.1.1-beta.148 97 8 months ago
9.1.1-beta.147 89 8 months ago
9.1.1-beta.146 89 9 months ago
9.1.1-beta.145 71 9 months ago
9.1.1-beta.144 89 9 months ago
9.1.1-beta.142 88 9 months ago
9.1.1-beta.140 88 9 months ago
9.1.1-beta.139 91 9 months ago
9.1.1-beta.138 82 9 months ago
9.1.1-beta.137 74 9 months ago
9.1.1-beta.136 87 9 months ago
9.1.1-beta.135 46 9 months ago
9.1.1-beta.134 52 9 months ago
9.1.1-beta.128 74 9 months ago
9.1.1-beta.127 62 9 months ago
9.1.1-beta.126 80 9 months ago
9.1.1-beta.125 94 9 months ago
9.1.1-beta.124 73 9 months ago
9.1.0 2,845 10 months ago
9.1.0-beta.123 98 9 months ago
9.1.0-beta.122 109 9 months ago
9.1.0-beta.121 79 9 months ago
9.1.0-beta.120 89 9 months ago
9.1.0-beta.119 76 9 months ago
9.1.0-beta.118 86 9 months ago
9.1.0-beta.116 97 9 months ago
9.1.0-beta.114 77 9 months ago
9.1.0-beta.113 85 9 months ago
9.1.0-beta.112 87 10 months ago
9.1.0-beta.110 97 10 months ago
9.1.0-beta.109 91 10 months ago
9.0.1-beta.108 108 10 months ago
9.0.1-beta.107 81 10 months ago
9.0.1-beta.106 91 10 months ago
9.0.1-beta.104 93 10 months ago
9.0.1-beta.102 82 12/6/2024
9.0.1-beta.99 97 12/6/2024
9.0.1-beta.98 85 12/6/2024
9.0.1-beta.95 81 12/5/2024
9.0.1-beta.94 77 12/5/2024
9.0.1-beta.93 73 12/2/2024
9.0.1-beta.92 181 11/30/2024
9.0.1-beta.91 90 11/30/2024
9.0.1-beta.90 91 11/29/2024
9.0.1-beta.89 100 11/29/2024
9.0.1-beta.88 93 11/27/2024
9.0.1-beta.87 88 11/27/2024
9.0.1-beta.86 96 11/27/2024
9.0.1-beta.84 103 11/24/2024
9.0.1-beta.83 95 11/22/2024
9.0.1-beta.82 97 11/21/2024
9.0.1-beta.81 88 11/19/2024
9.0.1-beta.80 78 11/19/2024
9.0.1-beta.79 101 11/19/2024
9.0.1-beta.77 94 11/15/2024
9.0.0 723 11/15/2024
9.0.0-beta.76 88 11/14/2024
9.0.0-beta.75 96 11/14/2024
9.0.0-beta.74 90 11/14/2024
9.0.0-beta.73 208 11/14/2024
9.0.0-beta.72 71 11/14/2024
9.0.0-beta.71 82 11/13/2024
9.0.0-beta.70 146 11/13/2024
9.0.0-beta.69 94 11/13/2024
9.0.0-beta.68 93 11/13/2024
9.0.0-beta.67 77 11/13/2024
9.0.0-beta.66 138 11/13/2024
9.0.0-beta.63 102 11/12/2024