Moneyfacts recorded a 0.37 percentage point fall in the average two-year mortgage rate on the market between the start of January and February.

Biggest drop in average two-year fixed mortgage rate on the market since 2022 | The Independent

Ducati reveal what VR46 have told them about their next contract wish

Ducati drop major clue about Valentino Rossi’s VR46 team’s future | MotoGP | Crash

MP for Romford was arrested in 2022 but Scotland Yard said evidence did not meet prosecution threshold

Met police drop rape investigation into Conservative MP Andrew Rosindell | UK news | The Guardian

Andrew Rosindell is "completely exonerated" after the police decision, his spokesperson says.

Andrew Rosindell: Police drop rape investigation into Tory MP - BBC News

The Met Police said that, after a "thorough investigation", there was not enough evidence to charge Mr Rosindell. He had been arrested on suspicion of "indecent assault, sexual assault, rape, abuse of position of trust and misconduct in public office".

Police drop rape investigation into Tory MP Andrew Rosindell | Politics News | Sky News

Beyoncé, Cardi B and Ryan Reynolds were among the reportedly well-paid celebrities who dominated Super Bowl VIII commercials.

Beyoncé announces music drop in Super Bowl ad | CNN Business

Beyoncé dropped two new songs, 'Texas Hold 'Em' and '16 Carriages,' and announced a date for 'Renaissance: Act II,' following a Verizon Super Bowl ad.

Beyoncé drops new music following Verizon Super Bowl ad

Dropt

dropt

