private int[] GetUsedTags(string table, IDataMapper mapper) { return(mapper.ExecuteReader($"SELECT DISTINCT Tags FROM {table} WHERE NOT Tags = '[]'", reader => reader.GetString(0)) .SelectMany(Json.Deserialize <List <int> >) .Distinct() .ToArray()); }
private int[] GetUsedTags(string table, IDataMapper mapper) { return mapper.ExecuteReader($"SELECT DISTINCT Tags FROM {table} WHERE NOT Tags = '[]'", reader => reader.GetString(0)) .SelectMany(Json.Deserialize<List<int>>) .Distinct() .ToArray(); }
public static List <TModel> QueryScalar <TModel>(this IDataMapper dataMapper, string sql) { return(dataMapper.ExecuteReader(sql, reader => (TModel)Convert.ChangeType(reader.GetValue(0), typeof(TModel))).ToList()); }