Since #27372, SaveChanges fails by default on SQL Server for tables with triggers. We could detect triggers when scaffolding and scaffold HasTrigger to make the database-first story smoother. This may be a bit tricky since HasTrigger is on TableBuilder rather than directly on EntityTypeBuilder (not sure if we already have the infra for scaffolding that).
Raised by @ErikEJ in ErikEJ/ErikEJ#1 (comment)