public List <T> ExecuteQuery <T>(string sql, object parameters = null)
{
List <T> list = null;
using (System.Data.IDbConnection cn = Connection)
{
cn.Open();
GridReader result = cn.QueryMultiple(sql, parameters);
list = (List <T>)result.Read <T>();
}
return(list);
}
public List <T> ExecuteQueryFromAppQuery <T>(string queryName)
{
List <T> list = null;
using (System.Data.IDbConnection cn = Connection)
{
cn.Open();
string sql = cn.ExecuteScalar <string>("select querytext from public.appquery where queryname=@queryname", new { queryname = queryName });
GridReader result = cn.QueryMultiple(sql);
list = (List <T>)result.Read <T>();
}
return(list);
}
public List <T> ExecuteQuery <T>(string connectionString, string sql)
{
List <T> list = null;
using (System.Data.IDbConnection cn = Connection)
{
cn.ConnectionString = connectionString;
cn.Open();
GridReader result = cn.QueryMultiple(sql);
list = (List <T>)result.Read <T>();
}
return(list);
}
