public void AddOrderBy(Type tableType, string property) { context.TableType = tableType; context.SqlQuery = $"SELECT TOP 100 PERCENT * FROM ({context.SqlQuery}) AS {context.CurrentTableAlias} ORDER BY {property}"; context.GenerateNextTableAlias(); context.OrderedByProperty = property; }
public void AddOrderBy(Type tableType, string property) { context.TableType = tableType; context.SqlQuery = $"SELECT TOP 100 PERCENT * FROM [{tableType.Name}] AS {context.CurrentTableAlias} ORDER BY {property}"; context.GenerateNextTableAlias(); context.OrderedByProperty = property; sqlQueryBuilder.SetState(new SelectClosedState(sqlQueryBuilder, context)); }