SqlServerDbContextOptionsExtensions.UseAzureSql Method
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Overloads
UseAzureSql(DbContextOptionsBuilder, Action<AzureSqlDbContextOptionsBuilder>)
Configures the context to connect to a Azure SQL database, but without initially setting any DbConnection or connection string.
public static Microsoft.EntityFrameworkCore.DbContextOptionsBuilder UseAzureSql (this Microsoft.EntityFrameworkCore.DbContextOptionsBuilder optionsBuilder, Action<Microsoft.EntityFrameworkCore.Infrastructure.AzureSqlDbContextOptionsBuilder>? azureSqlOptionsAction = default);static member UseAzureSql : Microsoft.EntityFrameworkCore.DbContextOptionsBuilder * Action<Microsoft.EntityFrameworkCore.Infrastructure.AzureSqlDbContextOptionsBuilder> -> Microsoft.EntityFrameworkCore.DbContextOptionsBuilder<Extension()>
Public Function UseAzureSql (optionsBuilder As DbContextOptionsBuilder, Optional azureSqlOptionsAction As Action(Of AzureSqlDbContextOptionsBuilder) = Nothing) As DbContextOptionsBuilderParameters
- optionsBuilder
- DbContextOptionsBuilder
The builder being used to configure the context.
- azureSqlOptionsAction
- Action<AzureSqlDbContextOptionsBuilder>
An optional action to allow additional Azure SQL specific configuration.
Returns
The options builder so that further configuration can be chained.
Remarks
The connection or connection string must be set before the DbContext is used to connect to a database. Set a connection using SetDbConnection(DatabaseFacade, DbConnection, Boolean). Set a connection string using SetConnectionString(DatabaseFacade, String).
See Using DbContextOptions, and Accessing SQL Server, Azure SQL, Azure Synapse databases with EF Core for more information and examples.
Applies to
UseAzureSql(DbContextOptionsBuilder, DbConnection, Action<AzureSqlDbContextOptionsBuilder>)
Configures the context to connect to a Azure SQL database.
public static Microsoft.EntityFrameworkCore.DbContextOptionsBuilder UseAzureSql (this Microsoft.EntityFrameworkCore.DbContextOptionsBuilder optionsBuilder, System.Data.Common.DbConnection connection, Action<Microsoft.EntityFrameworkCore.Infrastructure.AzureSqlDbContextOptionsBuilder>? azureSqlOptionsAction = default);static member UseAzureSql : Microsoft.EntityFrameworkCore.DbContextOptionsBuilder * System.Data.Common.DbConnection * Action<Microsoft.EntityFrameworkCore.Infrastructure.AzureSqlDbContextOptionsBuilder> -> Microsoft.EntityFrameworkCore.DbContextOptionsBuilder<Extension()>
Public Function UseAzureSql (optionsBuilder As DbContextOptionsBuilder, connection As DbConnection, Optional azureSqlOptionsAction As Action(Of AzureSqlDbContextOptionsBuilder) = Nothing) As DbContextOptionsBuilderParameters
- optionsBuilder
- DbContextOptionsBuilder
The builder being used to configure the context.
- connection
- DbConnection
An existing DbConnection to be used to connect to the database. If the connection is in the open state then EF will not open or close the connection. If the connection is in the closed state then EF will open and close the connection as needed. The caller owns the connection and is responsible for its disposal.
- azureSqlOptionsAction
- Action<AzureSqlDbContextOptionsBuilder>
An optional action to allow additional Azure SQL specific configuration.
Returns
The options builder so that further configuration can be chained.
Remarks
See Using DbContextOptions, and Accessing SQL Server, Azure SQL, Azure Synapse databases with EF Core for more information and examples.
Applies to
UseAzureSql(DbContextOptionsBuilder, String, Action<AzureSqlDbContextOptionsBuilder>)
Configures the context to connect to a Azure SQL database.
public static Microsoft.EntityFrameworkCore.DbContextOptionsBuilder UseAzureSql (this Microsoft.EntityFrameworkCore.DbContextOptionsBuilder optionsBuilder, string? connectionString, Action<Microsoft.EntityFrameworkCore.Infrastructure.AzureSqlDbContextOptionsBuilder>? azureSqlOptionsAction = default);static member UseAzureSql : Microsoft.EntityFrameworkCore.DbContextOptionsBuilder * string * Action<Microsoft.EntityFrameworkCore.Infrastructure.AzureSqlDbContextOptionsBuilder> -> Microsoft.EntityFrameworkCore.DbContextOptionsBuilder<Extension()>
Public Function UseAzureSql (optionsBuilder As DbContextOptionsBuilder, connectionString As String, Optional azureSqlOptionsAction As Action(Of AzureSqlDbContextOptionsBuilder) = Nothing) As DbContextOptionsBuilderParameters
- optionsBuilder
- DbContextOptionsBuilder
The builder being used to configure the context.
- connectionString
- String
The connection string of the database to connect to.
- azureSqlOptionsAction
- Action<AzureSqlDbContextOptionsBuilder>
An optional action to allow additional Azure SQL specific configuration.
Returns
The options builder so that further configuration can be chained.
Remarks
See Using DbContextOptions, and Accessing SQL Server, Azure SQL, Azure Synapse databases with EF Core for more information and examples.
Applies to
UseAzureSql(DbContextOptionsBuilder, DbConnection, Boolean, Action<AzureSqlDbContextOptionsBuilder>)
Configures the context to connect to a Azure SQL database.
public static Microsoft.EntityFrameworkCore.DbContextOptionsBuilder UseAzureSql (this Microsoft.EntityFrameworkCore.DbContextOptionsBuilder optionsBuilder, System.Data.Common.DbConnection connection, bool contextOwnsConnection, Action<Microsoft.EntityFrameworkCore.Infrastructure.AzureSqlDbContextOptionsBuilder>? azureSqlOptionsAction = default);static member UseAzureSql : Microsoft.EntityFrameworkCore.DbContextOptionsBuilder * System.Data.Common.DbConnection * bool * Action<Microsoft.EntityFrameworkCore.Infrastructure.AzureSqlDbContextOptionsBuilder> -> Microsoft.EntityFrameworkCore.DbContextOptionsBuilder<Extension()>
Public Function UseAzureSql (optionsBuilder As DbContextOptionsBuilder, connection As DbConnection, contextOwnsConnection As Boolean, Optional azureSqlOptionsAction As Action(Of AzureSqlDbContextOptionsBuilder) = Nothing) As DbContextOptionsBuilderParameters
- optionsBuilder
- DbContextOptionsBuilder
The builder being used to configure the context.
- connection
- DbConnection
An existing DbConnection to be used to connect to the database. If the connection is in the open state then EF will not open or close the connection. If the connection is in the closed state then EF will open and close the connection as needed.
- contextOwnsConnection
- Boolean
If true, then EF will take ownership of the connection and will
dispose it in the same way it would dispose a connection created by EF. If false, then the caller still
owns the connection and is responsible for its disposal.
- azureSqlOptionsAction
- Action<AzureSqlDbContextOptionsBuilder>
An optional action to allow additional Azure SQL specific configuration.
Returns
The options builder so that further configuration can be chained.
Remarks
See Using DbContextOptions, and Accessing SQL Server, Azure SQL, Azure Synapse databases with EF Core for more information and examples.
Applies to
UseAzureSql<TContext>(DbContextOptionsBuilder<TContext>, Action<AzureSqlDbContextOptionsBuilder>)
Configures the context to connect to a Azure SQL database, but without initially setting any DbConnection or connection string.
public static Microsoft.EntityFrameworkCore.DbContextOptionsBuilder<TContext> UseAzureSql<TContext> (this Microsoft.EntityFrameworkCore.DbContextOptionsBuilder<TContext> optionsBuilder, Action<Microsoft.EntityFrameworkCore.Infrastructure.AzureSqlDbContextOptionsBuilder>? azureSqlOptionsAction = default) where TContext : Microsoft.EntityFrameworkCore.DbContext;static member UseAzureSql : Microsoft.EntityFrameworkCore.DbContextOptionsBuilder<'Context (requires 'Context :> Microsoft.EntityFrameworkCore.DbContext)> * Action<Microsoft.EntityFrameworkCore.Infrastructure.AzureSqlDbContextOptionsBuilder> -> Microsoft.EntityFrameworkCore.DbContextOptionsBuilder<'Context (requires 'Context :> Microsoft.EntityFrameworkCore.DbContext)> (requires 'Context :> Microsoft.EntityFrameworkCore.DbContext)<Extension()>
Public Function UseAzureSql(Of TContext As DbContext) (optionsBuilder As DbContextOptionsBuilder(Of TContext), Optional azureSqlOptionsAction As Action(Of AzureSqlDbContextOptionsBuilder) = Nothing) As DbContextOptionsBuilder(Of TContext)Type Parameters
- TContext
Parameters
- optionsBuilder
- DbContextOptionsBuilder<TContext>
The builder being used to configure the context.
- azureSqlOptionsAction
- Action<AzureSqlDbContextOptionsBuilder>
An optional action to allow additional Azure SQL specific configuration.
Returns
The options builder so that further configuration can be chained.
Remarks
The connection or connection string must be set before the DbContext is used to connect to a database. Set a connection using SetDbConnection(DatabaseFacade, DbConnection, Boolean). Set a connection string using SetConnectionString(DatabaseFacade, String).
See Using DbContextOptions, and Accessing SQL Server, Azure SQL, Azure Synapse databases with EF Core for more information and examples.
Applies to
UseAzureSql<TContext>(DbContextOptionsBuilder<TContext>, DbConnection, Action<AzureSqlDbContextOptionsBuilder>)
Configures the context to connect to a Azure SQL database.
public static Microsoft.EntityFrameworkCore.DbContextOptionsBuilder<TContext> UseAzureSql<TContext> (this Microsoft.EntityFrameworkCore.DbContextOptionsBuilder<TContext> optionsBuilder, System.Data.Common.DbConnection connection, Action<Microsoft.EntityFrameworkCore.Infrastructure.AzureSqlDbContextOptionsBuilder>? azureSqlOptionsAction = default) where TContext : Microsoft.EntityFrameworkCore.DbContext;static member UseAzureSql : Microsoft.EntityFrameworkCore.DbContextOptionsBuilder<'Context (requires 'Context :> Microsoft.EntityFrameworkCore.DbContext)> * System.Data.Common.DbConnection * Action<Microsoft.EntityFrameworkCore.Infrastructure.AzureSqlDbContextOptionsBuilder> -> Microsoft.EntityFrameworkCore.DbContextOptionsBuilder<'Context (requires 'Context :> Microsoft.EntityFrameworkCore.DbContext)> (requires 'Context :> Microsoft.EntityFrameworkCore.DbContext)<Extension()>
Public Function UseAzureSql(Of TContext As DbContext) (optionsBuilder As DbContextOptionsBuilder(Of TContext), connection As DbConnection, Optional azureSqlOptionsAction As Action(Of AzureSqlDbContextOptionsBuilder) = Nothing) As DbContextOptionsBuilder(Of TContext)Type Parameters
- TContext
The type of context to be configured.
Parameters
- optionsBuilder
- DbContextOptionsBuilder<TContext>
The builder being used to configure the context.
- connection
- DbConnection
An existing DbConnection to be used to connect to the database. If the connection is in the open state then EF will not open or close the connection. If the connection is in the closed state then EF will open and close the connection as needed. The caller owns the connection and is responsible for its disposal.
- azureSqlOptionsAction
- Action<AzureSqlDbContextOptionsBuilder>
An optional action to allow additional Azure SQL specific configuration.
Returns
The options builder so that further configuration can be chained.
Remarks
See Using DbContextOptions, and Accessing SQL Server, Azure SQL, Azure Synapse databases with EF Core for more information and examples.
Applies to
UseAzureSql<TContext>(DbContextOptionsBuilder<TContext>, String, Action<AzureSqlDbContextOptionsBuilder>)
Configures the context to connect to a Azure SQL database.
public static Microsoft.EntityFrameworkCore.DbContextOptionsBuilder<TContext> UseAzureSql<TContext> (this Microsoft.EntityFrameworkCore.DbContextOptionsBuilder<TContext> optionsBuilder, string? connectionString, Action<Microsoft.EntityFrameworkCore.Infrastructure.AzureSqlDbContextOptionsBuilder>? azureSqlOptionsAction = default) where TContext : Microsoft.EntityFrameworkCore.DbContext;static member UseAzureSql : Microsoft.EntityFrameworkCore.DbContextOptionsBuilder<'Context (requires 'Context :> Microsoft.EntityFrameworkCore.DbContext)> * string * Action<Microsoft.EntityFrameworkCore.Infrastructure.AzureSqlDbContextOptionsBuilder> -> Microsoft.EntityFrameworkCore.DbContextOptionsBuilder<'Context (requires 'Context :> Microsoft.EntityFrameworkCore.DbContext)> (requires 'Context :> Microsoft.EntityFrameworkCore.DbContext)<Extension()>
Public Function UseAzureSql(Of TContext As DbContext) (optionsBuilder As DbContextOptionsBuilder(Of TContext), connectionString As String, Optional azureSqlOptionsAction As Action(Of AzureSqlDbContextOptionsBuilder) = Nothing) As DbContextOptionsBuilder(Of TContext)Type Parameters
- TContext
The type of context to be configured.
Parameters
- optionsBuilder
- DbContextOptionsBuilder<TContext>
The builder being used to configure the context.
- connectionString
- String
The connection string of the database to connect to.
- azureSqlOptionsAction
- Action<AzureSqlDbContextOptionsBuilder>
An optional action to allow additional Azure SQL specific configuration.
Returns
The options builder so that further configuration can be chained.
Remarks
See Using DbContextOptions, and Accessing SQL Server, Azure SQL, Azure Synapse databases with EF Core for more information and examples.
Applies to
UseAzureSql<TContext>(DbContextOptionsBuilder<TContext>, DbConnection, Boolean, Action<AzureSqlDbContextOptionsBuilder>)
Configures the context to connect to a Azure SQL database.
public static Microsoft.EntityFrameworkCore.DbContextOptionsBuilder<TContext> UseAzureSql<TContext> (this Microsoft.EntityFrameworkCore.DbContextOptionsBuilder<TContext> optionsBuilder, System.Data.Common.DbConnection connection, bool contextOwnsConnection, Action<Microsoft.EntityFrameworkCore.Infrastructure.AzureSqlDbContextOptionsBuilder>? azureSqlOptionsAction = default) where TContext : Microsoft.EntityFrameworkCore.DbContext;static member UseAzureSql : Microsoft.EntityFrameworkCore.DbContextOptionsBuilder<'Context (requires 'Context :> Microsoft.EntityFrameworkCore.DbContext)> * System.Data.Common.DbConnection * bool * Action<Microsoft.EntityFrameworkCore.Infrastructure.AzureSqlDbContextOptionsBuilder> -> Microsoft.EntityFrameworkCore.DbContextOptionsBuilder<'Context (requires 'Context :> Microsoft.EntityFrameworkCore.DbContext)> (requires 'Context :> Microsoft.EntityFrameworkCore.DbContext)<Extension()>
Public Function UseAzureSql(Of TContext As DbContext) (optionsBuilder As DbContextOptionsBuilder(Of TContext), connection As DbConnection, contextOwnsConnection As Boolean, Optional azureSqlOptionsAction As Action(Of AzureSqlDbContextOptionsBuilder) = Nothing) As DbContextOptionsBuilder(Of TContext)Type Parameters
- TContext
The type of context to be configured.
Parameters
- optionsBuilder
- DbContextOptionsBuilder<TContext>
The builder being used to configure the context.
- connection
- DbConnection
An existing DbConnection to be used to connect to the database. If the connection is in the open state then EF will not open or close the connection. If the connection is in the closed state then EF will open and close the connection as needed.
- contextOwnsConnection
- Boolean
If true, then EF will take ownership of the connection and will
dispose it in the same way it would dispose a connection created by EF. If false, then the caller still
owns the connection and is responsible for its disposal.
- azureSqlOptionsAction
- Action<AzureSqlDbContextOptionsBuilder>
An optional action to allow additional Azure SQL specific configuration.
Returns
The options builder so that further configuration can be chained.
Remarks
See Using DbContextOptions, and Accessing SQL Server, Azure SQL, Azure Synapse databases with EF Core for more information and examples.
