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

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