public void RightJoin(string toTableName, SqlComparisonBuilder sqlComaraison)
{
JoinFactory(" RIGHT JOIN ", toTableName, sqlComaraison);
}
private void JoinFactory(string jointType, string toTableName, SqlComparisonBuilder sqlComaraison)
{
if (_sqlQueryRequest.Joins == null) _sqlQueryRequest.Joins = new List<string>();
_sqlQueryRequest.Joins.Add(jointType + toTableName + " ON " + sqlComaraison.QuerySqlComparison);
}
public void OuterJoin(string toTableName, SqlComparisonBuilder sqlComaraison)
{
JoinFactory(" OUTER JOIN ", toTableName, sqlComaraison);
}
public void LeftJoin(string toTableName, SqlComparisonBuilder sqlComaraison)
{
JoinFactory(" LEFT JOIN ", toTableName, sqlComaraison);
}
public SqlQueryBuilder LeftJoin(string toTableName, SqlComparisonBuilder sqlComaraison)
{
_sqlJoinBuilder.LeftJoin(toTableName, sqlComaraison);
return this;
}
public SqlWhereOperator Where(SqlComparisonBuilder sqlComparison)
{
return _sqlWhereBuilder.Where(sqlComparison);
}
public SqlQueryBuilder InnerJoin(string toTableName, SqlComparisonBuilder sqlComaraison)
{
return _sqlQueryBuilder.InnerJoin(toTableName, sqlComaraison);
}