How to Add a Database Connection in Entity Framework: A Step-by-Step Guide

 Entity Framework (EF) is a popular Object-Relational Mapper (ORM) for .NET applications, making it easier to interact with databases using .NET objects. Whether you’re using the modern Entity Framework Core or the classic Entity Framework 6 (EF6), setting up a database connection is a foundational step. This guide walks you through the process for both versions, ensuring you can get your application connected to a database quickly and securely.

1. Install Required NuGet Packages

Before you start, ensure your project includes the necessary EF Core Packages. For SQL Server, you'll typically need: 

• Microsoft.EntityFrameworkCore
• Microsoft.EntityFrameworkCore.SqlServer

You can install these via the NuGet Package Manager or using the Package Manager Console:

2. Add Your Connection String

Store your database connection string in appsettings.json for easy management and security:

3. Configure Db Context

First, we have to create a class inherited from DbContext and add constructor in it as shown below

Now we need to register our service in Program.cs using below syntax

Conclusion

Connecting your application to a database using Entity Framework is straightforward once you know where to place your connection string and how to configure your DbContext.

With these steps, you’re ready to start building data-driven .NET applications with Entity Framework!