/// <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;
 }
Example #3
0
 /// <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()));
            }
        }
Example #6
0
 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);
 }
Example #7
0
 /// <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);
 }