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); }