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