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
 
Using EF Core - Power Tools In ASP.NET Core API 
 
Click on Reverse Engineer there you will find the Db Connection Option.
 
Step 2 
 
Using EF Core - Power Tools In ASP.NET Core API  
 
Click on Add to connect with Database Server
 
Step 3 
Using EF Core - Power Tools In ASP.NET Core API
  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
 
Using EF Core - Power Tools In ASP.NET Core API
 
That's done! The Connection with the database will show in the selected DropDown  -> Click on OK.
 
Step 5
 
Using EF Core - Power Tools In ASP.NET Core API 
 
Select the Tables which you want to include in your project and click on OK.
 
Step 6
 
Using EF Core - Power Tools In ASP.NET Core API 
 
By default, it will add the DB name as Context name you can change if you want and also it will select Entitytypes & DbContext by default
 
-> Click on OK.
 
You will get a confirmation, as shown below.
 
Using EF Core - Power Tools In ASP.NET Core API 
 
Finally... The model Classes with Db Context have been generated automatically. This is how simple it is to work with EF Core Power Tools.
 
 

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...!