Sultanpur, India - October 11, 2024 - HackerNoon, the independent technology publishing platform, is pleased to announce the nominees for its annual “Startups of The Year” award, featuring the most promising and innovative companies in the Sultanpur startup ecosystem. The list, compiled by the HackerNoon team, showcases 30 startups making significant contributions to the Sultanpur economy and driving innovation in their respective industries. https://youtu.be/XOpG6B4AKPU?embedable=true Nominations are open - learn more here. You can nominate your company as the Startup of The Year in Sultanpur here. The Startups in Sultanpur nominated for Startups of The Year 2024 include: Kinda Solutions
Sankalp Shiksha
ADV Today
Webriy
Farmer Near Me
Caare Foundation
ForeTeach
Web AI Solutions
QuantumShift
Skyapex - Premium Digital marketing Agency
Oncquvia
AVP Web Solution
Web & Links Park
Kroto (Backed by 100X.VC)
Dee Kay
VMAD India
FutureGenAppsEmart
GUESSS India 2023
Hecolt Digital Marketing
Clobbers Couture
CodeKing Solutions
Sprint Medical
High speed Enterprises
Logyify India
Atcop Technologies Pvt.Ltd.
DroptheQ
InsureLeads.in
Kredmint
RecCloth
SpaceMantra “We are thrilled to recognize the top startups in Sultanpur and celebrate their achievements,” said David Smooke, HackerNoon Founder & CEO. “Starting and sustaining a company is difficult. We’re honored to showcase their work and impact.” Why It Pays Off to Be Nominated Startups of The Year 2024 is a 100% community-driven voting event recognizing startups transforming technology and the world for the better. Starting October 1st, 2024, the internet can nominate and vote for the best ventures in their city and industry. People can nominate their favorite startups until October 31st, and vote once per day per award for who they think should be Startup of The Year up to March 31st, 2025. Winners will be announced in April 2025, after a comprehensive evaluation by the HackerNoon team. Apart from validation from the world's greenest tech publication, all nominees get free interviews relevant to their region and industry. They will also receive curated startup-friendly packages and a free version of their very own Evergreen Tech Company News Page on HackerNoon. In sum, being nominated gives you major credibility as one of the top startups globally and an expert in your industry, meaning even without winning, you still gain tons of exposure. Nominations are open - learn more here. You can nominate your company as the Startup of The Year in Sultanpur here. About HackerNoon’s Startups of The Year Startups of The Year 2024 is HackerNoon’s flagship community-driven event celebrating startups, technology, and the spirit of innovation. Currently in its third iteration, the prestigious Internet award recognizes and celebrates tech startups of all shapes and sizes. This year, over 150,000 entities across 4200+ cities, 6 continents, and 100+ industries will participate in a bid to be crowned the best startup of the year! Millions of votes have been cast over the past few years, and many stories have been written about these daring and rising startups. The winners will get a free interview on HackerNoon and an Evergreen Tech Company News page. Visit our FAQ page to learn more. Download our design assets here. Check out the Startups of The Year Merch Shop here. HackerNoon’s Startups of The Year is a branding opportunity unlike any other. Whether your goal is brand awareness or lead generation, HackerNoon has curated startup-friendly packages to solve your marketing challenges. Meet our sponsors: Wellfound: Join the #1 global, startup-focused community. At Wellfound, we're not just a job board—we're the place where top startup talent and the world's most exciting companies connect to build the future. Notion: Notion is trusted and loved by thousands of startups as their connected workspace—from building product roadmaps to tracking fundraising. Try Notion with unlimited AI, FREE for up to 6 months, to build and scale your company with one powerful tool. Get your offer now! Hubspot: If you’re looking for a smart CRM platform that meets the needs of small businesses, look no further than HubSpot. Seamlessly connect your data, teams and customers in one easy-to-use scalable platform that grows with your business. Get started for free. Bright Data: Startups that leverage public web data can make faster, data-driven decisions, giving them a competitive edge. With Bright Data’s scalable web data collection, businesses can grow from a small operation to an enterprise by harnessing insights at every stage. Algolia: Algolia NeuralSearch is the world's only AI end-to-end Search and Discovery Platform combining powerful keyword and natural language processing in a single API. Sultanpur, India - October 11, 2024 - HackerNoon, the independent technology publishing platform, is pleased to announce the nominees for its annual “Startups of The Year” award, featuring the most promising and innovative companies in the Sultanpur startup ecosystem. Sultanpur, India - October 11, 2024 - HackerNoon, the independent technology publishing platform, is pleased to announce the nominees for its annual “Startups of The Year” award, featuring the most promising and innovative companies in the Sultanpur startup ecosystem. Sultanpur , India - October 11, 2024 Sultanpur - HackerNoon, the independent technology publishing platform, is pleased to announce the nominees for its annual “ Startups of The Year ” award, featuring the most promising and innovative companies in the Startups of The Year startup ecosystem. The list, compiled by the HackerNoon team, showcases 30 startups making significant contributions to the Sultanpur economy and driving innovation in their respective industries. https://youtu.be/XOpG6B4AKPU?embedable=true https://youtu.be/XOpG6B4AKPU?embedable=true Nominations are open - learn more here. You can nominate your company as the Startup of The Year in Sultanpur here. Nominations are open - learn more here . You can nominate your company as the Startup of The Year in Sultanpur here . here Startup of The Year in Startup of The Year in Sultanpur here here The Startups in Sultanpur nominated for Startups of The Year 2024 include: Startups in Startups in Startups in Sultanpur nominated Kinda Solutions Sankalp Shiksha ADV Today Webriy Farmer Near Me Caare Foundation ForeTeach Web AI Solutions QuantumShift Skyapex - Premium Digital marketing Agency Oncquvia AVP Web Solution Web & Links Park Kroto (Backed by 100X.VC) Dee Kay VMAD India FutureGenAppsEmart GUESSS India 2023 Hecolt Digital Marketing Clobbers Couture CodeKing Solutions Sprint Medical High speed Enterprises Logyify India Atcop Technologies Pvt.Ltd. DroptheQ InsureLeads.in Kredmint RecCloth SpaceMantra Kinda Solutions Sankalp Shiksha ADV Today Webriy Farmer Near Me Caare Foundation ForeTeach Web AI Solutions QuantumShift Skyapex - Premium Digital marketing Agency Oncquvia AVP Web Solution Web & Links Park Kroto (Backed by 100X.VC) Dee Kay VMAD India FutureGenAppsEmart GUESSS India 2023 Hecolt Digital Marketing Clobbers Couture CodeKing Solutions Sprint Medical High speed Enterprises Logyify India Atcop Technologies Pvt.Ltd. DroptheQ InsureLeads.in Kredmint RecCloth SpaceMantra “We are thrilled to recognize the top startups in Sultanpur and celebrate their achievements,” said David Smooke, HackerNoon Founder & CEO. “Starting and sustaining a company is difficult. We’re honored to showcase their work and impact.” “We are thrilled to recognize the top startups in Sultanpur and celebrate their achievements,” said David Smooke, HackerNoon Founder & CEO. “Starting and sustaining a company is difficult. We’re honored to showcase their work and impact.” “We are thrilled to recognize the top startups in and celebrate their achievements,” said David Smooke, HackerNoon Founder & CEO . “Starting and sustaining a company is difficult. We’re honored to showcase their work and impact.” David Smooke, HackerNoon Founder & CEO Why It Pays Off to Be Nominated Startups of The Year 2024 is a 100% community-driven voting event recognizing startups transforming technology and the world for the better. Starting October 1st, 2024, the internet can nominate and vote for the best ventures in their city and industry. People can nominate their favorite startups until October 31st , and vote once per day per award for who they think should be Startup of The Year up to March 31st, 2025. Winners will be announced in April 2025, after a comprehensive evaluation by the HackerNoon team. Startups of The Year 2024 nominate their favorite startups until October 31st nominate their favorite startups Apart from validation from the world's greenest tech publication, all nominees get free interviews relevant to their region and industry. They will also receive curated startup-friendly packages and a free version of their very own Evergreen Tech Company News Page on HackerNoon. get free interviews startup-friendly packages startup-friendly packages Evergreen Tech Company News Evergreen Tech Company News In sum, being nominated gives you major credibility as one of the top startups globally and an expert in your industry, meaning even without winning, you still gain tons of exposure. Nominations are open - learn more here. You can nominate your company as the Startup of The Year in Sultanpur here. Nominations are open - learn more here . You can nominate your company as the Startup of The Year in Sultanpur here . here Startup of The Year in Startup of The Year in Sultanpur here here About HackerNoon’s Startups of The Year Startups of The Year 2024 is HackerNoon’s flagship community-driven event celebrating startups, technology, and the spirit of innovation. Currently in its third iteration, the prestigious Internet award recognizes and celebrates tech startups of all shapes and sizes. This year, over 150,000 entities across 4200+ cities, 6 continents, and 100+ industries will participate in a bid to be crowned the best startup of the year! Millions of votes have been cast over the past few years, and many stories have been written about these daring and rising startups. Startups of The Year 2024 Startups of The Year 2024 many stories many stories The winners will get a free interview on HackerNoon and an Evergreen Tech Company News page. free interview on HackerNoon Evergreen Tech Company News Evergreen Tech Company News Visit our FAQ page to learn more. FAQ FAQ Download our design assets here . here here Check out the Startups of The Year Merch Shop here . here here HackerNoon’s Startups of The Year is a branding opportunity unlike any other. Whether your goal is brand awareness or lead generation, HackerNoon has curated startup-friendly packages to solve your marketing challenges. startup-friendly packages startup-friendly packages Meet our sponsors: Meet our sponsors: Meet our sponsors: Wellfound: Join the #1 global, startup-focused community . At Wellfound, we're not just a job board—we're the place where top startup talent and the world's most exciting companies connect to build the future. Wellfound: Join the #1 global, startup-focused community Join the #1 global, startup-focused community Notion: Notion is trusted and loved by thousands of startups as their connected workspace—from building product roadmaps to tracking fundraising. Try Notion with unlimited AI, FREE for up to 6 months , to build and scale your company with one powerful tool. Get your offer now ! Notion: Try Notion with unlimited AI, FREE for up to 6 months Get your offer now ! Hubspot: If you’re looking for a smart CRM platform that meets the needs of small businesses, look no further than HubSpot. Seamlessly connect your data, teams and customers in one easy-to-use scalable platform that grows with your business. Get started for free . Hubspot: Get started for free Get started for free Bright Data: Startups that leverage public web data can make faster, data-driven decisions, giving them a competitive edge. With Bright Data’s scalable web data collection , businesses can grow from a small operation to an enterprise by harnessing insights at every stage. Bright Data: Bright Data’s scalable web data collection Bright Data’s scalable web data collection Algolia: Algolia NeuralSearch is the world's only AI end-to-end Search and Discovery Platform combining powerful keyword and natural language processing in a single API. Algolia: AI end-to-end Search and Discovery Platform AI end-to-end Search and Discovery Platform

