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.
The EntityFramrwork has a solution in place for Migration. And I have a couple of videos on that on my channel. You can check it out in this playlist: • Entity Framework Core (Inline Query f...
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.
The source code for this video is available here: https://github.com/choudhurynirjhar/f...