2015
Pluralsight
Russ Thomas
1:59
English

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.

Entity Framework Database Performance Anti-patterns - Intro
Intro to Query Optimization
Intro to Query Abstraction
Course Overview
Why ORMs
Summary
Too Much Data
Intro
Page Life Expectancy
IO Latency
Poor Index Selection
Anti-pattern: Too Much Data
Solution: Filter on the Server
Solution: Use Projection
Summary
Non Set-based Work
Intro
Set Theory and Relational Algebra
Anti-pattern: Nested LINQ
Solution: Explicit Joins
Solution: Lambda and Projection
Summary and Review
Size Matters
Intro
Code First Demonstration
Do Data Types Really Matter
Data Types vs. Indexes, Query Plans, and Memory
Helping EF Choose Appropriate Data Types
Summary and a Word About Data Integrity
Lazy Loading
Intro and Definition
Deliberate Coding
E-commerce Case Study
Deliberate Coding Demo
Environmental Factors
Summary
Deciphering Abstraction
Intro
SQL Server Profiler
DBContext ToString
Database.Log Property
Interception
Summary
Miscellaneous Items
Intro
Index Basics
Foreign Keys
Parameterization
Ad-hoc Workloads
Server Settings
Entity Framework Caches
Course Summary

Download File Size:210.67 MB

---