Startups of The Year 2024: 3,256 Startups Nominated in Sultanpur, India

የ2024 የአመቱ ጅምር፡ 3,256 ጀማሪዎች በሱልጣንፑር፣ ህንድ ውስጥ ተመርጠዋል

2024 maran qalltawinaka: 3.256 qalltawinakaw Sultanpur, India markan sutinchatäpxi

Стартапы 2024 года: 3256 стартапаў намінаваны ў Султанпуры, Індыя

Startups del año 2024: 3256 startups nominadas en Sultanpur, India

Startups do ano 2024: 3.256 startups nomeadas en Sultanpur, India

2024 年のスタートアップ オブ ザ イヤー: インド スルタンプルで 3,256 社のスタートアップがノミネート

Startups of the Year 2024: 3,256 Startups ໄດ້ຮັບການສະເໜີຊື່ໃນ Sultanpur, India

Startup-urile anului 2024: 3.256 de startup-uri nominalizate în Sultanpur, India

2024 වසරේ ආරම්භක: 3,256 ඉන්දියාවේ සුල්තාන්පූර් හි නම් කරන ලදී

Bilawga Sanadka 2024: 3,256 Bilowga ah ayaa laga magacaabay Sultanpur, India

Стартапи године 2024: 3.256 стартапа номинованих у Султанпуру, Индија

