A Database Developer and DBA Perspective: LINQ to SQL and Entity Framework vs. Stored Procedures

Date: June 9, 2010 from 8:45AM to 10:00AM
Day 3
DAT301
Speakers: Bob Beauchemin
Avg Rating: 0
521 Views
reddit

Tweet

format
< > embed
+ queue

Sign In first to access your queue.
Close

Sorry, video was not added to the queue, an error occurred. Please Contact Us and let us know.
Close

Embed code for this video

Copy the code above to embed our video on your website/blog.

Video format

Option selected may change based on video formats available and browser capability.

Auto
Use our suggested format for this video.
Smooth Streaming
Adaptive bitrate streaming - little buffering but lower video quality at times of low bandwidth. Silverlight 5 required
Progressive
Traditional buffered video format. Silverlight 5 required
HTML5
For browsers that support H.264 MP4 or WebM video playback such as:
IE9+, Firefox 4+, Chrome 5+, or Safari 4+.
Flash
For browsers that have the Adobe Flash Player plugin installed.

Download

Right click “Save as…”

Slides (view online)

High Quality MP4 (iPad, PC)

File size
36.8 MB
Mid Quality WMV (Lo-band, Mobile)

File size
84.6 MB
High Quality WMV (PC, Xbox, MCE)

File size
224.4 MB

This session covers the performance implications of using two new Microsoft data access frameworks. We look at the good, the bad, and the ugly aspects of code generation with the frameworks using SQL Profiler, plan cache monitoring, and query plans. We cover what the frameworks bring to the table when compared to using T-SQL stored procedures or using dynamic SQL and the obvious benefits to the application programmer. T-SQL code generation enhancements in Microsoft .NET Framework 4.0 versions of Entity Framework and Linq to SQL are also explored.