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