5 EF Core Features You Need to Know

By /

Featured Image
Entity Framework Core (EF Core) is a powerful ORM for .NET developers, offering advanced database operations with minimal code. Below are five essential EF Core features along with practical examples and commands.

1. Query Splitting

Splits JOINs into multiple queries to improve performance.

Example:

var blogs = context.Blogs 
.Include(blog => blog.Posts) 
.AsSplitQuery() 
.ToList();

2. Bulk Updates

Efficiently updates multiple records without loading them into memory.

Example:

context.Products 
.Where(p => p.Price < 50) 
.ExecuteUpdate(p => p.SetProperty(x => x.Price, x => x.Price  1.1));

3. Raw SQL Queries

Execute custom SQL while still mapping results to entities.

Example:

var blogs = context.Blogs 
.FromSqlRaw("SELECT  FROM Blogs WHERE Rating > 5") 
.ToList();

4. Bulk Deletes

Deletes records in bulk without loading them.

Example:

context.Products 
.Where(p => p.IsExpired) 
.ExecuteDelete();

5. Ignoring Query Filters

Bypasses global query filters when needed.

Example:

var blogs = context.Blogs 
.IgnoreQueryFilters() 
.ToList();

Bonus: More EF Core features here.

You Should Know:

EF Core CLI Commands

  • Migrations:
    dotnet ef migrations add InitialCreate 
dotnet ef database update
  • Scaffolding a DB:
    dotnet ef dbcontext scaffold "Server=.;Database=TestDB;Trusted_Connection=True;" Microsoft.EntityFrameworkCore.SqlServer

Performance Tips

  • Use `AsNoTracking()` for read-only queries.
  • Avoid `N+1` queries with proper `Include` statements.

Linux/Windows Commands for DB Management

  • PostgreSQL (Linux):
    sudo systemctl status postgresql 
psql -U username -d dbname
  • SQL Server (Windows):
    sqlcmd -S localhost -U sa -P your_password

What Undercode Say:

EF Core simplifies database interactions but requires optimization for large-scale apps. Always:
– Benchmark queries.
– Use indexes wisely.
– Monitor SQL generated via logging.

Expected Output:

A high-performance .NET application leveraging EF Core’s full potential with optimized queries and bulk operations.

Prediction:

EF Core will continue evolving with more performance enhancements and cloud-native integrations, making it a staple for .NET microservices.

References:

Reported By: Milan Jovanovic – Hackers Feeds
Extra Hub: Undercode MoN
Basic Verification: Pass ✅

Join Our Cyber World:

💬 Whatsapp | 💬 Telegram

Related Posts: