public List <T> Find(string where, params DbParameter[] dbParameters)
{
var result = new List <T>();
var queryResult = SqlHelper.Query(where, dbParameters);
foreach (var item in queryResult)
{
var model = JsonDataConvert.DeSerializeObject <T>((string)item.data);
result.Add(model);
}
return(result);
}
public T Get(string id)
{
var sql = $"select data::text from {table} where id = @id";
var queryResult = SqlHelper.Query(sql, new NpgsqlParameter
{
ParameterName = "id",
NpgsqlDbType = NpgsqlDbType.Text,
NpgsqlValue = id
});
if (queryResult.Any())
{
return(JsonDataConvert.DeSerializeObject <T>((string)(queryResult.FirstOrDefault().data)));
}
return(null);
}