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

  Author:    Vijay Mehta, Vijay P. Mehta
  ISBN:    1590599659
  Sales Rank:    75404
  Published:    2008-03-18
  Publisher:    Apress
  # Pages:    400
  Binding:    Hardcover
  Avg. Rating:    4.0 based on 8 reviews
  Used Offers:    6 from $33.48
  Amazon Price:    $41.14
  (Data above last updated:  2008-11-29 04:51:22 EST)
  
  
Sort customer reviews by:
  
Show All Reviews on Page      Hide All Reviews on Page
   
  
Pro LINQ Object Relational Mapping in C# 2008 (Pro)
  

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 is this book 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.

About the Apress Pro Series

The Apress Pro series books are practical, professional tutorials to keep you on and moving up the professional ladder.

You have gotten the job, now you need to hone your skills in these tough competitive times. The Apress Pro series expands your skills and expertise in exactly the areas you need. Master the content of a Pro book, and you will always be able to get the job done in a professional development project. Written by experts in their field, Pro series books from Apress give you the hard–won solutions to problems you will face in your professional programming career.

Related Titles

  • Pro C# 2008 and the .NET 3.5 Framework, Fourth Edition
  • Pro LINQ: Language Integrated Query in C# 2008
                  Reader Reviews 1 - 7 of 7                 
  
  
Review
Date
Review
Rating(5 High)
Review
Helpful
to:
Customer Review Reviewer
Info
Permanent
Link
Reader Reviews Below Sorted by Newest First
09-30-08 5 (NA)
(Hide Review...)  Excellent, easy-to-follow, and complete guide to ORM with Visual Studio
Reviewer Permalink
Object relational mapping (ORM) and LINQ are new, important topics that every enterprise .NET developer should take note of, and Mr. Mehta delivers with this very informative, thorough, and approachable book on the subject. Written for the intermediate-to-advanced C# developer, the author begins with a discussion on the general aspects of ORM and how it can simply the programmer's life by consolidating _all_ business logic into the tier it belongs, the business logic tier, making your overall codebase more organized and easy to maintain.

Two Microsoft ORM technologies are presented: the simple LINQ to SQL system, and the more advanced "enterprise" level Entity Framework. As an experienced C# developer, I found the introductory material on LINQ to SQL especially helpful and easy to follow, and the material timely and directly applicable to a CRUD application i'm currently working on (a school library system). Although Visual Studio wizards are simple enough to figure out, I appreciated Mr. Mehta's step-by-step walk-through of the VS wizard generated code, giving me a complete understanding of the underpinnings of the LINQ to SQL ORM technology. After reading chapters 3 and 4, i had all the information I needed for developing my school library application. I was pleasantly surprised how much development time i saved, now that i don't have to write my own data access layer and decipher the MSDN LINQ to SQL documentation on my own.

Mr. Mehta approaches the Entity Framework with a complete sample application, "The Bank of Pluto". This is a favorite approach of mine to learning, as i get a good idea of what to expect when developing an enterprise application and how it relates to the Entity Framework.

A couple of very minor improvements i would make to this already excellent text: a quick introduction to LINQ (which the author assumes the reader already knows) and an up-front comparison of LINQ to SQL and the Entity Framework (why choose one over the other, etc.) Although the comparison of the two technologies appears in the book, it isn't encountered until the end in chapter 12. If you read the book from beginning to end as i have, I would have gotten a better sense of what technology to use for my project at the start. This is just some minor nit-picking; these gaps can be filled with the existing MSDN documentation or other texts.

Overall, Vijay Mehta has delivered a very successful book and has become my first "go-to" source for information on this important subject. I will recommended it to any C# developer!
(Review Data Last Updated: 2008-11-29 04:53:05 EST)
09-14-08 5 (NA)
(Hide Review...)  Awesome Book
Reviewer Permalink
I am not sure what the 2 and 3 star reviews are about, because I thought this book was excellent, and considering the book says "intermediate"
I'm not sure why people were expecting a "deep technical ORM, LINQ to SQL, or EF" book.

The book is broken into 5 different parts:
Part 1 - ORM Concepts - This is really good background for people who don't understand ORM patterns, and DDD, but it is a bit dry. If you are familiar with pattern based development and ORM you can probably skip over this section. I give this section 4 stars

Part 2 - LINQ to SQL Examined - This is a solid overview of LINQ to SQL. The author goes through all of the basics of LINQ to SQL and gives you just enough to move into more complex LINQ to SQL development. My biggest complaint is that there are a few left-over Beta2 errors but I contacted the author and he told me that an errata had been submitted. Overall I give this section 5 stars.

