/// <summary> /// Used to specify HAVING clause to SQL because the WHERE keyword could not be used with aggregate functions /// </summary> /// <param name="column">Name of column on which condition need to be applied</param> /// <returns>Clause instance object</returns> public ICountClause Having(String column) { having = new CountClauseImpl(this); having.AddCol(column); return(having); }
/// <summary> /// Column name of which condition will be specified. /// </summary> /// <param name="column">Name of column</param> /// <returns>Clause instance object</returns> public ICountClause Where(String column) { where = new CountClauseImpl(this); where.AddCol(column); return(where); }
public int Execute() { String where = ""; if (this.whereClause != null && this.whereClause.Length > 0) { where = this.whereClause; } else { if (this.where != null) { where = this.where.ToString(); } } String having = ""; if (this.havingClause != null && this.havingClause.Length > 0) { having = this.havingClause; } else { if (this.having != null) { having = this.having.ToString(); } } if (this.columns == null) { this.columns = new String[] { }; } if (this.orderBy == null) { this.orderBy = new String[] { }; } if (this.groupBy == null) { this.groupBy = new String[] { }; } String limit = null; if (this.limit != 0) { limit = this.limit.ToString(); } return(DatabaseHelper.Count(entityDescriptor, column, distinct, where, groupBy.ToList().GetEnumerator(), having)); }
/// <summary> /// Used to get count, this method should be called in last to calculate count. /// </summary> /// <returns>Count</returns> public int Execute() { String where = ""; if (this.whereClause != null && this.whereClause.Length > 0) { where = this.whereClause; } else { if (this.where != null) { where = this.where.ToString(); } } String having = ""; if (this.havingClause != null && this.havingClause.Length > 0) { having = this.havingClause; } else { if (this.having != null) { having = this.having.ToString(); } } if (this.columns == null) { this.columns = new String[] { }; } if (this.orderBy == null) { this.orderBy = new String[] { }; } if (this.groupBy == null) { this.groupBy = new String[] { }; } String limit = null; if (this.limit != 0) { limit = this.limit.ToString(); } return DatabaseHelper.Count(entityDescriptor, column, distinct, where, groupBy.ToList().GetEnumerator(), having); }
/// <summary> /// Used to specify HAVING clause to SQL because the WHERE keyword could not be used with aggregate functions /// </summary> /// <param name="column">Name of column on which condition need to be applied</param> /// <returns>Clause instance object</returns> public ICountClause Having(String column) { having = new CountClauseImpl(this); having.AddCol(column); return having; }
/// <summary> /// Column name of which condition will be specified. /// </summary> /// <param name="column">Name of column</param> /// <returns>Clause instance object</returns> public ICountClause Where(String column) { where = new CountClauseImpl(this); where.AddCol(column); return where; }