EF Model snapshot dev vs prod

Laurent Guigon 276

Hi,

I've an app with EF core, Model First. I created a seed data set for testing my an during the dev phase. I'd like to generate my prod DB, but the dev data are inserted in my prod db. That's an issue...

I use the #If DEBUG verb to exclude data from my seed method, but it still here when I run the update-data command in release mode, due to the snapshot

How can I exclude the dev sample from my db generation ?

Thx in advance.

AgaveJoe 26,201 Reputation points

2023-01-12T12:24:56.0933333+00:00

How you've designed the seed process is not clear. If the design calls a method when the application starts then simply take advantage of the environment feature in ASP.NET Core to determine if the method should seed the data. The snapshot is irrelevant because the seed is outside a migration.

Use multiple environments in ASP.NET Core

If you added the data to a migration then I think you have to either back out the migrations and create a method to seed the data or create a new migration that reverts the seed, if possible.

Can you explain or share sample code that illustrates how seeding works in your application? Also, what kind of application are you building?