Dotnet EF Cheatsheet

Übersicht nützlicher Funktionen für dotnet ef.

Install Tool

dotnet tool install --global dotnet-ef

Update Tool

dotnet tool update --global dotnet-ef

Migration hinzufügen

dotnet ef migrations add "Add_Movies"

Update Database

dotnet ef database update

Create Migration SQL

# Create Database via CREATE DATABASE [YourDatabaseName]
dotnet ef migrations script -i -o "create.sql

Revert last migration after update database

# Show all Migrations and copy last good migration
dotnet ef migrations list

# Update database to last known good migration
dotnet ef database update 20250403191901_LAST_GOOD_MIGRATION

# Remove last migration
dotnet ef migrations remove