Refreshing/Clean a Database with SQL and Entity Framework

Quick steps to refresh your database: 1. Drop All Tables
Run the following SQL script to drop all existing tables:

Code Snippet

DECLARE @sql NVARCHAR(MAX) = N''; SELECT @sql += 'DROP TABLE IF EXISTS [' + SCHEMA_NAME(schema_id) + '].[' + name + '];' + CHAR(13) FROM sys.tables; EXEC sp_executesql @sql;

Note: when you try above than you got some errors but don't its because of relationship execute multiple times. 2. Recreate EF Migration Table Recreate the EF migration table with this script:

Code Snippet

CREATE TABLE [dbo].[__EFMigrationsHistory] ( [MigrationId] NVARCHAR(150) NOT NULL PRIMARY KEY, [ProductVersion] NVARCHAR(32) NOT NULL );

3. Update the Database Run the following command to reapply migrations and update the schema: update-database These steps ensure a clean database reset while maintaining EF migration compatibility.