{"id":12920,"date":"2023-03-18T19:40:50","date_gmt":"2023-03-18T19:40:50","guid":{"rendered":"https:\/\/mauricemuteti.info\/?p=12920"},"modified":"2023-03-18T19:40:50","modified_gmt":"2023-03-18T19:40:50","slug":"revolutionize-your-development-workflow-with-this-insanely-simple-way-to-run-migrations-in-visual-studio","status":"publish","type":"post","link":"https:\/\/mauricemuteti.info\/revolutionize-your-development-workflow-with-this-insanely-simple-way-to-run-migrations-in-visual-studio\/","title":{"rendered":"&#8220;Revolutionize Your Development Workflow with This Insanely Simple Way to Run Migrations in Visual Studio!&#8221;"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_49 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"ez-toc-toggle-icon-1\"><label for=\"item-6766b7e4d81c7\" aria-label=\"Table of Content\"><span style=\"display: flex;align-items: center;width: 35px;height: 30px;justify-content: center;direction:ltr;\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/label><input  type=\"checkbox\" id=\"item-6766b7e4d81c7\"><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/mauricemuteti.info\/revolutionize-your-development-workflow-with-this-insanely-simple-way-to-run-migrations-in-visual-studio\/#Get_Confused_and_Excited_with_Running_Migrations_in_Visual_Studio\" title=\"Get Confused and Excited with Running Migrations in Visual Studio\">Get Confused and Excited with Running Migrations in Visual Studio<\/a><ul class='ez-toc-list-level-2'><li class='ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/mauricemuteti.info\/revolutionize-your-development-workflow-with-this-insanely-simple-way-to-run-migrations-in-visual-studio\/#What_Even_is_a_Migration\" title=\"What Even is a Migration?\">What Even is a Migration?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/mauricemuteti.info\/revolutionize-your-development-workflow-with-this-insanely-simple-way-to-run-migrations-in-visual-studio\/#Getting_Started_with_Migrations\" title=\"Getting Started with Migrations\">Getting Started with Migrations<\/a><ul class='ez-toc-list-level-3'><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/mauricemuteti.info\/revolutionize-your-development-workflow-with-this-insanely-simple-way-to-run-migrations-in-visual-studio\/#Step_1_Install_Entity_Framework_Migrations\" title=\"Step 1: Install Entity Framework Migrations\">Step 1: Install Entity Framework Migrations<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/mauricemuteti.info\/revolutionize-your-development-workflow-with-this-insanely-simple-way-to-run-migrations-in-visual-studio\/#Step_2_Create_a_Migration_Configuration\" title=\"Step 2: Create a Migration Configuration\">Step 2: Create a Migration Configuration<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/mauricemuteti.info\/revolutionize-your-development-workflow-with-this-insanely-simple-way-to-run-migrations-in-visual-studio\/#Step_3_Enable_Migrations\" title=\"Step 3: Enable Migrations\">Step 3: Enable Migrations<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/mauricemuteti.info\/revolutionize-your-development-workflow-with-this-insanely-simple-way-to-run-migrations-in-visual-studio\/#Creating_and_Running_a_Migration\" title=\"Creating and Running a Migration\">Creating and Running a Migration<\/a><ul class='ez-toc-list-level-3'><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/mauricemuteti.info\/revolutionize-your-development-workflow-with-this-insanely-simple-way-to-run-migrations-in-visual-studio\/#Step_1_Add_a_New_Migration\" title=\"Step 1: Add a New Migration\">Step 1: Add a New Migration<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/mauricemuteti.info\/revolutionize-your-development-workflow-with-this-insanely-simple-way-to-run-migrations-in-visual-studio\/#Step_2_Modify_the_Migration\" title=\"Step 2: Modify the Migration\">Step 2: Modify the Migration<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/mauricemuteti.info\/revolutionize-your-development-workflow-with-this-insanely-simple-way-to-run-migrations-in-visual-studio\/#Step_3_Update_the_Database\" title=\"Step 3: Update the Database\">Step 3: Update the Database<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/mauricemuteti.info\/revolutionize-your-development-workflow-with-this-insanely-simple-way-to-run-migrations-in-visual-studio\/#Step_4_View_the_Migration_History\" title=\"Step 4: View the Migration History\">Step 4: View the Migration History<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/mauricemuteti.info\/revolutionize-your-development-workflow-with-this-insanely-simple-way-to-run-migrations-in-visual-studio\/#Final_Thoughts\" title=\"Final Thoughts\">Final Thoughts<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h1><span class=\"ez-toc-section\" id=\"Get_Confused_and_Excited_with_Running_Migrations_in_Visual_Studio\"><\/span>Get Confused and Excited with Running Migrations in Visual Studio<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<h2><span class=\"ez-toc-section\" id=\"What_Even_is_a_Migration\"><\/span>What Even is a Migration?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Are you lost in a sea of code changes and a database schema that just won&#8217;t keep up? Fear not, dear developer, for migrations are here to help! Migrations are simply a set of instructions to update your database schema as you make changes to your models. They automate this tedious process and ensure that your code and database are always in sync.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Getting_Started_with_Migrations\"><\/span>Getting Started with Migrations<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>First things first, in the .NET world, Entity Framework Migrations is the tool of choice. But how do you even set up your project for migrations? It&#8217;s simpler than you think!<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Step_1_Install_Entity_Framework_Migrations\"><\/span>Step 1: Install Entity Framework Migrations<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>If you haven&#8217;t already, use the NuGet Package Manager in Visual Studio to install Entity Framework Migrations.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Step_2_Create_a_Migration_Configuration\"><\/span>Step 2: Create a Migration Configuration<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Now, navigate to your project in the Solution Explorer, right-click and select &#8220;Add &gt; New Item&#8230;&#8221;. Choose &#8220;ADO.NET Entity Data Model&#8221; and give it a name. This creates a new model file with a .edmx extension. Once it&#8217;s created, right-click it in the Solution Explorer and select &#8220;Add Code Generation Item&#8230;&#8221;. Choose &#8220;EF 6.x EntityObject Generator&#8221; and give it a name. This creates a new T4 template file with a .tt extension. Open this file and add the following code at the top:<\/p>\n<pre>\n<code>&lt;#@ template language=\"C#\" hostspecific=\"True\" #&gt;\n&lt;#@ output extension=\".cs\" #&gt;\n&lt;#@ parameter name=\"ContextNamespace\" type=\"System.String\" #&gt;\n&lt;#@ parameter name=\"ContextName\" type=\"System.String\" #&gt;\n&lt;#@ parameter name=\"ModelNamespace\" type=\"System.String\" #&gt;\n<\/code>\n<\/pre>\n<p>This code sets up the T4 template to generate Entity Framework code for your model and context.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Step_3_Enable_Migrations\"><\/span>Step 3: Enable Migrations<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Now that you have set up your project for migrations, enable them by opening the Package Manager Console (View &gt; Other Windows &gt; Package Manager Console) and running the following command:<\/p>\n<pre>\n<code>Enable-Migrations -ProjectName [YourProjectName] -StartUpProjectName [YourProjectName]<\/code>\n<\/pre>\n<p>Replace [YourProjectName] with the name of your project. This command creates a Configuration.cs file in your project for managing migrations.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Creating_and_Running_a_Migration\"><\/span>Creating and Running a Migration<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Now that you&#8217;ve successfully set up your project for migrations, let&#8217;s create and run one!<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Step_1_Add_a_New_Migration\"><\/span>Step 1: Add a New Migration<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>To create a new migration, open the Package Manager Console and run the following command:<\/p>\n<pre><code>Add-Migration [MigrationName] -ProjectName [YourProjectName] -StartUpProjectName [YourProjectName]<\/code><\/pre>\n<p>Replace [MigrationName] with a descriptive name for your migration. This command creates a new migration file in your project containing the changes to your database schema.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Step_2_Modify_the_Migration\"><\/span>Step 2: Modify the Migration<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>The migration file has a series of instructions that describe changes to your database schema. Add or remove instructions as you see fit.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Step_3_Update_the_Database\"><\/span>Step 3: Update the Database<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>To update the database with the changes from your migration, open the Package Manager Console and run the following command:<\/p>\n<pre><code>Update-Database -ProjectName [YourProjectName] -StartUpProjectName [YourProjectName]<\/code><\/pre>\n<p>This applies the changes from your migration to the database.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Step_4_View_the_Migration_History\"><\/span>Step 4: View the Migration History<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>You can view the migration history by opening the Configuration.cs file in your project, which displays all the applied migrations.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Final_Thoughts\"><\/span>Final Thoughts<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Migrations keep your database schema and code in sync, and with Entity Framework Migrations in Visual Studio, running them couldn&#8217;t be easier! Follow these steps to set up and use migrations in your development workflow with ease.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Get Confused and Excited with Running Migrations in Visual Studio What Even is a Migration? Are you lost in a sea of code changes and&hellip;<\/p>\n","protected":false},"author":1,"featured_media":12142,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[3297],"tags":[],"jetpack_featured_media_url":"https:\/\/mauricemuteti.info\/wp-content\/uploads\/2023\/03\/Visual-Studio-ULTIMATE-GUIDE-How-To-step-by-step-Tutorial.png","_links":{"self":[{"href":"https:\/\/mauricemuteti.info\/wp-json\/wp\/v2\/posts\/12920"}],"collection":[{"href":"https:\/\/mauricemuteti.info\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mauricemuteti.info\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mauricemuteti.info\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mauricemuteti.info\/wp-json\/wp\/v2\/comments?post=12920"}],"version-history":[{"count":1,"href":"https:\/\/mauricemuteti.info\/wp-json\/wp\/v2\/posts\/12920\/revisions"}],"predecessor-version":[{"id":13864,"href":"https:\/\/mauricemuteti.info\/wp-json\/wp\/v2\/posts\/12920\/revisions\/13864"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/mauricemuteti.info\/wp-json\/wp\/v2\/media\/12142"}],"wp:attachment":[{"href":"https:\/\/mauricemuteti.info\/wp-json\/wp\/v2\/media?parent=12920"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mauricemuteti.info\/wp-json\/wp\/v2\/categories?post=12920"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mauricemuteti.info\/wp-json\/wp\/v2\/tags?post=12920"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}