/// <summary>
/// Generates a UPDATE query based on the specified QueryCriteria
/// </summary>
/// <param name="criteria">QueryCriteria based upon which the query is generated</param>
/// <returns>The resulting ExecutionQuery</returns>
public ExecutionQuery GenerateUpdate(QueryCriteria criteria)
{
//set the generation type
generatorType = QueryCriteriaGeneratorType.Update;
//no joins so generate the normal query criteria
return(GenerateWithoutJoin(criteria));
}
/// <summary>
/// </summary>
/// <param name="criteria"></param>
/// <returns></returns>
public ExecutionQuery GenerateUpdate(QueryCriteria criteria)
{
try
{
generatorType = QueryCriteriaGeneratorType.Update;
return(GenerateWithoutJoin(criteria));
}
catch
{
throw;
}
}
/// <summary>
/// </summary>
/// <param name="criteria"></param>
/// <returns></returns>
public ExecutionQuery GenerateDelete(QueryCriteria criteria)
{
try
{
generatorType = QueryCriteriaGeneratorType.Delete;
//no joins so generate the normal query criteria
return(GenerateWithoutJoin(criteria));
}
catch
{
throw;
}
}
/// <summary>
/// Generates the query based on the specified query criteria.
/// </summary>
/// <param name="criteria">QueryCriteria upon which the query is generated </param>
/// <returns>Sql Query</returns>
public ExecutionQuery GenerateSelect(QueryCriteria criteria)
{
//set the generation type
generatorType = QueryCriteriaGeneratorType.Select;
if (criteria.JoinCriteriaConditions.Length == 0)
{
//no joins so generate the normal query criteria
return(GenerateWithoutJoin(criteria));
}
else
{
//generate the criteria with joins
return(GenerateWithJoin(criteria));
}
}
/// <summary>
/// Generates a DELETE query based on the specified QueryCriteria.
/// </summary>
/// <param name="criteria"></param>
/// <returns></returns>
public ExecutionQuery GenerateDelete(QueryCriteria criteria)
{
generatorType = QueryCriteriaGeneratorType.Delete;
return(GenerateWithoutJoin(criteria));
}
