Using fluentmigrator for automated database deployment (in ASP.NET Core)

One of the best ways to get agility in the software development life cycle is to have an automated build and deployment. More often, database deployment becomes a bottleneck.

For years the code deployment and database deployments were separate. The database has always been deployed by DBA's, whereas the code is usually deployed through automated and/or semi-automated systems.

Now dependency on DBA's for deployment the deployment process slower and more emphasis in coordination with multiple teams during deployment.

But the Migrations of EntityFramework core is tightly coupled with the EntityFramework core. Hence, if you are using other ORM, like Dapper or you are using plain old ASO.NET for data access, fluentmigrator is your answer to database migration and automated deployments of database changes.

In this video, I will walk through creating a database table, with keys and indexes, as well as rolling back the changes.

[Inbarreto]

how can i run the MigrateDown from a console, instead of having to build and deploy the app if i want to roll back, i want to run a Migrate -migrate:down command, I can't seem to make it work, thanks

[thedacian]

In which order, are migrations going to be run.?
In ef core each migration has a timestamp that indicates the migration order.Thanks!

[moabonmecca]

great tutorial. I am wondering about fluentmigrator support for postgresql and custom types. Any idea?

[sephirothcrescent]

thanks for that.
May I know what's the purpose of 'using' from 'using var scope =...'?
Is it the same as using statement for destroying the object?

[tisouza]

Hello!
If my migrations were in another project of the same solution.
How do I load assemblies at startup?

[AmrIbrahim]

migratedown(26112022010000) !! not working with .net6 core !! even migrateup is working fine !
anyhelp