Entity Framework Best Practices - Should EFCore Be Your Data Access of Choice?
Why Stack Overflow recommends it
Stack Overflow users link it to back up claims about nvarchar(max) performance, EF Core's use of sp_executesql, and as a learning resource when setting up an EF-based data access layer.
Recommended by 1 people across 1 different months, 2020 to 2025.
What it is
A long tutorial by Tim Corey (IAmTimCorey) on Entity Framework and EF Core best practices, walking through project setup, migrations, model snapshots, nvarchar sizing, and the pitfalls that lead him to avoid EF Core. It is built as a live coding walkthrough with a chapter breakdown.
What people said
Recommends A dude · 2025-05 · Stack Overflow · on “sql server data fields nvchar(x) or nvarchar(max)”
TL:DR nvarchar(max) is inefficient and should be avoided. Queries against an nvarchar(max) field use more kb than queries against an nvarchar(10) field, even if the data stored within the two fields is the same. So the performance will be noticably and measurably worse, which should be avoided. At 47 minutes Tim Corey provides a pretty good explanation of this, complete with outside sources: [this video] .
Cites Jeff Nichols · 2020-04 · Stack Overflow · on “C# Winforms projects with Entity Framework as DAL - which .NET?”
I'm an experienced php developer and am attempting my hand at learning Microsoft Entity Framework. My backend Database is Oracle and I'm using ODP.Net as my connection. I've installed VS2019 Community and am working through several tutorials. Oracle Entity Framework Core Introduction [LINK] Entity Framework Best Practices [this video] Microsoft Create a Data Access Layer [LINK] EntityFrameworkCore [LINK] I'm struggling with trying to have my C# library (DAL) work well with my C# winforms projects. My DAL is a .NET Standard 2.0 project and my winforms projects is .NET Framework 4.7.2. My solution is setup as follows. C# Solution Project 1 - C# Library (DAL) - .NET Standard 2.0 Nuget Dependencies M
Cites Muroxxas · 2021-12 · Stack Overflow · on “Can Entity Framework execute stored procedures without access to sp_executesql?”
Good day all, I have inherited multiple desktop applications which have a heavy reliance upon stored procedures for data operations. These apps were written in VB6, and I am currently attempting to figure out how to port them to .Net 5 or .Net 6. I understand that Entity Framework Core is capable of executing stored procedures. However, in a video I watched recently [this video] , I came to understand that Entity Framework Core executes data functions via the stored procedure sp_executesql, to allow for execution of whatever procedure a developer may have dynamically generated. However, as the video linked above mentions, this presents a security hole for desktop applications. To fire sp_executes