public NpgsqlConnection CreateConnection(RoutingInfo routingInfo) { var cb = new NpgsqlConnectionStringBuilder(connectionString) { Enlist = true, PersistSecurityInfo = true, }; return(new NpgsqlConnection(cb.ToString())); }
public NpgsqlConnection CreateConnection(RoutingInfo routingInfo) { var cb = new NpgsqlConnectionStringBuilder(templateConnString) { Host = routingInfo.Host, Port = routingInfo.Port, Enlist = true, PersistSecurityInfo = true, }; return(new NpgsqlConnection(cb.ToString())); }
private async Task <NpgsqlConnection> GetOrCreateOpenedConnection(RoutingInfo routingInfo) { var init = StorageInitialization.Current; if (connections.TryGetValue(routingInfo.HostAndPort, out NpgsqlConnection connection)) { await init.EnsureStorageIsReadyAsync(connection, schema, routingInfo.Partition).ConfigureAwait(false); return(connection); } connection = connectionFactory.CreateConnection(routingInfo); await init.EnsureStorageIsReadyAsync(connection, schema, routingInfo.Partition).ConfigureAwait(false); await connection.OpenAsync().ConfigureAwait(false); connections.TryAdd(routingInfo.HostAndPort, connection); return(connection); }