LuisLlamas Logo
EN
entity-framework-code-first-y-data-first

Code First and Data First Approaches in Entity Framework

  • 3 min
  • Beginner

As we saw in the introduction, in Entity Framework there are two main approaches to configure and manage a database:

  • Data-First: First, we create the database.
  • Code-First: First, we create the classes.

These methods define the workflow. In particular, how we will generate and synchronize the application classes and the database schema.

The first decision we will have to make in a project with Entity Framework is whether we want to work with one or the other.

You must choose one or the other. They are not compatible, nor something we can change midway through the project (at least not easily).

In general, the more “modern” option is Code First. However, in reality, both have their advantages, disadvantages, and specific use cases.

In this article, we are going to compare both approaches, their workflows, and when it is more convenient to use them 👇.

What is Data-First?

The Data-First approach (or Database-First) means starting development from an already existing database.

With Data-First,

  • We manually create 🖐 the database.
  • We automatically generate 🤖 the application classes.

This approach is useful when working with a database that has already been designed or in projects where the database structure is imposed or managed by a separate team.

Data-First Steps in Entity Framework Core

  1. Define the database: The structure of the database, with its tables, relationships, and constraints, must be previously defined.
  2. Generate the model: Entity Framework Core allows for the automatic creation of C# classes from the database schema using the Scaffold-DbContext command.
  3. Automatic mapping: The ORM generates the necessary classes and automatically establishes the mappings between the database and C# objects.

What is Code-First?

The Code-First approach is the “opposite case.” It allows us to define the models and classes in the code first, and then automatically generate or update the database based on these models.

With Code-First,

  • We manually create 🖐 the application classes
  • We automatically generate 🤖 the database.

With Code-First, the C# code defines the structure of the database. This gives us greater control over the classes, relationships, and constraints of the database.

Code-First Steps in Entity Framework Core

  1. Define the classes in C#: Entities and their relationships are created using classes and properties, utilizing data annotations or configurations in the code.
  2. Create the migrations: With the Add-Migration command, the necessary migrations are generated to create or update the database schema based on changes in the classes.
  3. Update the database: By executing the Update-Database command, the migrations are applied to the database, synchronizing the structure with the class model.

At first, it feels a bit dizzying that someone “tweaks” the database automatically.

Don’t worry, it’s normal; it has happened to all of us (and it still happens).

When to Use Data-First and When to Use Code-First?

So, when should you use one or the other? Generally, it will depend on the context, the type of project, and even the preferences of the team.

But, in general,

  • Data-First is ideal for projects where the database already exists and has a defined structure.
  • Code-First is preferable for new projects or where the development team has complete control over the data model and the evolution of the database.

On this page