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

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.311
                    
NuGet\Install-Package CommunityToolkit.Aspire.Hosting.SqlDatabaseProjects -Version 9.5.1-beta.311
                    
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.311" />
                    
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.311" />
                    
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.311
                    
#r "nuget: CommunityToolkit.Aspire.Hosting.SqlDatabaseProjects, 9.5.1-beta.311"
                    
#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.311&prerelease
                    
Install as a Cake Addin
#tool nuget:?package=CommunityToolkit.Aspire.Hosting.SqlDatabaseProjects&version=9.5.1-beta.311&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.6.0 132 2 days ago
9.6.0-beta.324 99 3 days ago
9.5.1-beta.323 100 3 days ago
9.5.1-beta.322 106 3 days ago
9.5.1-beta.321 104 3 days ago
9.5.1-beta.320 105 4 days ago
9.5.1-beta.319 107 5 days ago
9.5.1-beta.318 109 11 days ago
9.5.1-beta.317 103 13 days ago
9.5.1-beta.315 109 17 days ago
9.5.1-beta.314 111 20 days ago
9.5.1-beta.313 99 23 days ago
9.5.1-beta.312 102 23 days ago
9.5.1-beta.311 111 25 days ago
9.5.1-beta.310 111 a month ago
9.5.1-beta.309 105 a month ago
9.5.1-beta.308 113 a month ago
9.5.1-beta.307 112 a month ago
9.5.1-beta.306 261 a month ago
9.5.1-beta.305 92 a month ago
9.5.1-beta.304 99 a month ago
9.5.1-beta.303 125 a month ago
9.5.1-beta.302 114 a month ago
9.5.1-beta.301 118 a month ago
9.5.1-beta.300 122 a month ago
9.5.0 2,353 2 months ago
9.5.0-beta.299 115 2 months ago
9.5.0-beta.298 127 2 months ago
9.5.0-beta.297 72 2 months ago
9.5.0-beta.296 67 2 months ago
9.5.0-beta.295 48 2 months ago
9.4.1-beta.291 117 2 months ago
9.4.1-beta.289 133 2 months ago
9.4.1-beta.288 181 2 months ago
9.4.1-beta.287 178 2 months ago
9.4.1-beta.286 184 2 months ago
9.4.1-beta.285 194 2 months ago
9.4.1-beta.284 198 2 months ago
9.4.1-beta.283 203 2 months ago
9.4.1-beta.282 120 2 months ago
9.4.1-beta.280 124 2 months ago
9.4.1-beta.279 118 2 months ago
9.4.1-beta.277 128 3 months ago
9.4.1-beta.276 129 3 months ago
9.4.1-beta.275 132 3 months ago
9.4.1-beta.274 133 3 months ago
9.4.1-beta.273 125 3 months ago
9.4.1-beta.272 131 3 months ago
9.4.1-beta.271 125 3 months ago
9.4.1-beta.270 134 3 months ago
9.4.0 2,846 3 months ago
9.4.0-beta.269 131 3 months ago
9.4.0-beta.268 124 3 months ago
9.3.1-beta.267 129 3 months ago
9.3.1-beta.266 60 3 months ago
9.3.1-beta.265 265 3 months ago
9.3.1-beta.264 156 3 months ago
9.3.1-beta.263 161 3 months ago
9.3.1-beta.262 164 3 months ago
9.3.1-beta.260 142 3 months ago
9.3.1-beta.259 1,029 3 months ago
9.3.1-beta.258 137 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 129 3 months ago
9.3.1-beta.254 132 3 months ago
9.3.1-beta.253 141 3 months ago
9.3.1-beta.252 377 4 months ago
9.3.1-beta.250 106 4 months ago
9.3.1-beta.249 105 4 months ago
9.3.1-beta.248 107 4 months ago
9.3.1-beta.247 113 4 months ago
9.3.1-beta.244 454 4 months ago
9.3.1-beta.242 449 4 months ago
9.3.1-beta.241 131 4 months ago
9.3.0 4,859 4 months ago
9.3.0-beta.239 118 4 months ago
9.2.2-beta.237 127 4 months ago
9.2.2-beta.236 97 4 months ago
9.2.2-beta.230 133 4 months ago
9.2.2-beta.229 125 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 124 4 months ago
9.2.2-beta.224 128 4 months ago
9.2.2-beta.223 141 4 months ago
9.2.2-beta.222 143 4 months ago
9.2.2-beta.220 134 4 months ago
9.2.2-beta.218 134 4 months ago
9.2.2-beta.217 180 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 172 4 months ago
9.2.2-beta.213 168 4 months ago
9.2.2-beta.212 166 4 months ago
9.2.2-beta.211 175 4 months ago
9.2.2-beta.210 173 4 months ago
9.2.2-beta.208 72 4 months ago
9.2.1 1,416 4 months ago
9.2.1-beta.207 106 4 months ago
9.2.1-beta.206 65 4 months ago
9.2.1-beta.205 67 5 months ago
9.2.1-beta.204 71 5 months ago
9.2.1-beta.203 63 5 months ago
9.2.0 834 5 months ago
9.2.0-beta.202 65 5 months ago
9.2.0-beta.201 82 5 months ago
9.2.0-beta.199 63 5 months ago
9.2.0-beta.198 56 5 months ago
9.1.1-beta.197 80 5 months ago
9.1.1-beta.196 65 5 months ago
9.1.1-beta.195 69 5 months ago
9.1.1-beta.194 65 5 months ago
9.1.1-beta.193 62 5 months ago
9.1.1-beta.192 69 5 months ago
9.1.1-beta.191 78 5 months ago
9.1.1-beta.190 71 5 months ago
9.1.1-beta.189 73 5 months ago
9.1.1-beta.188 69 5 months ago
9.1.1-beta.187 74 5 months ago
9.1.1-beta.183 83 5 months ago
9.1.1-beta.182 72 5 months ago
9.1.1-beta.181 89 5 months ago
9.1.1-beta.180 72 5 months ago
9.1.1-beta.178 69 5 months ago
9.1.1-beta.177 85 5 months ago
9.1.1-beta.176 89 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 73 5 months ago
9.1.1-beta.168 63 5 months ago
9.1.1-beta.166 130 5 months ago
9.1.1-beta.165 59 5 months ago
9.1.1-beta.164 70 5 months ago
9.1.1-beta.162 63 5 months ago
9.1.1-beta.155 65 5 months ago
9.1.1-beta.154 74 5 months ago
9.1.1-beta.153 59 5 months ago
9.1.1-beta.152 59 5 months ago
9.1.1-beta.150 72 5 months ago
9.1.1-beta.148 74 6 months ago
9.1.1-beta.147 64 6 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 61 6 months ago
9.1.1-beta.142 65 6 months ago
9.1.1-beta.140 58 6 months ago
9.1.1-beta.139 67 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 59 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 52 6 months ago
9.1.1-beta.127 45 6 months ago
9.1.1-beta.126 57 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,784 7 months ago
9.1.0-beta.123 73 6 months ago
9.1.0-beta.122 80 6 months ago
9.1.0-beta.121 65 6 months ago
9.1.0-beta.120 68 6 months ago
9.1.0-beta.119 62 6 months ago
9.1.0-beta.118 66 6 months ago
9.1.0-beta.116 69 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 62 7 months ago
9.1.0-beta.110 72 7 months ago
9.1.0-beta.109 67 7 months ago
9.0.1-beta.108 80 7 months ago
9.0.1-beta.107 68 7 months ago
9.0.1-beta.106 67 7 months ago
9.0.1-beta.104 67 7 months ago
9.0.1-beta.102 65 7 months ago
9.0.1-beta.99 69 7 months ago
9.0.1-beta.98 62 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 162 7 months ago
9.0.1-beta.91 67 7 months ago
9.0.1-beta.90 67 7 months ago
9.0.1-beta.89 73 7 months ago
9.0.1-beta.88 67 7 months ago
9.0.1-beta.87 63 7 months ago
9.0.1-beta.86 69 8 months ago
9.0.1-beta.84 75 8 months ago
9.0.1-beta.83 69 8 months ago
9.0.1-beta.82 73 8 months ago
9.0.1-beta.81 63 8 months ago
9.0.1-beta.80 56 8 months ago
9.0.1-beta.79 68 8 months ago
9.0.1-beta.77 66 8 months ago
9.0.0 668 8 months ago
9.0.0-beta.76 67 8 months ago
9.0.0-beta.75 69 8 months ago
9.0.0-beta.74 66 8 months ago
9.0.0-beta.73 191 8 months ago
9.0.0-beta.72 58 8 months ago
9.0.0-beta.71 64 8 months ago
9.0.0-beta.70 123 8 months ago
9.0.0-beta.69 73 8 months ago
9.0.0-beta.68 71 8 months ago
9.0.0-beta.67 60 8 months ago
9.0.0-beta.66 105 8 months ago
9.0.0-beta.63 73 8 months ago