/// <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 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;
}
public static int Execute(this IDbConnection dbconnection, ISQLinq query,
IDbTransaction transaction = null, int?commandTimeout = null, CommandType?commandType = null)
{
var result = query.ToSQL();
var sql = result.ToQuery();
var parameters = new DictionaryParameterObject(result.Parameters);
return(DapperDotNet.SqlMapper.Execute(dbconnection, sql, parameters, transaction, commandTimeout, commandType));
}
public static IEnumerable <dynamic> Query(this IDbConnection dbconnection, ISQLinq query,
IDbTransaction transaction = null, bool buffered = true, int?commandTimeout = null, CommandType?commandType = null)
{
var result = query.ToSQL();
var sql = result.ToQuery();
var parameters = new DictionaryParameterObject(result.Parameters);
return(DapperDotNet.SqlMapper.Query(dbconnection, sql, parameters, transaction, buffered, commandTimeout, commandType));
}
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>
/// Creates a new DynamicSQLinqSubQueryJoinExpression instance with the JoinOperator set to DynamicSQLinqJoinOperator.Inner ("INNER JOIN")
/// </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="clause">The Join clause</param>
/// <param name="parameters">Any parameters necessary for the Join clause</param>
public DynamicSQLinqSubQueryJoinExpression(ISQLinq query, string alias, string clause, params object[] parameters)
: this(query, alias, DynamicSQLinqJoinOperator.Inner, clause, parameters)
{
}
/// <summary>
/// Creates a new DynamicSQLinqSubQueryJoinExpression instance with the JoinOperator set to DynamicSQLinqJoinOperator.Inner ("INNER JOIN")
/// </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="clause">The Join clause</param>
/// <param name="parameters">Any parameters necessary for the Join clause</param>
public DynamicSQLinqSubQueryJoinExpression(ISQLinq query, string alias, string clause, params object[] parameters)
: this(query, alias, DynamicSQLinqJoinOperator.Inner, clause, parameters)
{
}
/// <summary>
/// Createa a new SQLinqIf object
/// </summary>
/// <param name="operator">The operator used for evaluating the IF clause</param>
/// <param name="ifClause"></param>
public SQLinqIf(SQLinqIfOperator @operator, ISQLinq ifClause)
{
this.Operator = @operator;
this.If = ifClause;
}
/// <summary>
/// Createa a new SQLinqIf object
/// </summary>
/// <param name="operator">The operator used for evaluating the IF clause</param>
/// <param name="ifClause"></param>
public SQLinqIf(SQLinqIfOperator @operator, ISQLinq ifClause)
{
this.Operator = @operator;
this.If = ifClause;
}
