EntityFrameworkCore. Truncating / Emptying a table.

I was in the position of creating unit tests for a custom web api, and needed to wipe all data in a table before I run my tests.

Here’s the small command I run to delete all rows in the table


        public void deleteAllData() 
            using (var db = new AlertsDbContext()) 


Remove range takes IENumerable as a parameter. Which is why when you pass it an entire collection, it’ll straight up delete all entries.

Leave a Reply

Your email address will not be published. Required fields are marked *