EF Core - How to add SQL comments to generated migration script

Question

I need to seed only a subset of records in production environment compared to development. The seeding of data will be done by executing the generated SQL script from migrations (not during application run time). The only way I found it can be done is by eliminating the unwanted INSERT statements from the generated sql script before executing in production SQL server.

Is there a way to insert SQL comments to the migration script which will eventually make it into the generated sql script? I know that I can use migrationBuilder.Sql("") to add comments/custom sql to the migration script after the add-migration is run. But is there a way to code this before, which the add-migration will include in the migration script generated?

question from:https://stackoverflow.com/questions/65599090/ef-core-how-to-add-sql-comments-to-generated-migration-script

Answer 1

Waitting for answers