SqlServerDbContextFactory.cs

using Microsoft.EntityFrameworkCore;

namespace Ploch.Data.EFCore.SqlServer;

/// <summary>
///     Represents a factory for creating instances of TDbContext configured to use SQL Server as the database provider.
///     This abstract class provides methods to configure the DbContext using a connection string and optional additional
///     SQL Server-specific configuration.
/// </summary>
/// <inheritdoc />
public abstract class SqlServerDbContextFactory<TDbContext, TFactory> : BaseDbContextFactory<TDbContext, TFactory>
    where TDbContext : DbContext where TFactory : BaseDbContextFactory<TDbContext, TFactory>
{
    /// <summary>
    ///     Initializes a new instance of the <see cref="SqlServerDbContextFactory{TDbContext, TFactory}" /> class.
    /// </summary>
    /// <param name="dbContextCreator">Function to create an instance of DbContext.</param>
    protected SqlServerDbContextFactory(Func<DbContextOptions<TDbContext>, TDbContext> dbContextCreator) : base(dbContextCreator)
    { }

    /// <summary>
    ///     Initializes a new instance of the <see cref="SqlServerDbContextFactory{TDbContext, TMigrationAssembly}" />
    ///     class.
    /// </summary>
    /// <param name="dbContextCreator">Function to create an instance of DbContext.</param>
    /// <param name="connectionStringFunc">Function to return the connection string.</param>
    protected SqlServerDbContextFactory(Func<DbContextOptions<TDbContext>, TDbContext> dbContextCreator, Func<string> connectionStringFunc) :
        base(dbContextCreator, connectionStringFunc)
    { }

    /// <summary>
    ///     Configures the options for the DbContext using the provided connection string function.
    /// </summary>
    /// <param name="connectionStringFunc">Function to retrieve the database connection string.</param>
    /// <param name="optionsBuilder">The options builder to be configured.</param>
    /// <returns>The configured DbContextOptionsBuilder.</returns>
    protected override DbContextOptionsBuilder<TDbContext> ConfigureOptions(Func<string> connectionStringFunc,
                                                                            DbContextOptionsBuilder<TDbContext> optionsBuilder)
    {
        // Correctly configure SQL Server provider for design-time and runtime
        optionsBuilder.UseSqlServer(connectionStringFunc(), ApplyMigrationsAssembly);

        return optionsBuilder;
    }
}