Beispiel #1
0
 /// <summary>
 /// Add As to query
 /// </summary>
 /// <param name="fromCommand">From command instance</param>
 /// <param name="alias">Table alias</param>
 /// <returns></returns>
 public static IAliasOperator As(this IFromCommand fromCommand, string alias)
 => fromCommand.To <AliasOperator>().As(alias);
Beispiel #2
0
 /// <summary>
 /// Add Left Join to query
 /// </summary>
 /// <param name="fromCommand">From command instance</param>
 /// <param name="table">Table name</param>
 /// <returns></returns>
 public static IJoin LeftJoin(this IFromCommand fromCommand, string table)
 => fromCommand.To <Join>().LeftJoin(table);
Beispiel #3
0
 /// <summary>
 /// Add Where to query
 /// </summary>
 /// <param name="fromCommand">From command instance</param>
 /// <param name="column">Column name</param>
 /// <returns></returns>
 public static IWhereFilter Where(this IFromCommand fromCommand, string column)
 => fromCommand.To <WhereFilter>().Where(column);
Beispiel #4
0
 /// <summary>
 /// Add Inner Join to query
 /// </summary>
 /// <param name="fromCommand">From command instance</param>
 /// <param name="table">Table name</param>
 /// <returns></returns>
 public static IJoin InnerJoin(this IFromCommand fromCommand, string table)
 => fromCommand.To <Join>().InnerJoin(table);
 /// <summary>
 /// Add Where to query
 /// </summary>
 /// <param name="fromCommand">From command instance</param>
 /// <param name="column">Column name</param>
 /// <returns></returns>
 public static IWhereFilter Where(this IFromCommand fromCommand, string column)
 => fromCommand is IWhereFilter command?command.Where(column) : null;