Part 3 - Entity Framework Examined - Again, this section is a good overview of EF. I like this section because the author really explores all of the meta-data behind the Entity Framework. I would have to say my biggest complaint is that there isn't enough content here on EF, but what is available in the book is a good starting point for EF developers. I think this section deserves 4 stars because I longed for more

Part 4/Part 5 - The Bank of Pluto Case Study/Building on the Bank of Pluto Foundation - I combined these sections because in my opinion they should be a single section. This is the heart of the book where the other goes through in detail a real world case study using POCO and DAO with LINQ to SQL and EF. I think this section really make the book a winner and a must read for all. 5 stars on these sections.

Overall Pro's - Great, easy to read book that covers ORM patterns, the basics of LINQ to SQL and EF, and the inner-workings of building a real world ORM data access framework.

Overall Con's - Needed a little more information in sections, and is heavily DDD focused.

I'm giving this book 5 stars because I think it brings something to MS development that other books haven't.
(Review Data Last Updated: 2008-11-23 04:51:14 EST)
09-08-08 3 0\1
(Hide Review...)  Strong inspiring start but continues as a boring and incomplete ref manual
Reviewer Permalink
Very strong start giving a DDD recap but
LINQ to SQL and LINQ to entities chapters are boring and incomplete.
I have the impression that these chapters are not written by the same person ...
(Review Data Last Updated: 2008-09-19 04:55:07 EST)
08-27-08 2 1\1
(Hide Review...)  Pro LINQ Object Relational Mapping in C# 2008
Reviewer Permalink
I must confess that when I read the title of the book "Pro LINQ Object Relational Mapping with C# 2008" I had big pretensions about the book. ORM, as the author mentions in the introduction, is not a subject commonly treated for the .NET world and I was expecting a deep technical book. This has definitively conditioned my final opinion about it.

The book is divided in several parts. You can see below the main ones.

· First one provides you with a fast overview about the ORM concepts. It explains the problematic between database and conceptual models, problems addressed with ORM, laziness, persistence ignorance, etc.

· Second one presents LINQ to SQL and EF explaining the features each one provides.

· Third part does a "complete" implementation of a sample application which provides you some insights about what it does mean working with LINQ to SQL and EF.

The biggest worth of the book is probably the third part, where the author instead of only write some excerpts of code, he has written some requirements and use cases to later on implement them as a developer would do in the "real world", including even some unitary tests.

What I didn't like is that, regardless it presents a wide range of concepts none of them is deeply treated, it always remains on the surface, which in my opinion has made of the book a "sugar free" version of what it could be.

I didn't like either to find certain technical errors like "...the CLR is doing the heavy lifting for you by translating your queries into method calls...". This is incorrect since the Common Language Runtime (CLR) does not translate the LINQ queries into methods; instead each language compiler is responsible of that conversion. With this sentence the reader can think it is better to use the method syntax instead of the LINQ syntax to avoid the translation performance cost during runtime, when it is not the case as it occurs during compilation time.

Therefore if you are looking for a deep technical ORM, LINQ to SQL or EF this is not your book. Instead if you have heard noise about these technologies and you are searching for a text to help you with an overview of what is what and the possibilities they offer, Pro LINQ Object Relational Mapping with C# 2008 can be what you need.
(Review Data Last Updated: 2008-09-09 04:48:11 EST)
08-26-08 4 (NA)
(Hide Review...)  A very good overview of LINQ, L2SQL, and EF as a DataLayer
Reviewer Permalink
I read a majority of this book, and it is a very good overview for using Linq to Sql and Entity Framework as a Data Access Layer. It does a good job of going through several scenarios. The only lacking thing in this book is something that you will learn in practice using this stuff in a real world application, and finally learn some of the limitations of EF and Linq To Sql. But what it does cover is very solid, but expect to learn some nuances with EF on your own.
(Review Data Last Updated: 2008-09-09 04:48:11 EST)
08-21-08 5 (NA)
(Hide Review...)  Just what I was looking for.
Reviewer Permalink
Overall, I think this is a really good book. I am fairly new to programming and this is a great introduction to domain driven design and object relational mapping using Microsoft tools. The author really captured an interesting case study which helped make digesting a complex topic simpler. The framework, which is largely based on Billy McCafferty's Nhibernate framework is usable and something that I can see implementing on any number of projects. Overall it's a good book and an easy read for .NET data access developers. [...].
(Review Data Last Updated: 2008-08-27 04:51:02 EST)
08-02-08 5 1\1
(Hide Review...)  so glad i bought this book!
Reviewer Permalink
The first two chapters of this book start out with a discussion of Domain-Driven Design (DDD) Principles, what Object-Relational Mapping (ORM) Tools are, the role of ORMs in DDD-informed application development, and criteria for evaluating ORM tools. Chapters Three through Seven then provide a quick tour of LINQ to SQL and ADO.Net Entity Framework (Beta 3 Version) basics. It's not until Chapter Eight that things become interesting (at least to me). After describing the functionalities that he wants to implement in the running banking application sample, the author provides plenty of code demonstrating the comparative strengths and weaknesses of the two ORM tools, potential gotchas and workarounds, lessons learned, and recommended best practices in architecting N-Tier Applications. The author's writing style is conversational, which is good most of the time, except for those few occasions when he seemed to have switched from one topic to another rather abruptly. Overall, a great book!
(Review Data Last Updated: 2008-08-25 15:57:07 EST)
  
                  Reader Reviews 1 - 7 of 7                 
  
  
  
  
  
  

