Entity Framework Database Performance Anti-patterns
Pluralsight
Course Summary
Coding practices to avoid or replace that can and will have an immediate impact on performance in your Entity Framework applications.
-
+
Course Description
Entity framework is one of the most popular ORMs in software development, but it does not yet have a great reputation among SQL Server database professionals, especially those responsible for server performance. This collection of modules will identify some of the most common "real world" code smells and anti-patterns that keep EF-based applications from reaching optimal performance from the perspective of the SQL Server database. Many of these concepts could also apply to other relational data sources that Entity Framework is compatible with.
-
+
Course Syllabus
Entity Framework Database Performance Anti-patterns - Intro- 11m 11s
—Intro to Query Optimization 2m 48s
—Intro to Query Abstraction 1m 16s
—Course Overview 1m 11s
—Why ORMs 4m 50s
—Summary 1m 5sToo Much Data- 16m 20s
—Intro 1m 1s
—Page Life Expectancy 1m 58s
—IO Latency 1m 46s
—Poor Index Selection 1m 51s
—Anti-pattern: Too Much Data 2m 58s
—Solution: Filter on the Server 2m 17s
—Solution: Use Projection 2m 32s
—Summary 1m 54sNon Set-based Work- 18m 20sSize Matters- 23m 24sLazy Loading- 16m 33sDeciphering Abstraction- 13m 39sMiscellaneous Items- 20m 12s