Delete Builder

You can perform DELETE operations with the Delete Builder as seen in the example below.

int id = 10;

var builder = SimpleBuilder.CreateFluent()
    .DeleteFrom($"User")
    .Where($"Id = {id}");

// Execute the query with Dapper
dbConnection.Execute(builder.Sql, builder.Parameters);

The generated SQL will be:

DELETE FROM User
WHERE Id = @p0

For complex WHERE clause statements refer to the Where Filters section.

Table of Contents

Delete Builder