public async Task CreateDb_WithAllParams_Ok() { IDbProvider dbProvider = null; var random = new Random(); var dbName = $"temp_{random.Next(100)}"; try { var options = new PostgreDbProviderOptions( String.Format(ConfigProvider.GetConfig().ConnectionStringMask, dbName), template: "template0", connectionLimit: 10, lcCollate: "C", lcCtype: "C", databaseEncoding: "SQL_ASCII"); dbProvider = new PostgreDbProvider(options); await dbProvider.CreateDatabaseIfNotExistsAsync(); } finally { if (dbProvider != null) { try { await dbProvider.OpenConnectionAsync(); await dbProvider.ExecuteScriptAsync($"DROP TABLE IF EXISTS {dbName}"); await dbProvider.CloseConnectionAsync(); } catch (Exception) { // ignored } } } }