Pro LINQ Object Relational Mapping in C# 2008 / Edition 1

Paperback (Print)
Buy New
Buy New from
Used and New from Other Sellers
Used and New from Other Sellers
from $1.99
Usually ships in 1-2 business days
(Save 96%)
Other sellers (Paperback)
  • All (14) from $1.99   
  • New (7) from $28.21   
  • Used (7) from $1.99   


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.

What you’ll learn

  • The powerful advantages that OR/M can bring to your code
  • The native tools that are now available within Visual Studio 2008 for OR/M
  • How to build scalable object–oriented data access layers that take advantage of OR/M’s flexibility
  • How LINQ fits into this picture, together with the advantages and disadvantages that it can bring
  • How the concepts work in the real world by examining a fully worked and detailed case study, created with an architecture than can be easily applied to a wide range of other situations

Who this book is for

This book is intended for Microsoft .NET developers who are using or evaluating Microsoft Visual Studio 2008 to build data–aware applications, and it will provide patterns and resources that can be used to build enterprise class software.

Read More Show Less

Product Details

  • ISBN-13: 9781590599655
  • Publisher: Apress
  • Publication date: 7/7/2008
  • Series: The Expert's Voice in .NET Series
  • Edition number: 1
  • Pages: 408
  • Product dimensions: 7.00 (w) x 9.10 (h) x 1.00 (d)

Meet the Author

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.

Read More Show Less

Table of Contents

Pt. 1 Object-Relational Mapping Concepts

Ch. 1 Getting Started with Object-Relational Mapping 3

Ch. 2 ORM Patterns and Domain-Driven Design 17

Pt. 2 LINQ to SQL Examined

Ch. 3 Introduction to LINQ to SQL 47

Ch. 4 Advanced LINQ to SQL 79

Pt. 3 Entity Framework Examined

Ch. 5 Getting Started with the ADO.NET Entity Framework 113

Ch. 6 Using the ADO.NET Entity Framework 147

Ch. 7 Advanced ADO.NET Entity Framework 177

Pt. 4 The Bank of Pluto Case Study

Ch. 8 A Domain Model for the First Bank of Pluto 209

Ch. 9 Mapping the FBP 243

Ch. 10 Mapping the Bank of Pluto with the ADO.NET Entity Framework 277

Pt. 5 Building on the Bank of Pluto Foundation

Ch. 11 N-Tier Architecture 311

Ch. 12 LINQ to SOL, the Entity Framework, and Your Other Options 347

Index 365

Read More Show Less

Customer Reviews

Average Rating 4
( 1 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Terms of Use.
  • - Barnes & reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing 1 Customer Reviews
  • Anonymous

    Posted August 24, 2008

    Well Focused ORM / LINQ to SQL / EF Guide

    I¿ve really gotten a lot out of this book. Vijay Mehta does an excellent job of encompassing both ORM and LINQ topics important to professional software development into one affordable text. He opens with an overview of Object Relational Mapping 'ORM', and the criteria he uses when evaluating ORM solutions, including a quick synopsis of how LINQ to SQL and the Entity Framework rate against his criteria. This provides a solid basis for understanding where he is coming from throughout the remainder of the book, and a perfect jumping off point for Vijay¿s deeper examination of LINQ to SQL and the Entity Framework. For someone who is already familiar with ORM concepts and patterns, you may want to skip the first two chapters, but you¿ll also be missing out on the perspective Vijay brings to the remainder of the text. Although there are several syntax errors in the sample code of the first couple chapters, these were minor and didn¿t detract at all from the actual ORM, LINQ to SQL or EF topics. Additionally, I was pleased to see that the author has made much of the source code from the text available as a download from the Apress website, which makes experimenting all that much easier. All in all, I would highly recommend this book to anyone looking for both an introduction and an in-depth professional analysis of ORM as it relates to LINQ to SQL or the Entity Framework.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing 1 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)