public virtual void InnerJoin(string table, string onTable, string onColumn, string toTable, string toColumn, string alias = null, string toAlias = null) { // Don't prefix if alias is used if (alias != onTable) { onTable = _tablePrefix + onTable; } if (toTable != toAlias) { toTable = _tablePrefix + toTable; } if (!String.IsNullOrEmpty(toAlias)) { toTable = toAlias; } JoinSegments.Add(" INNER JOIN "); JoinSegments.Add(_dialect.QuoteForTableName(_tablePrefix + table)); if (!String.IsNullOrEmpty(alias)) { JoinSegments.AddRange(new[] { " AS ", _dialect.QuoteForTableName(alias) }); } JoinSegments.AddRange(new[] { " ON ", _dialect.QuoteForTableName(onTable), ".", _dialect.QuoteForColumnName(onColumn), " = ", _dialect.QuoteForTableName(toTable), ".", _dialect.QuoteForColumnName(toColumn) } ); }
public virtual void InnerJoin(string table, string onTable, string onColumn, string toTable, string toColumn) { JoinSegments.AddRange(new[] { " INNER JOIN ", _dialect.QuoteForTableName(_tablePrefix + table), " ON ", _dialect.QuoteForTableName(_tablePrefix + onTable), ".", _dialect.QuoteForColumnName(onColumn), " = ", _dialect.QuoteForTableName(_tablePrefix + toTable), ".", _dialect.QuoteForColumnName(toColumn), " " } ); }