2024 年度初创企业：印度苏丹普尔有 3,256 家初创企业获提名

Hear you not the rushing sound of the coming tempest?

THE EVIL EYE

Creating a Node.js Server With Postgres and Knex on Express

Entity Framework Core (EF Core) is an object-relational mapping (ORM) framework that allows developers to interact with databases using .NET objects. One of the essential features of EF Core is its ability to handle database migrations. Prerequisites Basic C# programming language knowledge. Basic OOPS concepts understanding This article demonstrates EF Core migrations, why they're crucial, and how to use them with an example. So, to begin: Introduction to C# C# has been around for quite some period, and it continues to develop, obtaining more enhanced features. medium.com Learning Objectives How to use EF Core migration with example. Why EF Core migrations are important Getting Started EF Core Migrations are a way of managing changes to your database schema over time. When you make changes to your database model (such as adding or removing tables or columns), you can create a migration that describes those changes. Migrations are then used to update the database schema to match the new model. Why Are EF Core Migrations Important? EF Core Migrations are essential because they allow you to evolve your database schema over time while preserving data. Without migrations, you would have to manually modify your database schema every time you make changes to your model, which can be time-consuming and error-prone. Migrations also provide a way to version your database schema so that you can easily track changes and roll back to previous versions if needed. How to Use EF Core Migrations? To use EF Core Migrations, you'll need to follow a few steps: Create a new EF Core project. The first step is to create a new EF Core project in Visual Studio. You can do this by selecting "Create a new project", and then selecting "ASP.NET Core Web Application" and choosing the "Web Application (Model-View-Controller)" template. Create a database context. The next step is to create a database context class. This class manages interactions between your .NET objects and the database. To create a database context, create a new class in your project and inherit it from the DbContext class. public class MyDbContext : DbContext
{
    public MyDbContext(DbContextOptions<MyDbContext> options)
        : base(options)
    {
    }
} Create a Database Model After creating a database context, you'll need to create a database model. This model represents the structure of your database and is used by EF Core to generate database tables and columns. To create a database model, create a new class in your project, and define its properties as database fields. public class MyModel
{
    public int Id { get; set; }
    public string Name { get; set; }
    public int Age { get; set; }
} Enable EF Core Migrations Next, you need to enable EF Core Migrations in your project. To do this, open the Package Manager Console, and enter the following command: PM> Install-Package Microsoft.EntityFrameworkCore.Tools This package contains the tools needed to create and manage EF Core Migrations. Create a Migration With EF Core Migrations enabled, you can create your first migration. To create a migration, open the Package Manager Console, and enter the following command: PM> Add-Migration InitialCreate This will create a new migration called "InitialCreate" that describes the changes you've made to your database model. You can view the contents of the migration in the "Migrations" folder of your project. Update the Database After creating a migration, you can update the database schema to match the new model. To do this, open the Package Manager Console, and enter the following command: PM> Update-Database This will apply the migration to the database and update its schema. Example Let's look at an example of using EF Core Migrations. Suppose we want to create a simple "Students" table with two columns: "Id" and "Name". We'll start by creating a new ASP.NET Core Web Application project in Visual Studio. Create a new EF Core project. Create a new ASP.NET Core Web Application project in Visual Studio. Select the "Web Application (Model-View-Controller)" template, and choose "Individual User Accounts" for Authentication. Name the project "EFCoreMigrationsExample". Create a database context. Create a new class called "MyDbContext" in the project's "Models" folder, and inherit it from the DbContext class. using Microsoft.EntityFrameworkCore;
namespace EFCoreMigrationsExample.Models
{
    public class MyDbContext : DbContext
    {
        public MyDbContext(DbContextOptions<MyDbContext> options)
            : base(options)
        {
        }
        public DbSet<Student> Students { get; set; }
    }
} The "Students" property is a DbSet representing our database's "Students" table. Create a Database Model Create a new "Student" class in the project's "Models" folder, and define its properties. namespace EFCoreMigrationsExample.Models
{
    public class Student
    {
        public int Id { get; set; }
        public string Name { get; set; }
    }
} Enable EF Core Migrations Open the Package Manager Console and enter the following command to install the EF Core tools package: PM> Install-Package Microsoft.EntityFrameworkCore.Tools Create a Migration Open the Package Manager Console, and enter the following command to create a migration: PM> Add-Migration InitialCreate This will create a new migration called "InitialCreate" that describes the changes we've made to our database model. The migration file should look like this: using Microsoft.EntityFrameworkCore.Migrations;
namespace EFCoreMigrationsExample.Migrations
{
    public partial class InitialCreate : Migration
    {
        protected override void Up(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.CreateTable(
                name: "Students",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    Name = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Students", x => x.Id);
                });
        }
        protected override void Down(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.DropTable(
                name: "Students");
        }
    }
} The migration creates a new table called "Students" with columns for "Id" and "Name". Update the database Open the Package Manager Console, and enter the following command to update the database schema: PM> Update-Database This will apply the migration to the database and update its schema. Now we can add, update, and delete students in our database using EF Core. For example, we can add a new student to the database like this: using EFCoreMigrationsExample.Models;

