public static COASqlSelectData <T> OrderBy <T>(this COASqlSelectData <T> data, Expression <Func <T, object> > select) { string selectStr = " ORDER BY "; var ForeachSorgu = Types.GetAllTypes(select); ForeachSorgu.Ad.ForEach(row => { selectStr += row + ","; }); selectStr = selectStr.Remove(selectStr.Length - 1, 1); data.SqlQuery += selectStr + " ASC"; data.Lenght = data.SqlQuery.Length; data.OrderQuery = selectStr + " ASC"; return(data); }
public COASqlSelectData <T> GenerateSelectQuery(Expression <Func <T, object> > select = null) { var SelectList = new List <string>(); string selectStr = ""; if (select != null) { var ForeachSorgu = Types.GetAllTypes(select); ForeachSorgu.Ad.ForEach(row => { selectStr += row + ","; SelectList.Add(row); }); selectStr = selectStr.Remove(selectStr.Length - 1, 1); } else { selectStr = "*"; } var str = $"SELECT {selectStr} FROM {TableName}"; return(new COASqlSelectData <T>() { SqlQuery = str, Lenght = str.Length, TableName = TableName, Oracle = Oracle, PrimaryKeyName = PrimaryKeyName, SelectedColumns = SelectList }); }
public COASqlSelectData <T> GenerateSelectQuery(Expression <Func <T, object> > select) { List <string> SelectList = new List <string>(); string selectStr = ""; var ForeachSorgu = Types.GetAllTypes(select); ForeachSorgu.Name.ForEach(row => { selectStr += row + ","; SelectList.Add(row); }); selectStr = selectStr.Remove(selectStr.Length - 1, 1); return(selectQuery(selectStr, SelectList)); }