Using EF Core - Power Tools In ASP.NET Core API

Introduction

In this article we are going to learn the EF - Core Power Tools basically the new version of EF Core is pretty simple to use like Entity Data model which we are already used in .NET Framework and this EF Core Power Tools help in the development process. Let's go deep into this.

What are EF Core Power Tools?

EF Core Power Tools is the most powerful extension. It provides a lot of options like Reverse Engineer to generate the Entity classes based database tables and also to generate the Model Diagram. It also helps with the Migration of Existing Scripts which were developed by using the Code First Approach. EF Core Power Tools has an option to generate the DataContext Diagram and relation between the entity classes in a graphical view.

How does this tool help me?

With this tool, we can take an existing Database and perform a Reverse Engineer, which means generating all classes from your existing database.

What is Reverse Engineer in EF Core - Power Tools?

Reverse Engineer acts like Entity Data Model, where it generates the tables of our database as Entity Classes in the code and also Db Context class bases upon our Database.

Link to Download ->  EF Core Power Tools

Make Sure you have at least Visual Studio 2017 installed on your machine to work with EF Core.

After downloading, Click, and install. But don't forget to restart Visual Studio to complete the installation

Create a Project -> Open Visual Studio there you will find an option called Create a new project -> Click on that

-> Select  ASP.NET Core Web Application -> Click on the Next button.

-> Give the Project Name and click on Create.

-> Select the Version of ASP.NET Core 3.1 along with  API and click on Create.

A sample project with API Structure will be created.

Right Click on Project there you will find an option installed, EF Core Power Tools

Step 1

Click on Reverse Engineer there you will find the Db Connection Option.

Step 2


Click on Add to connect with Database Server

Step 3


  1. Provide the SQL Server name in the Text Box and find whether you are using Windows or SQL Authentication.

  2. Select the Database Under the Select or enter the database. 

  3. Click on Test Connection to check where the connection is configured in a proper way.

  4. Click on OK.


Step 4


That's done! The Connection with the database will show in the selected DropDown  -> Click on OK.

Step 5


Select the Tables which you want to include in your project and click on OK.

Step 6


By default, it will add the DB name as Context name you can change if you want and also it will select Entity types & DbContext by default

-> Click on OK.

You will get a confirmation, as shown below.


Finally... The model Classes with Db Context have been generated automatically. This is how simple it is to work with EF Core Power Tools.

Source Code from GitHub

Summary

In this article, learned about the integration and usage of EF Core Power Tools in ASP.NET Core Web API. 

I hope this article helps you.

Keep Learning...!


Source: C#Corner