public static String ConvertJoinComparison(SelectJoinType Comparison)
{
switch (Comparison)
{
case SelectJoinType.InnerJoin:
return("inner join");
case SelectJoinType.LeftJoin:
return("left join");
case SelectJoinType.RightJoin:
return("right join");
case SelectJoinType.Join:
return("join");
case SelectJoinType.FullJoin:
return("full join");
case SelectJoinType.CrossJoin:
return("cross join");
default:
throw new Exception("not found comparison.");
}
}
public void Join(SelectJoinType joinType, string tableName, string tableField, string joinField)
{
IJoinBuilder builder = Database.QueryFactory.CreateJoin();
builder.Join(joinType, tableName, tableField, joinField);
_joins.Add(builder);
}
public void Join(SelectJoinType joinType, string tableName, string tableField, string joinField)
{
_joinType = joinType;
_tableName = tableName;
_tableField = tableField;
_joinField = joinField;
}
/// <summary>
/// add Join condition
/// </summary>
/// <param name="type"></param>
/// <param name="TableName"></param>
/// <param name="ColumnName"></param>
/// <param name="Comparison"></param>
/// <param name="FromTableName"></param>
/// <param name="FromColumnName"></param>
public void AddJoin(SelectJoinType type, String TableName, String ColumnName, CommandComparison Comparison, String FromTableName, String FromColumnName)
{
if (String.IsNullOrEmpty(ColumnName))
{
throw new Exception("Values is null.");
}
joincondition.Add(String.Format(" {0} {1} ON {2}.{3} {4} {5}.{6}", CommonService.ConvertJoinComparison(type), TableName, FromTableName, FromColumnName
, CommonService.ConvertComparison(Comparison), TableName, ColumnName));
}
