Environment Setup in Entity Framework

Entity Framework (EF) is a popular Object-Relational Mapping (ORM) framework for .NET applications that allows developers to interact with databases using .NET objects instead of SQL queries. Before you start building applications with EF, you need to set up the right environment.

In this Entity Framework tutorial, we will go through a step-by-step process of installing and configuring Entity Framework in your development environment, ensuring you’re ready to build powerful data-driven applications. If you are preparing for exams or interview don't forget to bookmark these Top 50 Entity Framework Interview Questions & Answers which might be helpful for you.

Prerequisites

• .NET SDK / .NET Framework: EF Core requires .NET 6, 7, or 8 SDK. EF 6 requires .NET Framework 4.5 or later.
• Visual Studio / Visual Studio Code: Visual Studio 2022 or later, or VS Code with C# extension.
• SQL Server (or any other database): SQL Server Express, Developer Edition, or Azure SQL Database. EF Core also supports PostgreSQL, MySQL, SQLite, and Oracle.

Step 1: Install Visual Studio

Download the latest version of Visual Studio. During installation, select the .NET desktop development and ASP.NET and web development workloads. For VS Code, download from here and install the C# Dev Kit extension.

Step 2: Install SQL Server

Download SQL Server Express Edition from the Microsoft website. You can also install SQL Server Management Studio (SSMS) to manage your databases.

Alternative databases supported: SQLite, PostgreSQL, MySQL.

Step 3: Create a New Project in Visual Studio

1. Open Visual Studio
2. Click File → New → Project
3. Select Console App (.NET Core) or ASP.NET Core Web Application
4. Name your project (e.g., EFCoreDemo) and click Create

Step 4: Install Entity Framework Packages

For Entity Framework Core:

 
Install-Package Microsoft.EntityFrameworkCore
Install-Package Microsoft.EntityFrameworkCore.SqlServer
Install-Package Microsoft.EntityFrameworkCore.Tools
  

Using .NET CLI:

 
dotnet add package Microsoft.EntityFrameworkCore
dotnet add package Microsoft.EntityFrameworkCore.SqlServer
dotnet add package Microsoft.EntityFrameworkCore.Tools
  

For Entity Framework 6 (classic EF):

 
Install-Package EntityFramework
  

Step 5: Verify Installation

Check the Dependencies → NuGet section in your project. You can also run:

 
Get-Package
  

Step 6: Configure Database Connection

For .NET Core (appsettings.json):

 
{
  "ConnectionStrings": {
    "DefaultConnection": "Server=localhost;Database=EFCoreDemoDB;Trusted_Connection=True;"
  }
}
  

For .NET Framework (App.config / Web.config):

 
<connectionStrings>
  <add name="DefaultConnection" 
       connectionString="Server=localhost;Database=EF6DemoDB;Trusted_Connection=True;" 
       providerName="System.Data.SqlClient" />
</connectionStrings>
  

Step 7: Initialize Entity Framework Context

 
using Microsoft.EntityFrameworkCore;

public class AppDbContext : DbContext
{
    public DbSet<Student> Students { get; set; }

    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    {
        optionsBuilder.UseSqlServer("Server=localhost;Database=EFCoreDemoDB;Trusted_Connection=True;");
    }
}

public class Student
{
    public int Id { get; set; }
    public string Name { get; set; }
}
  

Step 8: Apply Migrations and Create Database

Using Package Manager Console:

 
Add-Migration InitialCreate
Update-Database
  

Using .NET CLI:

 
dotnet ef migrations add InitialCreate
dotnet ef database update
  

Step 9: Test the Setup

 
class Program
{
    static void Main()
    {
        using var context = new AppDbContext();

        // Insert
        context.Students.Add(new Student { Name = "John Doe" });
        context.SaveChanges();

        // Fetch
        foreach (var student in context.Students)
        {
            Console.WriteLine($"ID: {student.Id}, Name: {student.Name}");
        }
    }
}
  

Conclusion

Setting up Entity Framework is a straightforward process once you have the right prerequisites in place. By installing Visual Studio, SQL Server, and the required EF packages, configuring a connection string, and running migrations, you can quickly get started with database-driven .NET applications.

With your environment ready, you’re now prepared to dive deeper into Entity Framework features like LINQ queries, relationships, migrations, and performance optimization.

Take our Entityframework skill challenge to evaluate yourself!

In less than 5 minutes, with our skill challenge, you can identify your knowledge gaps and strengths in a given skill.

GET FREE CHALLENGE