Modern Apps Live!

LW28 Data Access and SQL Server

03/12/14

2:45pm - 4:00pm

Level: Intermediate

Steve Hughes

Steve Hughes

Business Intelligence Architect

Pragmatic Works

Dave Stienessen

National Lead Solutions Architect

Magenic

An application's business layer requires data to function, and that means having a data access layer and a database. These two must work together to provide performant, scalable, and efficient access to the application's data. In this session you'll hear developer and database expert viewpoints on the pros and cons of using Entity Framework, stored procedures, index and key optimization, query optimization, and more. You'll learn the trade-offs between the various options, and how to minimize the impact of any specific choice by abstracting the data access code from the rest of the application.