/// <summary>
/// Adds a RIGHT JOIN clause.
/// </summary>
/// <param name="Select">The SelectCountQuery instance.</param>
/// <param name="TableAlias">The alias of the table.</param>
/// <param name="ConditionStatement">The condition statment/s of the joined table.</param>
/// <returns>The current instance of this class.</returns>
public SelectCountQuery SetRightJoin(SelectCountQuery Select, string TableAlias, string ConditionStatement)
{
if (Select == null)
{
throw new ArgumentException("Select argument should not be null.");
}
string strQuery = Select.ToString();
if (strQuery.IsNullOrWhiteSpace())
{
throw new ArgumentException("Select argument should not be empty.");
}
if (TableAlias.IsNullOrWhiteSpace())
{
throw new ArgumentException("TableAlias argument should not be empty.");
}
if (!this._IsValidField(TableAlias))
{
throw new ArgumentException("TableAlias argument should only contain letters, numbers and/or underscores.");
}
if (ConditionStatement.IsNullOrWhiteSpace())
{
throw new ArgumentException("Condition argument should not be empty.");
}
this._Joins.Add(String.Format("RIGHT JOIN ({0}) {1} ON ({2})", strQuery, TableAlias, ConditionStatement));
return(this);
}
/// <summary>
/// Initializes the query as a table, and table alias for the SELECT statement.
/// </summary>
/// <param name="Select">The SelectCountQuery instance.</param>
/// <param name="TableAlias">The alias of the query.</param>
public SelectCountQuery(SelectCountQuery Select, string TableAlias)
{
if (Select == null)
{
throw new ArgumentException("Select argument should not be null.");
}
string strQuery = Select.ToString();
if (strQuery.IsNullOrWhiteSpace())
{
throw new ArgumentException("Select argument should not be empty.");
}
if (TableAlias.IsNullOrWhiteSpace())
{
throw new ArgumentException("TableAlias argument should not be empty.");
}
if (!this._IsValidField(TableAlias))
{
throw new ArgumentException("TableAlias argument should only contain letters, numbers and/or underscores.");
}
this._From = String.Format("({0}) {1}", strQuery, TableAlias);
this._TableAlias = TableAlias;
this._InitProperties();
}