Syllabus

ASP.NET Core Complete Tutorial (ShopNest)

Module 1: Foundations
What is ASP.NET Core? Complete Guide Setting Up ASP.NET Core Development Environment ASP.NET Core Project Structure Explained MVC Architecture in ASP.NET Core — Complete Guide Controllers and Actions in ASP.NET Core Routing in ASP.NET Core — Conventional and Attribute Routing Views and Razor Syntax in ASP.NET Core Layouts, Partial Views and View Components Models and ViewModels in ASP.NET Core Forms, Model Binding and Validation in ASP.NET Core Tag Helpers in ASP.NET Core — Complete Guide Static Files, Bundling and Minification in ASP.NET Core
Module 2: Entity Framework Core
Entity Framework Core — Introduction and Setup EF Core Code First — Models, Migrations, Database EF Core CRUD Operations — Create, Read, Update, Delete EF Core LINQ Queries — Beginner to Advanced EF Core Relationships — One-to-One, One-to-Many, Many-to-Many EF Core Fluent API — Advanced Configuration EF Core Repository Pattern and Unit of Work EF Core Performance Optimization Database First Approach with EF Core (Scaffold) EF Core with SQL Server — Advanced Features
Module 3: Dependency Injection & Middleware
Dependency Injection in ASP.NET Core — Complete Guide Middleware in ASP.NET Core — Complete Guide Configuration in ASP.NET Core — appsettings, Environment Variables, Secrets Filters in ASP.NET Core — Action, Authorization, Exception, Resource, Result Logging in ASP.NET Core — ILogger, Serilog, NLog Error Handling and Exception Management in ASP.NET Core
Module 4: Authentication & Security
ASP.NET Core Identity — Complete Setup Guide Authentication in ASP.NET Core — Cookie and JWT Authorization in ASP.NET Core — Roles, Policies, Claims JWT Authentication with Refresh Tokens — Complete Implementation OAuth2 and External Login (Google, Facebook, Microsoft) Data Protection and Encryption in ASP.NET Core HTTPS, SSL Certificates and Security Best Practices
Module 5: Web API
Building REST APIs with ASP.NET Core — Complete Guide API Versioning in ASP.NET Core Swagger / OpenAPI Documentation in ASP.NET Core Input Validation in Web APIs — FluentValidation and Data Annotations Pagination, Filtering and Sorting in ASP.NET Core APIs HTTP Client and Consuming External APIs in ASP.NET Core Minimal APIs in ASP.NET Core .NET 8 SignalR — Real-Time Web Applications
Module 6: Advanced Architecture
Clean Architecture in ASP.NET Core CQRS Pattern with MediatR in ASP.NET Core Repository Pattern — Deep Dive with Generic Repository Background Services and Hosted Services in ASP.NET Core Caching in ASP.NET Core — In-Memory, Distributed, Redis Health Checks in ASP.NET Core AutoMapper in ASP.NET Core Microservices with ASP.NET Core — Introduction Message Queues with RabbitMQ / Azure Service Bus in ASP.NET Core gRPC with ASP.NET Core
Module 7: Testing
Unit Testing ASP.NET Core with xUnit and Moq Integration Testing in ASP.NET Core Testing EF Core — In-Memory vs SQLite Performance Testing and Load Testing ASP.NET Core APIs Test-Driven Development (TDD) in ASP.NET Core
Module 8: Deployment & DevOps
Deploying ASP.NET Core to IIS on Windows Server Docker and Containerization for ASP.NET Core Deploying ASP.NET Core to Azure App Service CI/CD with GitHub Actions for ASP.NET Core Azure SQL Database with ASP.NET Core Environment Configuration and Secrets Management
Module 9: Real-World Projects
Build a Complete Blog Website with ASP.NET Core MVC Build an E-Commerce Product Catalog API (ASP.NET Core Web API) Build a Student Management System (Complete CRUD App) Build a Job Portal (Full Stack ASP.NET Core) Build a REST API with Clean Architecture — Complete Guide Build a Real-Time Chat App with SignalR and ASP.NET Core
Module 10: Advanced Topics
Blazor WebAssembly and Blazor Server — Complete Guide gRPC, GraphQL and Alternative API Styles in ASP.NET Core Rate Limiting and API Throttling in ASP.NET Core .NET 8 Output Caching in ASP.NET Core .NET 8 ASP.NET Core .NET 9 New Features — Complete Guide
ASP.NET Core Complete Tutorial (ShopNest)
Lesson 22 of 75 29% of course

EF Core with SQL Server — Advanced Features

