Various Domain modelling approaches in Entity Framework

Various Domain modelling approaches in Entity Framework

05 Apr 2024
Intermediate
56.8K Views
3 min read

A business domain is populated with related and interconnected entities which have its own properties and behavior. Most important thing is that each entity may have a state and can be bound to a possibly dynamic list of validation rules. EF allow developers to focus on the business domain and to model it in terms of classes.

Domain modelling approaches

There are three approaches of domain modelling which was introduced with Entity Framework 4.1

  1. Code First

  2. Model First

  3. Database first

Code First

Code first is the domain modelling approach in Entity Framework. It enables you to describe a model by using C# or VB.NET classes and then create database from these classes. These classes are called POCO classes.

This approach enables us to work entirely in an object-oriented direction, and not worry about the structure of the database. This abstraction allow us to make a more logically and flexible application that focuses on the behaviour of the application rather than the database generated by it.

Advantages of Code First

  1. It is very popular approach since it allow you to make a more logically and flexible application.

  2. It provides full control over the code since there is no auto generated code which is hard to modify.

  3. In this approach, your code defines only the database mappings and EF will handle creation of database with its relations.

  4. Manual changes to database schema is not preferable because your code defines the database.

  5. You can also use Code first to map your model to an existing database.

Model First

Model first is the domain modelling approach in Entity Framework. It enables you to create model’s Entities, relationships, and inheritance hierarchies on the design surface of empty model (.edmx file) by using entity designer and then create database from it. This approach is adopted by the architect and solution lead developers.

In Model First approach, while creating Entity Data Model, you must select the option “Empty Model” instead of "Generate from database" option.

Advantage of Model First

  1. It is good if you like to visualize the structure of the data in the application or you don't like writing code or SQL since it will generate for you.

  2. In this approach you have no much control over your entities (auto generated code which is hard to modify) and database. In this way it is rarely used but for small easy projects this approach will be very productive.

  3. To add extra features in POCO entities you must either T4 modify template or use partial classes.

  4. Manual changes to database schema is not preferable because your model defines the database.

Database First

Database first is the domain modelling approach in Entity Framework. It enables you to create model from an existing database (like SQL Server, Oracle, DB2 etc.). This approach reduces the amount of code that we need to write since it automatically generates code. But it also limits us to work with the structure of the generated code.

Advantage of Database First

  1. Very popular if you have Database designed by DBAs, developed separately or if you have existing Database.

  2. EDM wizard creates entities, relationships, and inheritance hierarchies for you. After modification of mapping, you can also generate POCO class entities.

  3. To add extra features in POCO entities you must either T4 modify template or use partial classes.

  4. Manual changes to the database are possible because the database defines your domain model. You can always update model from database.

What do you think?

I hope you will enjoy the domain modeling approaches while programming with EF. I would like to have feedback from my blog readers. Your valuable feedback, question, or comments about this article are always welcome.

Share Article

Live Classes Schedule

Our learn-by-building-project method enables you to build practical/coding experience that sticks. 95% of our learners say they have confidence and remember more when they learn by building real world projects.
ASP.NET Core Certification Training May 26 SAT, SUN
Filling Fast
08:30PM to 10:30PM (IST)
Get Details
ASP.NET Core Certification Training Jun 21 MON, WED, FRI
Filling Fast
07:00AM to 08:30AM (IST)
Get Details
Azure Developer Certification Training Jun 23 SAT, SUN
Filling Fast
10:00AM to 12:00PM (IST)
Get Details

Can't find convenient schedule? Let us know

About Author
Shailendra Chauhan (Microsoft MVP, Founder & CEO at Scholarhat by DotNetTricks)

Shailendra Chauhan is the Founder and CEO at ScholarHat by DotNetTricks which is a brand when it comes to e-Learning. He provides training and consultation over an array of technologies like Cloud, .NET, Angular, React, Node, Microservices, Containers and Mobile Apps development. He has been awarded Microsoft MVP 8th time in a row (2016-2023). He has changed many lives with his writings and unique training programs. He has a number of most sought-after books to his name which has helped job aspirants in cracking tough interviews with ease.
Accept cookies & close this