Dapper Contrib Delete Discover How to Delete Data From a Table

Description

Database Delete operation refers to the process of deleting data from a database table. To delete data from a database, the user must have the DELETE privilege on the table. The DELETE statement is used to delete records from a database table.

The Dapper.Contrib library provides the Delete method which is a pretty simple way of deleting the data.

• With the Delete method, we don't need to write any SQL statements, we just need to pass in the object that needs to be deleted as a parameter to the Delete method.
• The Delete method deletes a given entity in the database.

Parameters

The syntax of the Delete<T> method is given below:

public static bool Delete<T>(T entityToDelete, IDbTransaction transaction = null, int? commandTimeout = null)

The following table shows the different parameters of a Delete method.

The Delete method returns true if deleted, false if not found. With the Delete method, you can delete a single or many entities.

• Delete Single
• Delete Many

Example - Delete Single

To delete an entity, simply call the Delete method and pass in your entity. The following example deletes a single entity using the Delete method.

using (var connection = My.ConnectionFactory())
{
    connection.Open();

    var isSuccess = connection.Delete(new Invoice {InvoiceID = 1});
}

Example - Delete Many

If you would like to delete multiple entities at once, you can pass in an IEnumerable<T> to the Delete method as shown in the following example.

using (var connection = My.ConnectionFactory())
{
    connection.Open();

    var list = new List<Invoice>()
    {
        new Invoice {InvoiceID = 1},
        new Invoice {InvoiceID = 2},
        new Invoice {InvoiceID = 3}
    };

    var isSuccess = connection.Delete(list);
}