SqlServerDatabaseContext.cs

Go to the documentation of this file.

using System;
 
using Microsoft.EntityFrameworkCore;
 
using Tgstation.Server.Host.Configuration;
 
namespace Tgstation.Server.Host.Database
{
    sealed class SqlServerDatabaseContext : DatabaseContext
    {
        public SqlServerDatabaseContext(DbContextOptions<SqlServerDatabaseContext> dbContextOptions)
            : base(dbContextOptions)
        {
        }
 
        public static void ConfigureWith(DbContextOptionsBuilder options, DatabaseConfiguration databaseConfiguration)
        {
            ArgumentNullException.ThrowIfNull(options);
            ArgumentNullException.ThrowIfNull(databaseConfiguration);
 
            if (databaseConfiguration.DatabaseType != DatabaseType.SqlServer)
                throw new InvalidOperationException($"Invalid DatabaseType for {nameof(SqlServerDatabaseContext)}!");
 
            options.UseSqlServer(
                databaseConfiguration.ConnectionString,
                sqlServerOptions =>
                {
                    sqlServerOptions.EnableRetryOnFailure();
                    sqlServerOptions.UseQuerySplittingBehavior(QuerySplittingBehavior.SingleQuery);
                });
        }
    }
}