Because the data used to generate this site come from outside sources, VeryWellSaid.com cannot guarantee the completeness or accuracy of the data.
Search VeryWellSaid™
Google
Web VeryWellSaid™
New subjects are added every week.
View Subjects Below by:
* Top Selling
 (click category name, left)
* Top-Rated Top Sellers
 (click 'Top Rated', right)
In the news...  
Dubai\UAE Top Rated
Influenza\Bird Flu Top Rated
Iraq Top Rated
Supreme Court Top Rated
All Books Top Rated
Arts Top Rated
Photography Top Rated
Digital Photography Top Rated
Digital Cameras Top Rated
Biography Top Rated
Business Top Rated
Management Top Rated
Marketing Top Rated
Sales Top Rated
Stocks Top Rated
Bonds Top Rated
Real Estate Top Rated
Trading Top Rated
Commodities Trading Top Rated
Time Management Top Rated
Starting A Business Top Rated
Children's Top Rated
Comics Top Rated
Computers Top Rated
PC Top Rated
Mac Top Rated
Programming Top Rated
Design Patterns Top Rated
.Net Top Rated
C# Top Rated
Vb.Net Top Rated
Asp.Net Top Rated
Java Top Rated
Python Top Rated
PHP Top Rated
Perl Top Rated
Javascript Top Rated
Ajax Top Rated
CSS Top Rated
Open Source Top Rated
SQL Top Rated
Databases Top Rated
Oracle Top Rated
MySql Top Rated
Sql Server Top Rated
IIS Top Rated
Apache Top Rated
Linux Top Rated
Windows Server Top Rated
Project Management Top Rated
HTML Top Rated
UML Top Rated
IT Certifications Top Rated
Cisco Certifications Top Rated
MCSE Top Rated
MCSD Top Rated
Cooking Top Rated
Italian Cooking Top Rated
Vegetarian Cooking Top Rated
Wine Top Rated
Engineering Top Rated
Entertainment Top Rated
Health Top Rated
Nutrition Top Rated
Dieting Top Rated
Sex Top Rated
History Top Rated
Military History Top Rated
British History Top Rated
Middle East History Top Rated
Land Battles Top Rated
Naval Warfare Top Rated
Air Warfare Top Rated
9/11 Top Rated
Terrorism Top Rated
Home Top Rated
Mortgage\Home Equity Loan Top Rated
Cars Top Rated
Car Buying Top Rated
Sports Cars Top Rated
Cat Top Rated
Humor Top Rated
Horror Top Rated
Law Top Rated
IP Law Top Rated
Legal History Top Rated
Fiction Top Rated
Oprah's Book Club Top Rated
Medicine Top Rated
Cancer Top Rated
Stroke Top Rated
Heart Disease Top Rated
Fertility Top Rated
Diabetes Top Rated
Pharmacology Top Rated
Back Problems Top Rated
Menopause Top Rated
Thyroid Top Rated
Pain Top Rated
Organic Chemistry Top Rated
Immune System Top Rated
Mystery Top Rated
Nonfiction Top Rated
Outdoors Top Rated
Running Top Rated
Radio Control Models Top Rated
Guns Top Rated
Parenting Top Rated
Divorce Top Rated
Professional Top Rated
Reference Top Rated
Religion Top Rated
Romance Top Rated
Science Top Rated
Physics Top Rated
Chemistry Top Rated
Astronomy Top Rated
Psychology Top Rated
Science Fiction Top Rated
Sports Top Rated
Teens Top Rated
Travel Top Rated
USA Top Rated
Europe Top Rated
France Top Rated
Italy Top Rated
England Top Rated
China Top Rated
All Books Arts Biography Click Here For An A-Z Index Of All 213 Best-Seller Subjects Business Children's Comics
Computers Cooking Engineering Entertainment Health History Home Horror Humor Law Fiction Medicine Mystery
Nonfiction Outdoors Parenting Professional Reference Religion Romance Science Sci-Fi Sports Teens Travel
In Association with Amazon.com

Cache miss
(not cached)