Pro LINQ Object Relational Mapping in C# 2008

1. Front Matter

   Pages i-xx

   PDF

2. Object-Relational Mapping Concepts

   1. Front Matter

      Pages 1-1

      PDF

   2. Getting Started with Object-relational Mapping

      Pages 3-15

   3. ORM Patterns and Domain-driven Design

      Pages 17-43

3. LINQ to SQL Examined

   1. Front Matter

      Pages 45-45

      PDF

   2. Introduction to LINQ to SQL

      Pages 47-78

   3. Advanced LINQ to SQL

      Pages 79-110

4. Entity Framework Examined

   1. Front Matter

      Pages 111-111

      PDF

   2. Getting started with the ADO.NET entity framework

      Pages 113-145

   3. Using the ADO.NET Entity Framework

      Pages 147-175

   4. Advanced ADO.NET Entity Framework

      Pages 177-206

5. The Bank of Pluto Case Study

   1. Front Matter

      Pages 207-207

      PDF

   2. A Domain Model for the First Bank of Pluto

      Pages 209-242

   3. Mapping the FBP

      Pages 243-276

   4. Mapping the Bank of Pluto with the ADO.NET Entity Framework

      Pages 277-308

6. Building on the Bank of Pluto Foundation

   1. Front Matter

      Pages 309-309

      PDF

   2. N-Tier Architecture

      Pages 311-345

   3. LINQ to SQL, the Entity Framework, and Your Other Options

      Pages 347-363

7. Back Matter

   Pages 365-383

   PDF

It is nearly impossible today to write enterprise software without the use of one or more relational databases. Granted, there are cases when the data is transient and not stored in a database, but for the most part, software needs to consume and manipulate data in a database. It sounds easy, but there are hundreds of ways to connect software systems to databases and thousands of people who think they have the skeleton key for data access layers. Pro LINQ Object Relational Mapping in C# 2008 explains an efficient, repeatable way to apply industry design patterns to build scalable object–oriented data access layers.

Object relational mapping (OR/M) has been a gray area in Microsoft development for many years. It's not that Microsoft language developers don't understand OR/M; in fact, the opposite is true, as is exemplified by the glut of third–party .NET OR/M tools on the market. The struggle has come more from the lack of native tools with the object–oriented and object persistence capacity to effectively work in this arena. With the inception of .NET, Microsoft overcame the first obstacle by developing an object–oriented environment and framework. The second obstacle, the native object persistence layer, is only now being realized with the introduction of Language Integrated Query (LINQ) and LINQ's children, the Language Integrated Query for Relational Databases (LINQ to SQL) and the Language Integrated Query for the ADO.NET Entity Framework (LINQ to Entities). The gray area no longer exists, and the .NET developers of the world finally have the native tools required to build modular, reusable data access layers.

• .NET
• ADO
• ADO.NET
• Boo
• C#
• LINQ
• SQL
• Scala
• relational database

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.

Policies and ethics