namespace EFCoreMigrationsExample.Controllers
{
    public class HomeController : Controller
    {
        private readonly MyDbContext _context;
        public HomeController(MyDbContext context)
        {
            _context = context;
        }
        public IActionResult Index()
        {
            var student = new Student
            {
                Name = "John"
            };
            _context.Students.Add(student);
            _context.SaveChanges();
            return View();
        }
    }
} This code creates a new instance of the Student class and sets its Name property to "John". It then adds the student to the Students DbSet and saves changes to the database. Conclusion EF Core Migrations provide a convenient way to manage database schema changes in your application. This article shows how to create a simple database schema using EF Core migrations, including creating a DbContext, defining a model, making a migration, and updating the database schema. This is just the beginning of what EF Core can do. You can use EF Core to query and manipulate data, create complex relationships between tables, and more. With its ease of use and wide range of features, EF Core is an excellent choice for building data-driven applications in .NET. This article has helped get you started with EF Core migrations. If you have any questions or comments, please leave them below. Happy coding! Follow Me On , , , , C# Publication LinkedIn Instagram Twitter Dev.to Also published here

EF Core Migrations: A Step-by-Step Guide to Get Started

EF কোর মাইগ্রেশন: শুরু করার জন্য একটি ধাপে ধাপে নির্দেশিকা

