Issue #25: Accidental Session Management

[shadyashraf174]

Issue #25: Accidental Session Management

var posts = context.BlogPosts.ToList(); // Implicit transaction
Console.WriteLine(posts[0].Comments.Count); // Lazy loading N+1

Why It's Dangerous:

• Uncontrolled DB sessions in UI layer
• Hidden performance killers
• Violates Persistence Ignorance Principle

Forensic Evidence:

-- First query:
SELECT * FROM BlogPosts

-- Then for EACH post:
SELECT * FROM Comments WHERE BlogPostId = 1
SELECT * FROM Comments WHERE BlogPostId = 2
-- ...