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); }