1 · 5 min · 5/24/2026

Learn EF Core with SQL Server — Advanced Features in our free ASP.NET Core Complete Tutorial (ShopNest) series. Step-by-step explanations, examples, and interview tips on Toolliyo Academy.

Sign in to track progress and bookmarks.

EF Core with SQL Server — Advanced Features — ShopNest
Article 22 of 75 · Module 2: Entity Framework Core · ShopNest Financial Reporting System
Target keyword: ef core sql server advanced · Read time: ~34 min · .NET: 8 / 9 · Project: ShopNest Financial Reporting System

Introduction

ShopNest Financial Reporting needs transactions, resilient connections, JSON columns, hierarchical accounts, and multi-tenant data isolation — SQL Server features EF Core 8 exposes cleanly.

After this article you will

  • Wrap operations in explicit transactions
  • Configure connection retry policies
  • Map JSON columns and temporal tables
  • Design multi-tenant filters
  • Integrate full-text search where needed

Prerequisites

Concept deep-dive

// Explicit transaction
await using var tx = await _db.Database.BeginTransactionAsync();
try
{
    _db.LedgerEntries.Add(debit);
    _db.LedgerEntries.Add(credit);
    await _db.SaveChangesAsync();
    await tx.CommitAsync();
}
catch { await tx.RollbackAsync(); throw; }

// Connection resiliency (Program.cs)
options.UseSqlServer(connectionString, sql =>
    sql.EnableRetryOnFailure(maxRetryCount: 5));

// JSON column (.NET 8 + SQL Server)
public class ReportSnapshot
{
    public int Id { get; set; }
    public ReportMetadata Metadata { get; set; } // mapped to nvarchar(max) JSON
}

// Global query filter — multi-tenancy
modelBuilder.Entity<Order>()
    .HasQueryFilter(o => o.TenantId == _tenantProvider.TenantId);

Temporal tables: SQL Server system-versioned tables — EF Core 8 can map history. Hierarchy: adjacency list or closure table for chart of accounts.

Hands-on — ShopNest Financial Reporting System

  1. Transfer funds service: debit/credit in one transaction.
  2. Enable retry on failure for Azure SQL transient errors.
  3. TenantId column + query filter on financial entities.
  4. Store report config as JSON owned type.

Common errors & best practices

  • Nested SaveChanges without transaction — partial updates on failure.
  • Query filter forgotten in raw SQL — tenant data leak; always filter TenantId.
  • No retry on cloud SQL — transient failures become user-visible 500s.

Interview questions

Q: When explicit transaction?
A: Multiple SaveChanges or cross-context operations must succeed or fail together.

Q: Multi-tenancy with EF?
A: Global query filter on TenantId + set TenantId on insert via interceptor.

Q: EnableRetryOnFailure?
A: Handles transient Azure SQL errors (throttling, failover) automatically.

Summary

  • Transactions ensure atomic financial transfers
  • Retry policies essential for cloud SQL Server
  • JSON columns and query filters support modern reporting
  • Temporal tables and hierarchy for audit and COA

Previous: Database First Approach with EF Core
Next: Dependency Injection in ASP.NET Core

FAQ

Does EF support SQL Server temporal tables?

EF Core 8+ has improved support; configure in Fluent API or scaffold from temporal table.

Global query filter pitfalls?

Must disable filter in admin/migration scenarios with IgnoreQueryFilters().

Interview Q&A for this course

Test your knowledge

Quizzes linked to this course—pass to earn certificates.

SOLID Design Principles — Practice Quiz
Test your understanding of SOLID Design Principles Tutorial. Single responsibility, open/c…
Intermediate 15 min
SignalR Real-Time — Practice Quiz
Test your understanding of SignalR Real-Time Tutorial. WebSockets, hubs, and live updates …
Intermediate 15 min
Microservices with .NET — Practice Quiz
Test your understanding of Microservices with .NET. Distributed systems, APIs, messaging, …
Intermediate 15 min
LINQ — Practice Quiz
Test your understanding of LINQ Tutorial. Query in-memory and database data with fluent LI…
Intermediate 15 min
Entity Framework Core — Practice Quiz
Test your understanding of Entity Framework Core Tutorial. Modern ORM: Code First, migrati…
Intermediate 15 min
Design Patterns in C# — Practice Quiz
Test your understanding of Design Patterns in C#. Creational, structural, and behavioral p…
Intermediate 15 min
Browse all quizzes
Previous Next
ASP.NET Core Complete Tutorial (ShopNest)

On this page

