public List <dynamic> getDynamicQuery(int id, DTO.SearchOptions o) { var rdef = dbset.Single(a => a.ID == id); var meta = SqlServerUtils.getMetadata(DataContext, rdef.sqlquery); var queryType = buildQueryType(meta); Task <List <object> > raw = dbFactory.Get().Query <dynamic>().FromSql( //Task<List<object>> raw = db.Get().Database.SqlQuery( //queryType, rdef.sqlquery, new SqlParameter { ParameterName = "beginDate", Value = o.beginDate }, new SqlParameter { ParameterName = "endDate", Value = o.endDate }, new SqlParameter { ParameterName = "dwccardnum", Value = o.dwccardnum }).ToListAsync(); // TODO catch exception and handle here raw.Wait(); var results = raw.Result; return(results); }
public DataTable getDataTable(string query, DTO.SearchOptions o) { // https://stackoverflow.com/documentation/epplus/8223/filling-the-document-with-data DataTable dt = new DataTable(); var cnxn = DataContext.Database.Connection.ConnectionString; using (SqlDataAdapter adapter = new SqlDataAdapter(query, cnxn)) { adapter.Fill(dt); } return(dt); }