EF Core-Migrationen: Eine Schritt-für-Schritt-Anleitung für den Einstieg

Migraciones de EF Core: una guía paso a paso para comenzar

Migrations EF Core : un guide étape par étape pour démarrer

EF कोर माइग्रेशन: आरंभ करने के लिए चरण-दर-चरण मार्गदर्शिका

EF Core の移行: 開始するためのステップバイステップ ガイド

EF Core 마이그레이션: 시작을 위한 단계별 가이드

Migrações do EF Core: um guia passo a passo para começar

EF Temel Geçişleri: Başlamak İçin Adım Adım Kılavuz

EF Core Migration: Hướng dẫn từng bước để bắt đầu

EF Core 迁移：入门分步指南

Entity Framework Core (EF Core) is an object-relational mapping (ORM) framework that allows developers to interact with databases using .NET objects. One of the essential features of EF Core is its ability to handle database migrations. Prerequisites Basic C# programming language knowledge. Basic OOPS concepts understanding This article demonstrates EF Core migrations, why they're crucial, and how to use them with an example. So, to begin with, C#: Introduction to C# C# has been around for quite some period, and it continues to develop, obtaining more enhanced features. Learning Objectives How to use EF Core migration with an example. Why EF Core migrations are important. Getting Started EF Core Migrations are a way of managing changes to your database schema over time. When you make changes to your database model (such as adding or removing tables or columns), you can create a migration that describes those changes. Migrations are then used to update the database schema to match the new model. Why Are EF Core Migrations Important? EF Core Migrations are essential because they allow you to evolve your database schema over time while preserving data. Without migrations, you would have to manually modify your database schema every time you make changes to your model, which can be time-consuming and error-prone. Migrations also provide a way to version your database schema so that you can easily track changes and roll back to previous versions if needed. How to Use EF Core Migrations? To use EF Core Migrations, you'll need to follow a few steps: Create a new EF Core project. The first step is to create a new EF Core project in Visual Studio. You can do this by selecting "Create a new project" and then selecting "ASP.NET Core Web Application" and choosing the "Web Application (Model-View-Controller)" template. Create a database context. The next step is to create a database context class. This class manages interactions between your .NET objects and the database. To create a database context, create a new class in your project and inherit it from the DbContext class. public class MyDbContext : DbContext
{
    public MyDbContext(DbContextOptions<MyDbContext> options)
        : base(options)
    {
    }
} Create a database model. After creating a database context, you'll need to create a database model. This model represents the structure of your database and is used by EF Core to generate database tables and columns. To create a database model, create a new class in your project and define its properties as database fields. public class MyModel
{
    public int Id { get; set; }
    public string Name { get; set; }
    public int Age { get; set; }
} Enable EF Core Migrations. Next, you need to enable EF Core Migrations in your project. To do this, open the Package Manager Console and enter the following command: PM> Install-Package Microsoft.EntityFrameworkCore.Tools This package contains the tools needed to create and manage EF Core Migrations. Create a migration. With EF Core Migrations enabled, you can create your first migration. To create a migration, open the Package Manager Console and enter the following command: PM> Add-Migration InitialCreate This will create a new migration called "InitialCreate" that describes the changes you've made to your database model. You can view the contents of the migration in the "Migrations" folder of your project. Update the database. After creating a migration, you can update the database schema to match the new model. To do this, open the Package Manager Console, and enter the following command: PM> Update-Database This will apply the migration to the database and update its schema. Example Let's look at an example of using EF Core Migrations. Suppose we want to create a simple "Students" table with two columns: "Id" and "Name". We'll start by creating a new ASP.NET Core Web Application project in Visual Studio. Create a new EF Core project. Create a new ASP.NET Core Web Application project in Visual Studio. Select the "Web Application (Model-View-Controller)" template, and choose "Individual User Accounts" for Authentication. Name the project "EFCoreMigrationsExample". Create a database context. Create a new class called "MyDbContext" in the project's "Models" folder, and inherit it from the DbContext class. using Microsoft.EntityFrameworkCore;
namespace EFCoreMigrationsExample.Models
{
    public class MyDbContext : DbContext
    {
        public MyDbContext(DbContextOptions<MyDbContext> options)
            : base(options)
        {
        }
        public DbSet<Student> Students { get; set; }
    }
} The "Students" property is a DbSet representing our database's "Students" table. Create a database model. Create a new "Student" class in the project's "Models" folder, and define its properties. namespace EFCoreMigrationsExample.Models
{
    public class Student
    {
        public int Id { get; set; }
        public string Name { get; set; }
    }
} Enable EF Core Migrations. Open the Package Manager Console, and enter the following command to install the EF Core tools package: PM> Install-Package Microsoft.EntityFrameworkCore.Tools Create a migration. Open the Package Manager Console, and enter the following command to create a migration: PM> Add-Migration InitialCreate This will create a new migration called "InitialCreate" that describes the changes we've made to our database model. The migration file should look like this: using Microsoft.EntityFrameworkCore.Migrations;
namespace EFCoreMigrationsExample.Migrations
{
    public partial class InitialCreate : Migration
    {
        protected override void Up(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.CreateTable(
                name: "Students",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    Name = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Students", x => x.Id);
                });
        }
        protected override void Down(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.DropTable(
                name: "Students");
        }
    }
} The migration creates a new table called "Students" with columns for "Id" and "Name". Update the database. Open the Package Manager Console, and enter the following command to update the database schema: PM> Update-Database This will apply the migration to the database, and update its schema. Now we can add, update, and delete students in our database using EF Core. For example, we can add a new student to the database like this: using EFCoreMigrationsExample.Models;

