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; } }