Modern Apps Live!

MAL07 Data Access and SQL Server


10:45AM - 12:00PM

Level: Intermediate

Steve Hughes

Steve Hughes

Business Intelligence Architect

Pragmatic Works

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.