CommunityToolkit.Aspire.Hosting.SqlDatabaseProjects 9.5.0-beta.295

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.0-beta.295
                    
NuGet\Install-Package CommunityToolkit.Aspire.Hosting.SqlDatabaseProjects -Version 9.5.0-beta.295
                    
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-beta.295" />
                    
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-beta.295" />
                    
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-beta.295
                    
#r "nuget: CommunityToolkit.Aspire.Hosting.SqlDatabaseProjects, 9.5.0-beta.295"
                    
#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-beta.295&prerelease
                    
Install CommunityToolkit.Aspire.Hosting.SqlDatabaseProjects as a Cake Addin
#tool nuget:?package=CommunityToolkit.Aspire.Hosting.SqlDatabaseProjects&version=9.5.0-beta.295&prerelease
                    
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.301 23 16 hours ago
9.5.1-beta.300 115 5 days ago
9.5.0 280 7 days ago
9.5.0-beta.299 107 7 days ago
9.5.0-beta.298 111 8 days ago
9.5.0-beta.297 65 9 days ago
9.5.0-beta.296 61 9 days ago
9.5.0-beta.295 36 9 days ago
9.4.1-beta.291 110 14 days ago
9.4.1-beta.289 119 17 days ago
9.4.1-beta.288 174 18 days ago
9.4.1-beta.287 169 18 days ago
9.4.1-beta.286 169 18 days ago
9.4.1-beta.285 189 19 days ago
9.4.1-beta.284 191 21 days ago
9.4.1-beta.283 198 21 days ago
9.4.1-beta.282 112 a month ago
9.4.1-beta.280 112 a month ago
9.4.1-beta.279 107 a month ago
9.4.1-beta.277 124 a month ago
9.4.1-beta.276 120 a month ago
9.4.1-beta.275 124 a month ago
9.4.1-beta.274 124 a month ago
9.4.1-beta.273 117 a month ago
9.4.1-beta.272 122 a month ago
9.4.1-beta.271 118 a month ago
9.4.1-beta.270 124 a month ago
9.4.0 1,735 a month ago
9.4.0-beta.269 126 a month ago
9.4.0-beta.268 119 a month ago
9.3.1-beta.267 123 a month ago
9.3.1-beta.266 53 a month ago
9.3.1-beta.265 244 2 months ago
9.3.1-beta.264 151 2 months ago
9.3.1-beta.263 149 2 months ago
9.3.1-beta.262 153 2 months ago
9.3.1-beta.260 135 2 months ago
9.3.1-beta.259 666 2 months ago
9.3.1-beta.258 120 2 months ago
9.3.1-beta.257 121 2 months ago
9.3.1-beta.256 122 2 months ago
9.3.1-beta.255 123 2 months ago
9.3.1-beta.254 122 2 months ago
9.3.1-beta.253 129 2 months ago
9.3.1-beta.252 369 2 months ago
9.3.1-beta.250 100 2 months ago
9.3.1-beta.249 97 2 months ago
9.3.1-beta.248 101 2 months ago
9.3.1-beta.247 105 2 months ago
9.3.1-beta.244 446 2 months ago
9.3.1-beta.242 442 2 months ago
9.3.1-beta.241 122 2 months ago
9.3.0 3,368 2 months ago
9.3.0-beta.239 113 2 months ago
9.2.2-beta.237 114 2 months ago
9.2.2-beta.236 87 3 months ago
9.2.2-beta.230 119 3 months ago
9.2.2-beta.229 111 3 months ago
9.2.2-beta.228 135 3 months ago
9.2.2-beta.227 119 3 months ago
9.2.2-beta.226 128 3 months ago
9.2.2-beta.225 116 3 months ago
9.2.2-beta.224 121 3 months ago
9.2.2-beta.223 130 3 months ago
9.2.2-beta.222 135 3 months ago
9.2.2-beta.220 124 3 months ago
9.2.2-beta.218 126 3 months ago
9.2.2-beta.217 170 3 months ago
9.2.2-beta.216 168 3 months ago
9.2.2-beta.215 169 3 months ago
9.2.2-beta.214 166 3 months ago
9.2.2-beta.213 161 3 months ago
9.2.2-beta.212 160 3 months ago
9.2.2-beta.211 168 3 months ago
9.2.2-beta.210 163 3 months ago
9.2.2-beta.208 65 3 months ago
9.2.1 1,395 3 months ago
9.2.1-beta.207 96 3 months ago
9.2.1-beta.206 57 3 months ago
9.2.1-beta.205 60 3 months ago
9.2.1-beta.204 59 3 months ago
9.2.1-beta.203 54 3 months ago
9.2.0 809 3 months ago
9.2.0-beta.202 57 3 months ago
9.2.0-beta.201 59 3 months ago
9.2.0-beta.199 53 3 months ago
9.2.0-beta.198 48 3 months ago
9.1.1-beta.197 70 3 months ago
9.1.1-beta.196 55 3 months ago
9.1.1-beta.195 57 3 months ago
9.1.1-beta.194 55 3 months ago
9.1.1-beta.193 52 3 months ago
9.1.1-beta.192 59 3 months ago
9.1.1-beta.191 68 3 months ago
9.1.1-beta.190 64 3 months ago
9.1.1-beta.189 61 3 months ago
9.1.1-beta.188 63 3 months ago
9.1.1-beta.187 67 3 months ago
9.1.1-beta.183 71 4 months ago
9.1.1-beta.182 69 4 months ago
9.1.1-beta.181 76 4 months ago
9.1.1-beta.180 63 4 months ago
9.1.1-beta.178 56 4 months ago
9.1.1-beta.177 74 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 62 4 months ago
9.1.1-beta.168 57 4 months ago
9.1.1-beta.166 115 4 months ago
9.1.1-beta.165 52 4 months ago
9.1.1-beta.164 64 4 months ago
9.1.1-beta.162 59 4 months ago
9.1.1-beta.155 58 4 months ago
9.1.1-beta.154 61 4 months ago
9.1.1-beta.153 54 4 months ago
9.1.1-beta.152 52 4 months ago
9.1.1-beta.150 63 4 months ago
9.1.1-beta.148 65 4 months ago
9.1.1-beta.147 54 4 months ago
9.1.1-beta.146 57 4 months ago
9.1.1-beta.145 53 4 months ago
9.1.1-beta.144 52 4 months ago
9.1.1-beta.142 52 4 months ago
9.1.1-beta.140 53 4 months ago
9.1.1-beta.139 54 4 months ago
9.1.1-beta.138 50 4 months ago
9.1.1-beta.137 51 5 months ago
9.1.1-beta.136 52 5 months ago
9.1.1-beta.135 25 5 months ago
9.1.1-beta.134 24 5 months ago
9.1.1-beta.128 43 5 months ago
9.1.1-beta.127 41 5 months ago
9.1.1-beta.126 48 5 months ago
9.1.1-beta.125 56 5 months ago
9.1.1-beta.124 47 5 months ago
9.1.0 2,770 6 months ago
9.1.0-beta.123 63 5 months ago
9.1.0-beta.122 69 5 months ago
9.1.0-beta.121 59 5 months ago
9.1.0-beta.120 58 5 months ago
9.1.0-beta.119 55 5 months ago
9.1.0-beta.118 57 5 months ago
9.1.0-beta.116 58 5 months ago
9.1.0-beta.114 56 5 months ago
9.1.0-beta.113 55 5 months ago
9.1.0-beta.112 55 5 months ago
9.1.0-beta.110 62 6 months ago
9.1.0-beta.109 56 6 months ago
9.0.1-beta.108 65 6 months ago
9.0.1-beta.107 61 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 59 6 months ago
9.0.1-beta.99 61 6 months ago
9.0.1-beta.98 58 6 months ago
9.0.1-beta.95 61 6 months ago
9.0.1-beta.94 60 6 months ago
9.0.1-beta.93 56 6 months ago
9.0.1-beta.92 156 6 months ago
9.0.1-beta.91 51 6 months ago
9.0.1-beta.90 59 6 months ago
9.0.1-beta.89 61 6 months ago
9.0.1-beta.88 58 6 months ago
9.0.1-beta.87 50 6 months ago
9.0.1-beta.86 59 6 months ago
9.0.1-beta.84 62 6 months ago
9.0.1-beta.83 61 6 months ago
9.0.1-beta.82 63 6 months ago
9.0.1-beta.81 53 6 months ago
9.0.1-beta.80 46 6 months ago
9.0.1-beta.79 53 6 months ago
9.0.1-beta.77 54 7 months ago
9.0.0 655 7 months ago
9.0.0-beta.76 56 7 months ago
9.0.0-beta.75 55 7 months ago
9.0.0-beta.74 57 7 months ago
9.0.0-beta.73 185 7 months ago
9.0.0-beta.72 54 7 months ago
9.0.0-beta.71 58 7 months ago
9.0.0-beta.70 111 7 months ago
9.0.0-beta.69 62 7 months ago
9.0.0-beta.68 62 7 months ago
9.0.0-beta.67 56 7 months ago
9.0.0-beta.66 94 7 months ago
9.0.0-beta.63 67 7 months ago