# SqlProjectBuilderExtensions

- Kind: `class`
- Package: [CommunityToolkit.Aspire.Hosting.SqlDatabaseProjects](/reference/api/csharp/communitytoolkit.aspire.hosting.sqldatabaseprojects.md)
- Version: `13.4.0`
- Namespace: `Aspire.Hosting`
- Target framework: `net10.0`
- Source: [GitHub](https://github.com/CommunityToolkit/Aspire/blob/d9dc6fc02412d7398c5722840513d99965a6e98f/src/CommunityToolkit.Aspire.Hosting.SqlDatabaseProjects/SqlProjectBuilderExtensions.cs)

Provides extension methods for adding SQL Server Database Projects to the application.

## Definition

```csharp
namespace Aspire.Hosting;

public static class SqlProjectBuilderExtensions
{
    // ...
}
```

## Methods

- [AddSqlPackage(IDistributedApplicationBuilder, string)](/reference/api/csharp/communitytoolkit.aspire.hosting.sqldatabaseprojects/sqlprojectbuilderextensions/methods.md#addsqlpackage-idistributedapplicationbuilder-string) : `IResourceBuilder<SqlPackageResource<TPackage>>` `extension` `ats ignored` -- Adds a SQL Server Database Project resource to the application based on a referenced NuGet package.
- [AddSqlProject(IDistributedApplicationBuilder, string)](/reference/api/csharp/communitytoolkit.aspire.hosting.sqldatabaseprojects/sqlprojectbuilderextensions/methods.md#addsqlproject-idistributedapplicationbuilder-string) : `IResourceBuilder<SqlProjectResource>` `extension` `ats ignored` -- Adds a SQL Server Database Project resource to the application based on a referenced MSBuild.Sdk.SqlProj project.
- [AddSqlProject(IDistributedApplicationBuilder, string)](/reference/api/csharp/communitytoolkit.aspire.hosting.sqldatabaseprojects/sqlprojectbuilderextensions/methods.md#addsqlproject-idistributedapplicationbuilder-string) : `IResourceBuilder<SqlProjectResource>` `extension` `ats export` -- Adds a SQL Server Database Project resource to the application.
- [WithConfigureDacDeployOptions(IResourceBuilder<SqlProjectResource>, Action<DacDeployOptions>)](/reference/api/csharp/communitytoolkit.aspire.hosting.sqldatabaseprojects/sqlprojectbuilderextensions/methods.md#withconfiguredacdeployoptions-iresourcebuilder-sqlprojectresource-action-dacdeployoptions) : `IResourceBuilder<SqlProjectResource>` `extension` `ats ignored` -- Adds a delegate annotation for configuring dacpac deployment options to the [SqlProjectResource](/reference/api/csharp/communitytoolkit.aspire.hosting.sqldatabaseprojects/sqlprojectresource.md).
- [WithConfigureDacDeployOptions(IResourceBuilder<SqlPackageResource<TPackage>>, Action<DacDeployOptions>)](/reference/api/csharp/communitytoolkit.aspire.hosting.sqldatabaseprojects/sqlprojectbuilderextensions/methods.md#withconfiguredacdeployoptions-iresourcebuilder-sqlpackageresource-tpackage-action-dacdeployoptions) : `IResourceBuilder<SqlPackageResource<TPackage>>` `extension` `ats ignored` -- Adds a delegate annotation for configuring dacpac deployment options to the [SqlProjectResource](/reference/api/csharp/communitytoolkit.aspire.hosting.sqldatabaseprojects/sqlprojectresource.md).
- [WithDacDeployOptions(IResourceBuilder<SqlProjectResource>, string)](/reference/api/csharp/communitytoolkit.aspire.hosting.sqldatabaseprojects/sqlprojectbuilderextensions/methods.md#withdacdeployoptions-iresourcebuilder-sqlprojectresource-string) : `IResourceBuilder<SqlProjectResource>` `extension` `ats export` -- Adds a path to a publish profile for configuring dacpac deployment options to the [SqlProjectResource](/reference/api/csharp/communitytoolkit.aspire.hosting.sqldatabaseprojects/sqlprojectresource.md).
- [WithDacDeployOptions(IResourceBuilder<SqlPackageResource<TPackage>>, string)](/reference/api/csharp/communitytoolkit.aspire.hosting.sqldatabaseprojects/sqlprojectbuilderextensions/methods.md#withdacdeployoptions-iresourcebuilder-sqlpackageresource-tpackage-string) : `IResourceBuilder<SqlPackageResource<TPackage>>` `extension` `ats ignored` -- Adds a path to a publish profile for configuring dacpac deployment options to the [SqlProjectResource](/reference/api/csharp/communitytoolkit.aspire.hosting.sqldatabaseprojects/sqlprojectresource.md).
- [WithDacpac(IResourceBuilder<SqlProjectResource>, string)](/reference/api/csharp/communitytoolkit.aspire.hosting.sqldatabaseprojects/sqlprojectbuilderextensions/methods.md#withdacpac-iresourcebuilder-sqlprojectresource-string) : `IResourceBuilder<SqlProjectResource>` `extension` `ats export` -- Specifies the path to the .dacpac file.
- [WithDacpac(IResourceBuilder<SqlPackageResource<TPackage>>, string)](/reference/api/csharp/communitytoolkit.aspire.hosting.sqldatabaseprojects/sqlprojectbuilderextensions/methods.md#withdacpac-iresourcebuilder-sqlpackageresource-tpackage-string) : `IResourceBuilder<SqlPackageResource<TPackage>>` `extension` `ats ignored` -- Specifies the path to the .dacpac file.
- [WithReference(IResourceBuilder<SqlProjectResource>, IResourceBuilder<SqlServerDatabaseResource>)](/reference/api/csharp/communitytoolkit.aspire.hosting.sqldatabaseprojects/sqlprojectbuilderextensions/methods.md#withreference-iresourcebuilder-sqlprojectresource-iresourcebuilder-sqlserverdatabaseresource) : `IResourceBuilder<SqlProjectResource>` `extension` `ats export` -- Publishes the SQL Server Database project to the target `ApplicationModel.SqlServerDatabaseResource`.
- [WithReference(IResourceBuilder<SqlProjectResource>, IResourceBuilder<IResourceWithConnectionString>)](/reference/api/csharp/communitytoolkit.aspire.hosting.sqldatabaseprojects/sqlprojectbuilderextensions/methods.md#withreference-iresourcebuilder-sqlprojectresource-iresourcebuilder-iresourcewithconnectionstring) : `IResourceBuilder<SqlProjectResource>` `extension` `ats export` -- Publishes the SQL Server Database project to the target `ApplicationModel.IResourceWithConnectionString`.
- [WithReference(IResourceBuilder<SqlPackageResource<TPackage>>, IResourceBuilder<SqlServerDatabaseResource>)](/reference/api/csharp/communitytoolkit.aspire.hosting.sqldatabaseprojects/sqlprojectbuilderextensions/methods.md#withreference-iresourcebuilder-sqlpackageresource-tpackage-iresourcebuilder-sqlserverdatabaseresource) : `IResourceBuilder<SqlPackageResource<TPackage>>` `extension` `ats ignored` -- Publishes the SQL Server Database project to the target `ApplicationModel.SqlServerDatabaseResource`.
- [WithReference(IResourceBuilder<SqlPackageResource<TPackage>>, IResourceBuilder<IResourceWithConnectionString>)](/reference/api/csharp/communitytoolkit.aspire.hosting.sqldatabaseprojects/sqlprojectbuilderextensions/methods.md#withreference-iresourcebuilder-sqlpackageresource-tpackage-iresourcebuilder-iresourcewithconnectionstring) : `IResourceBuilder<SqlPackageResource<TPackage>>` `extension` `ats ignored` -- Publishes the SQL Server Database project to the target `ApplicationModel.IResourceWithConnectionString`.
- [WithSkipWhenDeployed(IResourceBuilder<SqlProjectResource>)](/reference/api/csharp/communitytoolkit.aspire.hosting.sqldatabaseprojects/sqlprojectbuilderextensions/methods.md#withskipwhendeployed-iresourcebuilder-sqlprojectresource) : `IResourceBuilder<SqlProjectResource>` `extension` `ats export` -- Specifies that .dacpac deployment should be skipped if metadata in the target database indicates that the .dacpac has already been deployed in its current state.
- [WithSkipWhenDeployed(IResourceBuilder<SqlPackageResource<TPackage>>)](/reference/api/csharp/communitytoolkit.aspire.hosting.sqldatabaseprojects/sqlprojectbuilderextensions/methods.md#withskipwhendeployed-iresourcebuilder-sqlpackageresource-tpackage) : `IResourceBuilder<SqlPackageResource<TPackage>>` `extension` `ats ignored` -- Specifies that .dacpac deployment should be skipped if metadata in the target database indicates that the .dacpac has already been deployed in its current state.