https://www.skysigal.com/ 2026-06-26T10:27:53+00:00 https://www.skysigal.com/ https://www.skysigal.com/lib/tpl/bootstrap3/images/favicon.ico text/html 2023-11-04T02:19:26+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.skysigal.com/it/ad/code_first/migrations/howto/add-migration_initial_migration?rev=1699064366&do=diff IT:AD:EF/CodeFirst/Migrations:HowTo:Add-Migration/Initial Migration * (UP) howto index If you invoked IT:AD:EF/CodeFirst/Migrations:HowTo:Enable-Migrations with -EnableAutomaticMigrations (so that no InitialCreate migrations was created), when you turn on Turn off Automatic migrations (in the Migrations/Configuration.cs text/html 2023-11-04T02:19:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.skysigal.com/it/ad/code_first/migrations/howto/add-migration?rev=1699064365&do=diff IT:AD:EF/CodeFirst/Migrations:HowTo:Add-Migration * (UP) howto index So...if Enabling Migrations and using IT:AD:EF/CodeFirst/Migrations:HowTo:Update-Database is too easy/dangerous, what's the safer approach? Process The solution MS is pushing is to be more ... careful. * Make changes to an Entity * Try to run * Get the exception that says the Model has changes text/html 2023-11-04T23:18:30+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.skysigal.com/it/ad/code_first/migrations/howto/coded_migrations_examples_running_scripts?rev=1699139910&do=diff Resources * <http://blogs.taiga.nl/martijn/2013/02/01/migrate-entity-framework-migrations-from-automatic-to-code-based/> text/html 2023-11-04T23:18:31+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.skysigal.com/it/ad/code_first/migrations/howto/custom_operations?rev=1699139911&do=diff Entity Framework 6 Notes References * <http://romiller.com/2013/02/27/ef6-writing-your-own-code-first-migration-operations/> text/html 2023-11-04T02:19:26+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.skysigal.com/it/ad/code_first/migrations/howto/define_a_migratedatabasetolatestversion_db_initialiser?rev=1699064366&do=diff IT:AD:EF/CodeFirst/Migrations:HowTo:Define a MigrateDatabaseToLatestVersion Db Initializer * (UP) howto index Until CodeMigrations became generally available, we had to use Initializers that dropped and recreated and reseeded databases. Important: This is no longer best practice text/html 2023-11-04T02:19:28+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.skysigal.com/it/ad/code_first/migrations/howto/enable_or_disable_automatic_migrations?rev=1699064368&do=diff IT:AD:EF/CodeFirst/Migrations:HowTo:Enable or Disable Automatic Migrations * (UP) howto index ## Summary When Enabling a Project for CodeFirst Migrations (IT:AD:EF/CodeFirst/Migrations:HowTo:Enable-Migrations), the default is to have Automatic CodeFirst Migrations turned off "Note: but there is an optional flag to turn it on as you Enable your project. text/html 2023-11-04T02:19:27+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.skysigal.com/it/ad/code_first/migrations/howto/enable-migrations?rev=1699064367&do=diff IT:AD:EF/CodeFirst/Migrations:HowTo:Enable-Migrations * (UP) howto index * See: * Initial Migration Code Migrations have to be enabled on a project before it can start tracking changes. Process In Nuget/Package Manager Console, type: Note that in a single assembly POC, you could type: text/html 2023-11-04T02:19:29+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.skysigal.com/it/ad/code_first/migrations/howto/generate_sql_scripts?rev=1699064369&do=diff IT:AD:EF/CodeFirst/Migrations:HowTo:Generate SQL Scripts * (UP) howto index * See: * IT:AD:EF/CodeFirst/Migrations:HowTo:Update-Database Process Run the IT:AD:EF/CodeFirst/Migrations:HowTo:Update-Database command, but this time, adding the -script switch so that the changes are output as a sql script, rather than being applied. Generate a Full Script Generate an Incremental Script From X to Y text/html 2023-11-04T02:19:30+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.skysigal.com/it/ad/code_first/migrations/howto/get_an_overview?rev=1699064370&do=diff IT:AD:EF/CodeFirst/Migrations:HowTo:Get an Overview * (UP) howto index Notes The Project's Migrations Folder When Enable-Migrations is applied to a project, a Migrations folder is created in the root of the project, that contains: * The “Migrations/Configurations.cs” file that defines how Migrations are applied (Automatically, or not) text/html 2023-11-04T02:19:29+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.skysigal.com/it/ad/code_first/migrations/howto/get-help?rev=1699064369&do=diff IT:AD:Code First:Migrations:HowTo:Get-Help * (UP) howto index Code Migrations are executed as IT:AD:Powershell scripts. Process Therefore, all you have to do to get more information is type the following in the Package Management Console: text/html 2023-11-04T02:19:30+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.skysigal.com/it/ad/code_first/migrations/howto/get-migrations?rev=1699064370&do=diff IT:AD:EF/CodeFirst/Migrations:HowTo:Get-Migrations * (UP) howto index Resources * <http://coding.abel.nu/2012/03/ef-migrations-command-reference/#Get-Migrations> text/html 2023-11-04T23:18:32+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.skysigal.com/it/ad/code_first/migrations/howto/home?rev=1699139912&do=diff IT:AD:Code First:Migrations:HowTo * (UP) howto index Common Procedures <- Important * IT:AD:EF/CodeFirst/Migrations:HowTo:Common Procedures/Deployment beyond Dev * Code changes: * IT:AD:EF/CodeFirst/Migrations:HowTo:Define a MigrateDatabaseToLatestVersion Db Initializer * IT:AD:EF/Codefirst/Migrations:HowTo:Set up Seeding * Examples * Running Scripts * Management: * IT:AD:Code First:Migrations:HowTo:Get-Help : As the operations are IT:AD:Powershell commands, we can … text/html 2023-11-04T02:19:31+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.skysigal.com/it/ad/code_first/migrations/howto/install?rev=1699064371&do=diff IT:AD:Code First:Migrations:HowTo:Install * (UP) howto index CodeFirst used to be installed separately to IT:AD:EF. Now it's part of it, and there's no need to install anything first. Process To install EF: * In the Nuget/Package Manager Console, type: Install-Package EntityFramework text/html 2023-11-04T02:19:31+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.skysigal.com/it/ad/code_first/migrations/howto/script_contents_of_migrationshistory_db_table?rev=1699064371&do=diff IT:AD:EF/CodeFirst/Migrations:HowTo:Script/Contents of __MigrationsHistory Db Table * (UP) howto index You'll find that when you try to export a Database that's been enabled for IT:AD:Code First:Migrations, even if you've chosen to script Schema and Data, the __MigrationsHistory won't be mentioned in your script. text/html 2023-11-04T02:19:32+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.skysigal.com/it/ad/code_first/migrations/howto/set_up_seeding?rev=1699064372&do=diff IT:AD:EF/Codefirst/Migrations:HowTo:Set up Seeding * (UP) howto index I've already touched on how Seeding changes in the Migrations Overview. Process When MigrateDatabaseToLatestVersion is used, Seeding of Reference data, etc. gets moved from the old-style DbInitializers (the ones that dropped/recreated the Db) to the Migrations Configuration.cs file (it has a Seed method). text/html 2023-11-04T02:19:32+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.skysigal.com/it/ad/code_first/migrations/howto/strategies?rev=1699064372&do=diff IT:EF/CodeFirst/Migrations:HowTo:Strategies * (UP) howto index Understanding the changes to workflow that arise due to using CodeFirst Migrations can be a challenge at first. Process * Invoke Enable-Migrations with -AutoMigrations turned on, in order to start the migration with no text/html 2023-11-04T02:19:33+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.skysigal.com/it/ad/code_first/migrations/howto/update-database?rev=1699064373&do=diff IT:AD:EF/CodeFirst/Migrations:HowTo:Update-Database * (UP) howto index The Update-Database command applies “Coded Migrations” and “Automated Migrations” to the database. Process All you have to do is something like: Regarding Update-Database and 'Automated Migrations'