# SqlServerBuilderExtensions

- Kind: `class`
- Package: [Aspire.Hosting.SqlServer](/reference/api/csharp/aspire.hosting.sqlserver.md)
- Version: `13.4.0`
- Namespace: `Aspire.Hosting`
- Target framework: `net10.0`
- Source: [GitHub](https://github.com/microsoft/aspire/blob/cbc352350f1a9bafbaff10d14a2c8de4ac186a48/artifacts/obj/Aspire.Hosting.SqlServer/Release/net10.0/System.Text.RegularExpressions.Generator/System.Text.RegularExpressions.Generator.RegexGenerator/RegexGenerator.g.cs)

Provides extension methods for adding SQL Server resources to the application model.

## Definition

```csharp
namespace Aspire.Hosting;

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

## Methods

- [AddDatabase(IResourceBuilder<SqlServerServerResource>, string, string?)](/reference/api/csharp/aspire.hosting.sqlserver/sqlserverbuilderextensions/methods.md#adddatabase-iresourcebuilder-sqlserverserverresource-string-string) : `IResourceBuilder<SqlServerDatabaseResource>` `extension` `ats export` -- Adds a SQL Server database to the application model. This is a child resource of a [SqlServerServerResource](/reference/api/csharp/aspire.hosting.sqlserver/sqlserverserverresource.md).
- [AddSqlServer(IDistributedApplicationBuilder, string, IResourceBuilder<ParameterResource>, int?)](/reference/api/csharp/aspire.hosting.sqlserver/sqlserverbuilderextensions/methods.md#addsqlserver-idistributedapplicationbuilder-string-iresourcebuilder-parameterresource-int) : `IResourceBuilder<SqlServerServerResource>` `extension` `ats export` -- Adds a SQL Server resource to the application model. A container is used for local development.
- [WithCreationScript(IResourceBuilder<SqlServerDatabaseResource>, string)](/reference/api/csharp/aspire.hosting.sqlserver/sqlserverbuilderextensions/methods.md#withcreationscript-iresourcebuilder-sqlserverdatabaseresource-string) : `IResourceBuilder<SqlServerDatabaseResource>` `extension` `ats export` -- Defines the SQL script used to create the database.
- [WithDataBindMount(IResourceBuilder<SqlServerServerResource>, string, bool)](/reference/api/csharp/aspire.hosting.sqlserver/sqlserverbuilderextensions/methods.md#withdatabindmount-iresourcebuilder-sqlserverserverresource-string-bool) : `IResourceBuilder<SqlServerServerResource>` `extension` `ats export` -- Adds a bind mount for the data folder to a SQL Server resource.
- [WithDataVolume(IResourceBuilder<SqlServerServerResource>, string?, bool)](/reference/api/csharp/aspire.hosting.sqlserver/sqlserverbuilderextensions/methods.md#withdatavolume-iresourcebuilder-sqlserverserverresource-string-bool) : `IResourceBuilder<SqlServerServerResource>` `extension` `ats export` -- Adds a named volume for the data folder to a SQL Server resource.
- [WithHostPort(IResourceBuilder<SqlServerServerResource>, int?)](/reference/api/csharp/aspire.hosting.sqlserver/sqlserverbuilderextensions/methods.md#withhostport-iresourcebuilder-sqlserverserverresource-int) : `IResourceBuilder<SqlServerServerResource>` `extension` `ats export` -- Configures the host port that the SqlServer resource is exposed on instead of using randomly assigned port.
- [WithPassword(IResourceBuilder<SqlServerServerResource>, IResourceBuilder<ParameterResource>)](/reference/api/csharp/aspire.hosting.sqlserver/sqlserverbuilderextensions/methods.md#withpassword-iresourcebuilder-sqlserverserverresource-iresourcebuilder-parameterresource) : `IResourceBuilder<SqlServerServerResource>` `extension` `ats export` -- Configures the password that the SqlServer resource is used.