/// <summary> /// Creates a new DynamicSQLinqJoinExpression instance /// </summary> /// <param name="tableName">The database Table / View to Join</param> /// <param name="joinOperator">The JOIN operator</param> /// <param name="clause">The Join clause</param> /// <param name="parameters">Any parameter values necessary for the Join clause</param> public DynamicSQLinqJoinExpression(string tableName, DynamicSQLinqJoinOperator joinOperator, string clause, object[] parameters) { this.Table = tableName; this.JoinOperator = joinOperator; this.Clause = clause; this.Parameters = parameters; }
/// <summary> /// Creates a new DynamicSQLinqSubQueryJoinExpression instance /// </summary> /// <param name="query">The sub-query that will be joined</param> /// <param name="alias">The Alias to give the sub-query within the main query</param> /// <param name="joinOperator">The JOIN operator</param> /// <param name="clause">The Join clause</param> /// <param name="parameters">Any parameters necessary for the Join clause</param> public DynamicSQLinqSubQueryJoinExpression(ISQLinq query, string alias, DynamicSQLinqJoinOperator joinOperator, string clause, params object[] parameters) { this.Query = query; this.Alias = alias; this.JoinOperator = joinOperator; this.Clause = clause; this.Parameters = parameters; }
/// <summary> /// Creates a new DynamicSQLinqJoinExpression instance /// </summary> /// <param name="tableName">The database Table / View to Join</param> /// <param name="joinOperator">The JOIN operator</param> /// <param name="clause">The Join clause</param> /// <param name="parameters">Any parameter values necessary for the Join clause</param> public DynamicSQLinqJoinExpression(ISqlDialect dialect, string tableName, DynamicSQLinqJoinOperator joinOperator, string clause, object[] parameters) { this.Dialect = dialect; this.Table = tableName; this.JoinOperator = joinOperator; this.Clause = clause; this.Parameters = parameters; }
public static string ToSQL(this DynamicSQLinqJoinOperator op) { switch (op) { case DynamicSQLinqJoinOperator.Inner: return("JOIN"); case DynamicSQLinqJoinOperator.Left: return("LEFT JOIN"); case DynamicSQLinqJoinOperator.Right: return("RIGHT JOIN"); case DynamicSQLinqJoinOperator.Full: return("FULL JOIN"); default: throw new Exception(string.Format("Unsupported DynamicSQLinqJoinOperator value: {0}", op.ToString())); } }
public DynamicSQLinq Join(ISQLinq subquery, string subqueryAlias, DynamicSQLinqJoinOperator joinOperator, string clause, params object[] parameters) { this.JoinClauses.Add(new DynamicSQLinqSubQueryJoinExpression(subquery, subqueryAlias, joinOperator, clause, parameters)); return(this); }
/// <summary> /// Specifies a SQL join to use with the generated query. /// </summary> /// <param name="tableName"></param> /// <param name="clause"></param> /// <returns></returns> public DynamicSQLinq Join(string tableName, DynamicSQLinqJoinOperator joinOperator, string clause, params object[] parameters) { this.JoinClauses.Add(new DynamicSQLinqJoinExpression(tableName, joinOperator, clause, parameters)); return(this); }