private void AddToQueryCollection(string name, PgQuery query) { var savedQuery = SavedQueries; if (savedQuery == null) { savedQuery = new Dictionary <string, PgQuery>(); } savedQuery.Add(name, query); SavedQueries = savedQuery; }
protected override async Task ProcessRecordAsync() { try { var query = new PgQuery(Text); if (Query != null) { query = SavedQueries[Query]; } else if (File != null) { query = new PgQuery(File, System.Text.Encoding.UTF8); } var paramDict = query .GetQueryParameters() .Select(p => new { Key = p, Value = null as string }) .ToDictionary(pair => pair.Key, pair => pair.Value); if (Parameters != null) { foreach (DictionaryEntry inputParams in Parameters) { paramDict[inputParams.Key.ToString()] = inputParams.Value.ToString(); } } // WriteObject(p); var table = await query.Invoke(CurrentConnection, paramDict); WriteObject(table); } catch (Exception e) { WriteObject(e); } }