Introduction After this article you will Prerequisites Concept deep-dive Hands-on — ShopNest Financial Reporting System Common errors &amp; best practices Interview questions Summary FAQ Does EF support SQL Server temporal tables? Global query filter pitfalls?
Module 1: Foundations
What is ASP.NET Core? Complete Guide Setting Up ASP.NET Core Development Environment ASP.NET Core Project Structure Explained MVC Architecture in ASP.NET Core — Complete Guide Controllers and Actions in ASP.NET Core Routing in ASP.NET Core — Conventional and Attribute Routing Views and Razor Syntax in ASP.NET Core Layouts, Partial Views and View Components Models and ViewModels in ASP.NET Core Forms, Model Binding and Validation in ASP.NET Core Tag Helpers in ASP.NET Core — Complete Guide Static Files, Bundling and Minification in ASP.NET Core
Module 2: Entity Framework Core
Entity Framework Core — Introduction and Setup EF Core Code First — Models, Migrations, Database EF Core CRUD Operations — Create, Read, Update, Delete EF Core LINQ Queries — Beginner to Advanced EF Core Relationships — One-to-One, One-to-Many, Many-to-Many EF Core Fluent API — Advanced Configuration EF Core Repository Pattern and Unit of Work EF Core Performance Optimization Database First Approach with EF Core (Scaffold) EF Core with SQL Server — Advanced Features
Module 3: Dependency Injection & Middleware
Dependency Injection in ASP.NET Core — Complete Guide Middleware in ASP.NET Core — Complete Guide Configuration in ASP.NET Core — appsettings, Environment Variables, Secrets Filters in ASP.NET Core — Action, Authorization, Exception, Resource, Result Logging in ASP.NET Core — ILogger, Serilog, NLog Error Handling and Exception Management in ASP.NET Core
Module 4: Authentication & Security
ASP.NET Core Identity — Complete Setup Guide Authentication in ASP.NET Core — Cookie and JWT Authorization in ASP.NET Core — Roles, Policies, Claims JWT Authentication with Refresh Tokens — Complete Implementation OAuth2 and External Login (Google, Facebook, Microsoft) Data Protection and Encryption in ASP.NET Core HTTPS, SSL Certificates and Security Best Practices
Module 5: Web API
Building REST APIs with ASP.NET Core — Complete Guide API Versioning in ASP.NET Core Swagger / OpenAPI Documentation in ASP.NET Core Input Validation in Web APIs — FluentValidation and Data Annotations Pagination, Filtering and Sorting in ASP.NET Core APIs HTTP Client and Consuming External APIs in ASP.NET Core Minimal APIs in ASP.NET Core .NET 8 SignalR — Real-Time Web Applications
Module 6: Advanced Architecture
Clean Architecture in ASP.NET Core CQRS Pattern with MediatR in ASP.NET Core Repository Pattern — Deep Dive with Generic Repository Background Services and Hosted Services in ASP.NET Core Caching in ASP.NET Core — In-Memory, Distributed, Redis Health Checks in ASP.NET Core AutoMapper in ASP.NET Core Microservices with ASP.NET Core — Introduction Message Queues with RabbitMQ / Azure Service Bus in ASP.NET Core gRPC with ASP.NET Core
Module 7: Testing
Unit Testing ASP.NET Core with xUnit and Moq Integration Testing in ASP.NET Core Testing EF Core — In-Memory vs SQLite Performance Testing and Load Testing ASP.NET Core APIs Test-Driven Development (TDD) in ASP.NET Core
Module 8: Deployment & DevOps
Deploying ASP.NET Core to IIS on Windows Server Docker and Containerization for ASP.NET Core Deploying ASP.NET Core to Azure App Service CI/CD with GitHub Actions for ASP.NET Core Azure SQL Database with ASP.NET Core Environment Configuration and Secrets Management
Module 9: Real-World Projects
Build a Complete Blog Website with ASP.NET Core MVC Build an E-Commerce Product Catalog API (ASP.NET Core Web API) Build a Student Management System (Complete CRUD App) Build a Job Portal (Full Stack ASP.NET Core) Build a REST API with Clean Architecture — Complete Guide Build a Real-Time Chat App with SignalR and ASP.NET Core
Module 10: Advanced Topics
Blazor WebAssembly and Blazor Server — Complete Guide gRPC, GraphQL and Alternative API Styles in ASP.NET Core Rate Limiting and API Throttling in ASP.NET Core .NET 8 Output Caching in ASP.NET Core .NET 8 ASP.NET Core .NET 9 New Features — Complete Guide