public async Task <List <JObject> > Post([FromBody] object record) { try { JObject jobj = (JObject)record; string procName = "GetTablesAndColumns"; var procParams = new Dictionary <string, string>(); procParams["@tableGuid"] = (string)jobj.SelectToken(Configurations.ProtectedPropertyTableName); List <Column> columns = await _dal.GetData <Column>(procParams, procName, ConnectionSettings.ExploreConnString); Query query = QueryHelpers.BuildQuery(jobj, columns); Dictionary <string, string> colNameToPsedonym = columns.ToDictionary(x => x.ColumnName, x => x.Pseudonym); List <JObject> records = await _dal.GetDataWithParameters(query, ConnectionSettings.ExploreConnString, jobj, colNameToPsedonym); return(records); } catch (Exception ex) { //todo logging throw; } }
public IEnumerable <T> Retrieve(int pageSize, int pageIndex, out int virtualCount, TCriteria criteria = null, params Order <T>[] orderBy) { return(QueryHelpers <T> .Page( QueryHelpers <T> .BuildQuery(_dbSet, _expressionBuilder(criteria), orderBy), pageSize, pageIndex, out virtualCount)); }
public IEnumerable <T> Retrieve(TCriteria criteria = null, params Order <T>[] orderBy) { return(QueryHelpers <T> .BuildQuery(_dbSet, _expressionBuilder(criteria), orderBy)); }
public IEnumerable <T> RetrieveAll(params Order <T>[] @orderby) { return(QueryHelpers <T> .BuildQuery(_dbSet, orderby)); }