Exemplos de EternityFramework.LinqToSql.SqlQueryBuilder.QueryBuilderStates QeuryStateContext.GenerateNextTableAlias em C# (CSharp)

Exemplo n.º 1

Arquivo: SelectClosedState.cs Projeto: Wideweb/EternityFramework

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

Exemplo n.º 2

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