Link Search Menu Expand Document

Truncate


This method is used to truncates a table from the database.

Code Snippets

Below is the sample code that truncates the [dbo].[Person] table.

using (var connection = new SqlConnection(connectionString))
{
    connection.Truncate<Person>();
}

Targeting a Table

You can also target a specific table by passing the literal table and field name like below.

using (var connection = new SqlConnection(connectionString))
{
    connection.Truncate("[dbo].[Person]");
}