public static List <String> ReadStrings(this H2Connection connection, String query) { var ret = new List <String>(); var reader = new H2Command(query, connection).ExecuteReader(); while (reader.Read()) { ret.Add(reader.GetString(0)); } return(ret); }
public static Dictionary <String, T> ReadMap <T>(this H2Connection connection, String query) { var ret = new Dictionary <String, T>(); var reader = new H2Command(query, connection).ExecuteReader(); while (reader.Read()) { var key = reader.GetString(0); var value = reader.GetValue(1); if (value == DBNull.Value) { ret[key] = default(T); } else { ret[key] = (T)value; } } return(ret); }