Pro LINQ Object Relational Mapping in C# 2008 (eBook)

Vijay P. Mehta has been working as a software engineer and architect for the last 12 years. Starting off in the VC++/ATL, MFC, Win32, and VB6 worlds, Vijay later moved on to Java and .NET development. With his current focus on C# and .NET, Vijay holds a number of Microsoft certifications and has written a number of articles on .Net and Microsoft-focused development. Working as an architect for a financial services software company in Indianapolis, Vijay spends the bulk of his time designing and implementing large, cutting-edge software systems.

Contents at a Glance 5
Contents 7
About the Author 12
About the Technical Reviewer 13
Acknowledgments 14
Introduction 15
Object-Relational Mapping Concepts 17
Getting Started with Object- Relational Mapping 18
Introduction to Object- Relational Mapping 18
Impedance Mismatch 23
Object Persistence 27
Basic ORM Approach 28
Summary 29
ORM Patterns and Domain- Driven Design 31
Domain- Driven Design 31
Object- Relational Patterns 39
Persistence Ignorance 52
Further Reading 56
Summary 57
LINQ to SQL Examined 58
Introduction to LINQ to SQL 59
What Is LINQ to SQL? 59
Understanding the Basics 60
Summary 90
Advanced LINQ to SQL 91
Debugging 91
Using Stored Procedures 93
Working with User- Defined Functions 103
Constructing Relationships, Joins, and Projections 104
Summary 122
Entity Framework Examined 123
Getting Started with the ADO. NET Entity Framework 124
What Is EF? 124
Exploring the Designer 125
Understanding the EDM 130
Using EDMGen 153
Summary 156
Using the ADO.NET Entity Framework 157
Object Services: LINQ to Entities 157
Compiled Queries 183
Summary 185
Advanced ADO.NET Entity Framework 186
Inheritance 186
Entity Client Provider 199
Stored Procedures 213
Summary 215
The Bank of Pluto Case Study 216
A Domain Model for the First Bank of Pluto 217
Requirements and Use Cases 217
The Model 222
Summary 249
Mapping the FBP 251
Creating Classes with the Object Relational Designer 251
Using Inheritance 253
Using Compiled Queries 256
Building a Foundation 257
Creating a Database 278
Working with Many- to- Many Relationships 282
Where to Go from Here 283
Summary 284
Mapping the Bank of Pluto with the ADO. NET Entity Framework 285
Persistence Ignorance/ Custom Objects 285
Mappings/ Database 300
Middle Tier/ Context Manager 307
Summary 316
Building on the Bank of Pluto Foundation 317
N-Tier Architecture 318
Why N- Tier? 318
DTOs 318
ASP. NET 338
Summary 352
LINQ to SQL, the Entity Framework, and Your Other Options 353
LTS vs. EF 353
Alternatives 357
Summary 369
Index 370