CommunityToolkit.Aspire.Hosting.SqlDatabaseProjects 9.5.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.5.0
                    
NuGet\Install-Package CommunityToolkit.Aspire.Hosting.SqlDatabaseProjects -Version 9.5.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.5.0" />
                    
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.0" />
                    
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.0
                    
#r "nuget: CommunityToolkit.Aspire.Hosting.SqlDatabaseProjects, 9.5.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.
#addin nuget:?package=CommunityToolkit.Aspire.Hosting.SqlDatabaseProjects&version=9.5.0
                    
Install CommunityToolkit.Aspire.Hosting.SqlDatabaseProjects as a Cake Addin
#tool nuget:?package=CommunityToolkit.Aspire.Hosting.SqlDatabaseProjects&version=9.5.0
                    
Install CommunityToolkit.Aspire.Hosting.SqlDatabaseProjects 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.5.1-beta.313 88 2 days ago
9.5.1-beta.312 93 2 days ago
9.5.1-beta.311 104 4 days ago
9.5.1-beta.310 106 5 days ago
9.5.1-beta.309 100 5 days ago
9.5.1-beta.308 104 5 days ago
9.5.1-beta.307 104 6 days ago
9.5.1-beta.306 256 12 days ago
9.5.1-beta.305 86 15 days ago
9.5.1-beta.304 97 16 days ago
9.5.1-beta.303 109 18 days ago
9.5.1-beta.302 111 18 days ago
9.5.1-beta.301 114 20 days ago
9.5.1-beta.300 119 25 days ago
9.5.0 1,183 a month ago
9.5.0-beta.299 109 a month ago
9.5.0-beta.298 118 a month ago
9.5.0-beta.297 67 a month ago
9.5.0-beta.296 63 a month ago
9.5.0-beta.295 43 a month ago
9.4.1-beta.291 113 a month ago
9.4.1-beta.289 122 a month ago
9.4.1-beta.288 175 a month ago
9.4.1-beta.287 171 a month ago
9.4.1-beta.286 173 a month ago
9.4.1-beta.285 191 a month ago
9.4.1-beta.284 193 a month ago
9.4.1-beta.283 200 a month ago
9.4.1-beta.282 116 a month ago
9.4.1-beta.280 117 2 months ago
9.4.1-beta.279 111 2 months ago
9.4.1-beta.277 125 2 months ago
9.4.1-beta.276 124 2 months ago
9.4.1-beta.275 125 2 months ago
9.4.1-beta.274 129 2 months ago
9.4.1-beta.273 118 2 months ago
9.4.1-beta.272 124 2 months ago
9.4.1-beta.271 120 2 months ago
9.4.1-beta.270 126 2 months ago
9.4.0 2,232 2 months ago
9.4.0-beta.269 127 2 months ago
9.4.0-beta.268 120 2 months ago
9.3.1-beta.267 124 2 months ago
9.3.1-beta.266 55 2 months ago
9.3.1-beta.265 258 2 months ago
9.3.1-beta.264 152 2 months ago
9.3.1-beta.263 150 2 months ago
9.3.1-beta.262 156 2 months ago
9.3.1-beta.260 138 2 months ago
9.3.1-beta.259 845 2 months ago
9.3.1-beta.258 126 2 months ago
9.3.1-beta.257 123 2 months ago
9.3.1-beta.256 129 2 months ago
9.3.1-beta.255 124 2 months ago
9.3.1-beta.254 124 2 months ago
9.3.1-beta.253 131 3 months ago
9.3.1-beta.252 371 3 months ago
9.3.1-beta.250 103 3 months ago
9.3.1-beta.249 99 3 months ago
9.3.1-beta.248 103 3 months ago
9.3.1-beta.247 105 3 months ago
9.3.1-beta.244 448 3 months ago
9.3.1-beta.242 443 3 months ago
9.3.1-beta.241 125 3 months ago
9.3.0 4,235 3 months ago
9.3.0-beta.239 113 3 months ago
9.2.2-beta.237 116 3 months ago
9.2.2-beta.236 89 3 months ago
9.2.2-beta.230 125 3 months ago
9.2.2-beta.229 113 3 months ago
9.2.2-beta.228 137 3 months ago
9.2.2-beta.227 120 3 months ago
9.2.2-beta.226 131 3 months ago
9.2.2-beta.225 117 3 months ago
9.2.2-beta.224 121 3 months ago
9.2.2-beta.223 131 3 months ago
9.2.2-beta.222 135 3 months ago
9.2.2-beta.220 128 3 months ago
9.2.2-beta.218 127 3 months ago
9.2.2-beta.217 170 4 months ago
9.2.2-beta.216 170 4 months ago
9.2.2-beta.215 170 4 months ago
9.2.2-beta.214 166 4 months ago
9.2.2-beta.213 161 4 months ago
9.2.2-beta.212 161 4 months ago
9.2.2-beta.211 168 4 months ago
9.2.2-beta.210 164 4 months ago
9.2.2-beta.208 65 4 months ago
9.2.1 1,401 4 months ago
9.2.1-beta.207 97 4 months ago
9.2.1-beta.206 57 4 months ago
9.2.1-beta.205 61 4 months ago
9.2.1-beta.204 60 4 months ago
9.2.1-beta.203 56 4 months ago
9.2.0 826 4 months ago
9.2.0-beta.202 58 4 months ago
9.2.0-beta.201 65 4 months ago
9.2.0-beta.199 55 4 months ago
9.2.0-beta.198 49 4 months ago
9.1.1-beta.197 74 4 months ago
9.1.1-beta.196 57 4 months ago
9.1.1-beta.195 59 4 months ago
9.1.1-beta.194 59 4 months ago
9.1.1-beta.193 55 4 months ago
9.1.1-beta.192 60 4 months ago
9.1.1-beta.191 70 4 months ago
9.1.1-beta.190 66 4 months ago
9.1.1-beta.189 64 4 months ago
9.1.1-beta.188 63 4 months ago
9.1.1-beta.187 67 4 months ago
9.1.1-beta.183 73 4 months ago
9.1.1-beta.182 69 4 months ago
9.1.1-beta.181 78 4 months ago
9.1.1-beta.180 65 4 months ago
9.1.1-beta.178 62 4 months ago
9.1.1-beta.177 79 4 months ago
9.1.1-beta.176 84 4 months ago
9.1.1-beta.175 72 4 months ago
9.1.1-beta.173 72 4 months ago
9.1.1-beta.169 64 5 months ago
9.1.1-beta.168 57 5 months ago
9.1.1-beta.166 117 5 months ago
9.1.1-beta.165 52 5 months ago
9.1.1-beta.164 66 5 months ago
9.1.1-beta.162 60 5 months ago
9.1.1-beta.155 59 5 months ago
9.1.1-beta.154 64 5 months ago
9.1.1-beta.153 55 5 months ago
9.1.1-beta.152 53 5 months ago
9.1.1-beta.150 63 5 months ago
9.1.1-beta.148 66 5 months ago
9.1.1-beta.147 56 5 months ago
9.1.1-beta.146 58 5 months ago
9.1.1-beta.145 54 5 months ago
9.1.1-beta.144 53 5 months ago
9.1.1-beta.142 55 5 months ago
9.1.1-beta.140 53 5 months ago
9.1.1-beta.139 57 5 months ago
9.1.1-beta.138 51 5 months ago
9.1.1-beta.137 53 5 months ago
9.1.1-beta.136 53 5 months ago
9.1.1-beta.135 25 5 months ago
9.1.1-beta.134 25 5 months ago
9.1.1-beta.128 44 5 months ago
9.1.1-beta.127 41 5 months ago
9.1.1-beta.126 49 5 months ago
9.1.1-beta.125 63 5 months ago
9.1.1-beta.124 48 5 months ago
9.1.0 2,775 6 months ago
9.1.0-beta.123 66 6 months ago
9.1.0-beta.122 70 6 months ago
9.1.0-beta.121 61 6 months ago
9.1.0-beta.120 61 6 months ago
9.1.0-beta.119 58 6 months ago
9.1.0-beta.118 58 6 months ago
9.1.0-beta.116 59 6 months ago
9.1.0-beta.114 61 6 months ago
9.1.0-beta.113 57 6 months ago
9.1.0-beta.112 56 6 months ago
9.1.0-beta.110 65 6 months ago
9.1.0-beta.109 61 6 months ago
9.0.1-beta.108 69 6 months ago
9.0.1-beta.107 62 6 months ago
9.0.1-beta.106 59 6 months ago
9.0.1-beta.104 60 6 months ago
9.0.1-beta.102 60 7 months ago
9.0.1-beta.99 62 7 months ago
9.0.1-beta.98 58 7 months ago
9.0.1-beta.95 62 7 months ago
9.0.1-beta.94 60 7 months ago
9.0.1-beta.93 56 7 months ago
9.0.1-beta.92 156 7 months ago
9.0.1-beta.91 56 7 months ago
9.0.1-beta.90 59 7 months ago
9.0.1-beta.89 64 7 months ago
9.0.1-beta.88 58 7 months ago
9.0.1-beta.87 54 7 months ago
9.0.1-beta.86 62 7 months ago
9.0.1-beta.84 65 7 months ago
9.0.1-beta.83 63 7 months ago
9.0.1-beta.82 64 7 months ago
9.0.1-beta.81 54 7 months ago
9.0.1-beta.80 48 7 months ago
9.0.1-beta.79 55 7 months ago
9.0.1-beta.77 56 7 months ago
9.0.0 664 7 months ago
9.0.0-beta.76 59 7 months ago
9.0.0-beta.75 57 7 months ago
9.0.0-beta.74 58 7 months ago
9.0.0-beta.73 186 7 months ago
9.0.0-beta.72 55 7 months ago
9.0.0-beta.71 58 7 months ago
9.0.0-beta.70 113 7 months ago
9.0.0-beta.69 63 7 months ago
9.0.0-beta.68 63 7 months ago
9.0.0-beta.67 56 7 months ago
9.0.0-beta.66 97 7 months ago
9.0.0-beta.63 68 7 months ago