/// <summary>
/// Column name of which condition will be specified
/// </summary>
/// <param name="column">Name of column</param>
/// <returns>Clause instance object</returns>
public IDeleteClause Where(String column)
{
where = new DeleteClauseImpl(this);
where.AddCol(column);
return(where);
}
/// <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 IDeleteClause Having(String column)
{
having = new DeleteClauseImpl(this);
having.AddCol(column);
return(having);
}
/// <summary>
/// Used to delete, this method should be called in last to delete tuples from table.
/// </summary>
public void 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();
}
DatabaseHelper.Delete(referObject, where);
}
/// <summary>
/// Column name of which condition will be specified
/// </summary>
/// <param name="column">Name of column</param>
/// <returns>Clause instance object</returns>
public IDeleteClause Where(String column)
{
where = new DeleteClauseImpl(this);
where.AddCol(column);
return where;
}
/// <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 IDeleteClause Having(String column)
{
having = new DeleteClauseImpl(this);
having.AddCol(column);
return having;
}
public void 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();
}
DatabaseHelper.Delete(referObject, where);
}