DbHelper.cs 497 B

12345678910111213141516
  1. using Npgsql;
  2. public static class Db
  3. {
  4. static string CS =>
  5. $"Host={Env("DB_HOST","localhost")};" +
  6. $"Port={Env("DB_PORT","5434")};" +
  7. $"Database={Env("DB_NAME","arseniyborisov")};" +
  8. $"Username={Env("DB_USER","postgres")};" +
  9. $"Password={Env("DB_PASSWORD","123")}";
  10. static string Env(string key, string def) =>
  11. System.Environment.GetEnvironmentVariable(key) ?? def;
  12. public static NpgsqlConnection Conn() => new NpgsqlConnection(CS);
  13. }