Level: Intermediate
Steve Hughes
Business Intelligence Architect
Pragmatic Works
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.
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.