DeleteAll
This method is used to delete an array-of (and/or all) rows from the table.
Code Snippets
Below is the sample code that delete all the rows from the [dbo].[Person]
table.
using (var connection = new SqlConnection(connectionString))
{
var deletedRows = connection.DeleteAll<Person>();
}
Or you can target the list of primary keys.
using (var connection = new SqlConnection(connectionString))
{
var primaryKeys = new [] { 10045, 11921, 12001 };
var deletedRows = connection.DeleteAll<Person>(primaryKeys);
}
Targeting a Table
You can also target a specific table by passing the literal table name like below.
using (var connection = new SqlConnection(connectionString))
{
var deletedRows = connection.DeleteAll("[dbo].[Person]");
}
Table Hints
To pass a hint, simply write the table-hints and pass it in the hints
argument.
using (var connection = new SqlConnection(connectionString))
{
var deletedRows = connection.DeleteAll<Person>(hints: "WITH (NOLOCK)");
}
Or, you can use the SqlServerTableHints class.
using (var connection = new SqlConnection(connectionString))
{
var deletedRows = connection.DeleteAll<Person>(hints: SqlServerTableHints.TabLock);
}