SqlServerBuilderExtensions.WithCreationScript Method

Definition

Defines the SQL script used to create the database.

public static Aspire.Hosting.ApplicationModel.IResourceBuilder<Aspire.Hosting.ApplicationModel.SqlServerDatabaseResource> WithCreationScript(this Aspire.Hosting.ApplicationModel.IResourceBuilder<Aspire.Hosting.ApplicationModel.SqlServerDatabaseResource> builder, string script);
static member WithCreationScript : Aspire.Hosting.ApplicationModel.IResourceBuilder<Aspire.Hosting.ApplicationModel.SqlServerDatabaseResource> * string -> Aspire.Hosting.ApplicationModel.IResourceBuilder<Aspire.Hosting.ApplicationModel.SqlServerDatabaseResource>
<Extension()>
Public Function WithCreationScript (builder As IResourceBuilder(Of SqlServerDatabaseResource), script As String) As IResourceBuilder(Of SqlServerDatabaseResource)

Parameters

script
String

The SQL script used to create the database.

Returns

A reference to the IResourceBuilder<T>.

Remarks

Default script is IF ( NOT EXISTS ( SELECT 1 FROM sys.databases WHERE name = @DatabaseName ) ) CREATE DATABASE [<QUOTED_DATABASE_NAME%gt;];

Applies to