namespace EFCoreMigrationsExample.Controllers
{
    public class HomeController : Controller
    {
        private readonly MyDbContext _context;
        public HomeController(MyDbContext context)
        {
            _context = context;
        }
        public IActionResult Index()
        {
            var student = new Student
            {
                Name = "John"
            };
            _context.Students.Add(student);
            _context.SaveChanges();
            return View();
        }
    }
} This code creates a new instance of the Student class and sets its Name property to "John". It then adds the student to the Students DbSet and saves changes to the database. Conclusion EF Core Migrations provide a convenient way to manage database schema changes in your application. This article shows how to create a simple database schema using EF Core migrations, including creating a DbContext, defining a model, making a migration, and updating the database schema. This is just the beginning of what EF Core can do. You can use EF Core to query and manipulate data, create complex relationships between tables, and more. With its ease of use and wide range of features, EF Core is an excellent choice for building data-driven applications in .NET. This article has helped get you started with EF Core migrations. If you have any questions or comments, please leave them below. Happy coding! Follow me on , , , , , C# Publication LinkedIn Instagram Twitter Dev.to BuyMeACoffee Also published here

An Easy Guide to Learn EF Core Migrations

In previous articles ( and ), I described the problem of seamless deployment of applications written in Django, namely the break of code consistency and database structure when performing migrations before changing the code, and the process of alternate changes to the code in each container on production. There is one more simple case of deployment to production in a few steps. This is table/model removal. A Beginner's Guide to Deploying Django Model Changes to Production Deleting a Column from a Django Model on Production Removing a Table on Production The process of removing a table is similar to the one of removing a column, and it consists of the same steps that depend on features in each case: CD Performing post-deployment migrations to all pods in one deployment. Performing migrations with the second deployment immediately after the first one in which the code was deployed. Performing migrations with a separate deployment after deploying the code, but with a possible delay and even other deployments. Migration at the End If migrations are performed after the code is deployed, then the following will happen: The whole code is replaced on production. The new code does not contain any requests to the table that are being deleted because the model has been deleted. However, the table is still in the database. After the code has been completely replaced with the new one, migration is performed during which the already-unused table is deleted. It appears that during deployment, there is no chance that something can break due to model removal. With such a CD, nothing else needs to be done. Migration After Code This case suggests performing a migration before deploying the code. The important point is that it is possible to perform two deployments sequentially one right after another. In this case, the standard preparation for removing a model with a division into two deployments is sufficient. The first deployment is the removal of a model in the code. The second one contains the migration file, which will be executed as a result of the deployment. Migration after Code with Delay Sometimes you do not control deployments. This is a rare situation, but it happens. For example, you prepare merge requests and make a request for deployment. Meanwhile, requests are executed in turns that you do not control. That is, a considerable period of time can pass between merging to the master branch and deployments. And, just like in the previous case, you need to deploy the code to production first, and then perform the migration. It does not seem to be a big problem if migration is performed much later than the deployment of the code, but not always. Sometimes your code is merged to the master branch but your migration is not there yet. Your colleague does not know that and creates their own migration with the following command: python manage.py makemigrations Their migration is joined by the removal of the table whose model you have already deleted. This is not surprising because their code no longer has a model, but it also doesn’t have any migration yet. You are lucky if your colleague is careful and your team has a code review, and everything is reliable. Then they can manually remove the code or merge it to their new master or your branch. However, the situation can be different, and then you are the one responsible for your unfinished deployment. In this case, you can use a scheme in which the second deployment with migration may not depend on what happens in the interval and may not affect it. In fact, this scheme is a little more reliable than the previous one. Then you need to do everything you did in the previous step, but tell Django that you do not need to add a migration to delete the table. To do this, a fake migration is performed in the first step, which, as in the case of removing the column, does not remove the table. With the second deployment, you will need to delete the table using raw SQL. Example The simplest model class MyModel(models.Model):
    name = models.CharField(max_length=100) Delete this model and perform the following: python manage.py makemigrations As a result, you will get a file with migration: operations = [
    migrations.DeleteModel(
        name='MyModel',
    ),
] If you perform this migration before the code is replaced, then the request to the model will cause an error. The first and the second cases end here. According to the second scenario, first, you need to deploy the code for removing a model, and then perform the migration. The first case suggests both changes in one deployment. For the third case, you replace the migration code with: operations = [
    migrations.RunSQL(
        sql=migrations.RunSQL.noop,
        reverse_sql=migrations.RunSQL.noop,
        state_operations=[
            migrations.DeleteModel(
                name='MyModel',
            ),
        ]
    )
] Here, using , we have informed Django that we will do everything ourselves in the database, and it is only needed to write that the removed table is no longer there. This migration will not change anything in the database, that’s why it is deployed along with the code. state_operations Now, we do not have to worry that before a table is deleted, someone will face the inconsistency of the database and code or will have to resolve other people’s migrations in their code. The second migration will contain the following code: operations = [
    migrations.RunSQL(
        sql='DROP TABLE IF EXISTS "droptable_mymodel"',
        reverse_sql=migrations.RunSQL.noop,
    )
] Even if the second deployment containing this migration takes a very long time and before it is finished, someone updates their code to the master branch, nothing bad will happen. However, the latter option is rarely used. Firstly, it's complex. Secondly, it rarely happens that deploying several versions in a row can cause a problem. Thirdly, you can always ask your team to be careful as an inconsistent release is being deployed. Therefore, the second approach is the most common.

Stories, News & Mentions about DROPT

Dropt’s Stories on HackerNoon

Dropt's News & Mentions