Beispiel #1
0
 /// <summary>
 /// Initializes an instance of <see cref="SqlOrderByToken"/> from a string.
 /// </summary>
 /// <param name="orderByToken">Order token to add to the collection</param>
 /// <param name="direction">Order by direction, Asc or Desc</param>
 /// <param name="tokenTable"></param>
 /// <example>"Id", "-Date" or "-Date, Name"</example>
 public SqlOrderByToken(string orderByToken, SqlOrderDirection direction = SqlOrderDirection.Asc, string tokenTable = null)
 {
     Table         = tokenTable;
     SortDirection = direction;
     Column        = orderByToken.TrimStart('-');
 }
Beispiel #2
0
        /// <summary>
        /// Adds a new order by token to the expression
        /// </summary>
        /// <param name="token">Property/Column name</param>
        /// <param name="direction">Order by direction, Asc or Desc</param>
        /// <param name="table">Table name/alias</param>
        public void AddOrderToken(string token, SqlOrderDirection direction = SqlOrderDirection.Asc, string table = null)
        {
            SqlOrderByToken sqlOrderToken = new SqlOrderByToken(token, direction, table);

            OrderTokens.Add(sqlOrderToken);
        }