Posted on 1/2/2021 11:03:22 AM by Admin

Database-First workflow in Detail

In the last two articles we have discussed, the different workflows that can be used to build domain models using Entity Framework. We have also discussed the advantages of a code-First workflow over a database-First workflow.In this workflow, we will discuss the database workflow in detail.

We will cover following topics
    • Features of EDMX designer for productivity : we will explore some useful features of EDMX designer which makes it very easy to work with large complex models.
    • Dealing with database changes : we will discuss how to deal with database changes in the most efficient way. As you add a new table to a database or delete or modify an existing one, you should know how to bring those changes back into your Entity Data Model so that your database and Entity Data Model are always in sync.
    • Connection string : here we will discuss , why does Entity Framework connection string contain meta properties and how does EF connect to database.
    • Import Stored Procedure and Functions : here we will discuss, how can we import stored procedures and Functions into our Entity Data Model and how to use them in our application.
    • working with Enums : here we will discuss, how to convert a data type to enum in our Entity Data Model and how to use Enums properly in the application.

So, let's get started with this section, I highly recommend you to go through the previous three articles before moving to the next articles.

The recommended articles are :
    • What is Entity Framework (Read here)
    • The different workflow's in EF (Read here) and
    • Comparison of Database-First approach and Code-First approach (Read here)