Truncate Tables

Required Nuget Package:

Adds support for TRUNCATE TABLE.

Configuration

Add support for truncating tables.

If you are using Lazy Loading then disable the registration of temp tables for primites types sqlOptions.AddBulkOperationSupport(configureTempTablesForPrimitiveTypes: false).

var services = new ServiceCollection() 
                       .AddDbContext<DemoDbContext>(builder => builder
                               // SQL Server
                               .UseSqlServer("conn-string", sqlOptions =>
                                                            {
                                                                 sqlOptions.AddBulkOperationSupport();
                                                            })
                               // SQLite
                               //.UseSqlite("conn-string", sqlOptions =>
                               //                             {
                               //                                  sqlOptions.AddBulkOperationSupport();
                               //                             })

Usage

await ctx.TruncateTableAsync<Customer>();