Skip to content

Instantly share code, notes, and snippets.

@diffused

diffused/wipedb

Created April 1, 2015 11:46
Show Gist options
  • Save diffused/90d329ac8f2878c39661 to your computer and use it in GitHub Desktop.
Save diffused/90d329ac8f2878c39661 to your computer and use it in GitHub Desktop.
Download ZIP
EF + Sql Server wipe data in all tables listed in __MigrationHistory
Raw
wipedb
context.Database.ExecuteSqlCommand("sp_MSForEachTable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'");
context.Database.ExecuteSqlCommand("sp_MSForEachTable 'IF OBJECT_ID(''?'') NOT IN (ISNULL(OBJECT_ID(''[dbo].[__MigrationHistory]''),0)) DELETE FROM ?'");
context.Database.ExecuteSqlCommand("EXEC sp_MSForEachTable 'ALTER TABLE ? CHECK CONSTRAINT ALL'");
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment