public static string SqlGetDate(HouseholdConfiguration configuration)
{
if (!Enum.TryParse <DatabaseSystem>(configuration.DataBaseSystem, out var databaseSystem))
{
return(null);
}
return(databaseSystem switch
{
DatabaseSystem.MSSQL => "getdate()",
DatabaseSystem.PostgreSQL => "(now() at time zone 'utc')",
_ => null
});
public HouseholdDbContext(
DbContextOptions <HouseholdDbContext> options,
IOptions <OperationalStoreOptions> operationalStoreOptions,
HouseholdConfiguration configuration,
ILogger <HouseholdDbContext> logger)
: base(options, operationalStoreOptions)
{
this.configuration = configuration;
this.logger = logger;
// ReSharper disable once VirtualMemberCallInConstructor
Database.EnsureCreated();
}
public static void DefineSqlServer(DbContextOptionsBuilder options, HouseholdConfiguration configuration)
{
if (!Enum.TryParse <DatabaseSystem>(configuration.DataBaseSystem, out var databaseSystem))
{
return;
}
switch (databaseSystem)
{
case DatabaseSystem.MSSQL:
//options.UseSqlServer(configuration.ConnectionString);
break;
case DatabaseSystem.PostgreSQL:
options.UseNpgsql(configuration.ConnectionString);
break;
}
}
