Top
Top
LibraryEASYProcess Reference ManualProcessesServicesDBWorkshopDelete

Delete Overview

A “Delete” is a service that can be used to run a SQL delete statement.

The benefit of using a Delete to an ExecuteUpdate (another service that can be used to run a delete statement), is that you can enter the desired table and where clause and EASYProcess will build the SQL query for you. This does not require that the developer be very familiar with the SQL query syntax.

Deletes build the query for you given the table and where clause. It follows the pattern:

DELETE FROM [Table] WHERE [Where Clause]

The drawback of the Delete service is that EASYProcess will always use this pattern and requires that the WhereClause be predefined in the Keys. Sometimes a developer would like to build the delete statement based on XSLT functions. A developer also might just feel more comfortable writing the statement themselves which gives more control. In these examples an ExecuteUpdate service might be a better fit.

Since EASYProcess is in charge of maintaining the query pattern in a Delete service, it is able to do things for us, like parameterize the query.

A parameterized query is a query in which placeholders are used for parameters and the parameter values are supplied at execution time. The most important reason to use parameterized queries is to avoid SQL injection attacks. These can happen when a value used in the query comes from the page in user entered data.


Delete Use Examples
Workshop:DBWorkshop
Service:Delete
Inputs
DbType

ConnectionString

FileName

Keys

Key

AndOr

Column

Operator

Type

Value

CommandTimeout

Outputs
NoOfRecordsDeleted
Query

Delete Use Examples

Basic Use Example

In this example we have a Delete service named “DeletePriceCache”. It has been configured to delete from a table (EC_User_Price_Cache) where the column in this table (CustomerId) is equal to the variable we have entered.

Let’s say that variable is returning a value of ‘4242’. Here is the query which will run:

DELETE FROM EC_User_Price_Cache WHERE CustomerId = '4242'

The Delete service will only return the query that ran and the number of result that were deleted. Here is an example of what the output will return. Notice EASYProcess has done the parameterization for us.


Powered by EASYProcess (© 2019 K-Rise Systems, Inc).