public void Join(string originalTableName, string joinTableName, string leftField, string rightField)
{
var joinString =
$"JOIN {Adapter.Table(joinTableName)} ON {Adapter.Field(originalTableName, leftField)} = {Adapter.Field(joinTableName, rightField)}";
TableNames.Add(joinTableName);
JoinExpressions.Add(joinString);
SplitColumns.Add(rightField);
}
public void Join(string joinTableName, string commandText, JoinType joinType)
{
var join = GetJoinExpression(joinType);
var joinString =
$"{join} {Adapter.Table(joinTableName)} " +
$"ON {commandText}";
TableNames.Add(joinTableName);
JoinExpressions.Add(joinString);
}
public void Join(string originalTableName, string joinTableName, string leftField, string rightField, JoinType joinType)
{
var join = GetJoinExpression(joinType);
var joinString =
$"{join} {Adapter.Table(joinTableName)} " +
$"ON {Adapter.Field(originalTableName, leftField)} = {Adapter.Field(joinTableName, rightField)}";
TableNames.Add(joinTableName);
JoinExpressions.Add(joinString);
SplitColumns.Add(rightField);
}