Professional ADO.NET 3.5 with LINQ and the Entity Framework

676 Pages·2009·12.95 MB·English

by  Roger Jennings

spine=1.344"
Wrox Programmer to ProgrammerTM Wrox Programmer to ProgrammerTM
Professional
Jennings
ADO.NET 3.5
with LINQ and the Entity Framework
LINQ and the Entity Framework are revolutionizing .NET database Professional
programming. With this book as your guide, you’ll discover how to leverage
these cutting-edge query and object/relational mapping technologies wA
for enterprise-class computing. It provides you with hands-on coding
techniques for data-intensive web and Windows projects. You’ll also get i
t
quickly up to speed on LINQ technologies with the help of C# and VB
h
programming examples. D

Leading Microsoft database authority Roger Jennings first covers LINQ L
Standard Query Operators (SQOs) and domain-specific LINQ to SQL, I
LINQ to DataSet, and LINQ to XML implementations for querying generic N
O
collections. He then delves into the ADO.NET Entity Framework, Entity Data
Q
Model, Entity SQL (eSQL), and LINQ to Entities. Numerous code examples
are integrated throughout the chapters that emulate real-world data
a
sources and show you how to develop C# and VB web site/application or
Windows projects. n.
The information in this book will give you the tools to create and maintain dN
applications that are independent of the underlying relational data.
t
Professional
What you will learn from this book h
● A new approach to data access in ADO.NET 3.5 SP1 eE
● Methods for working with advanced LINQ query operators and
E
expressions
ADO.NET 3.5
● Techniques for querying SQL Server® database with LINQ to SQL n
T
● Approaches for integrating third-party and emerging LINQ t
implementations i
t
● How to raise the level of data abstraction with the Entity Data Model y
● Steps for creating design-time data sources from ObjectContext Enhance Your Knowledge
Advance Your Career
● Ways to use the Entity Data Model as a data source F3
r
Who this book is for a with LINQ and the Entity Framework
This book is for intermediate to advanced developers of data-intensive .NET web- and Windows-based applications.
m.
Wrox Professional guides are planned and written by working programmers to meet the real-world needs of programmers, e5
developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They
w
provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.
o
www.wrox.com
r
k
Recommended Programming ISBN: 978-0-470-18261-1
Computer Book Roger Jennings
Categories Software Development
$49.99 USA
$59.99 CAN Updates, source code, and Wrox technical support at www.wrox.com
Professional
ADO.NET 3.5
™
Programmer to Programmer
with LINQ and the Entity Framework
Get more out of
Professional ADO.NET 3.5
with LINQ and the Entity Framework
978-0-470-18261-1
This book is for intermediate to advanced developers of data-
intensive .NET Windows and Web-based applications
WROX.com
ASP.NET 3.5 Website Programming
Problem-Design-Solution
978-0-470-18758-6
This book emphasizes n-tier ASP.NET Web application architectural
design, something intermediate and advanced ASP.NET developers
need and can’t find anywhere else.
Professional ASP.NET 3.5: In C# and VB
978-0-470-18757-9
Interact Chapters on Demand This book is for programmers and developers who are looking to
make the transition to ASP.NET 3.5 with Visual Studio 2008 and
either C# 3.0 (2008) or Visual Basic 9 (2008).
Take an active role online by participating in Purchase individual book chapters in pdf
our P2P forums format Professional LINQ
978-0-470-04181-9
This book is for developers who want to learn about LINQ and how
Wrox Online Library Join the Community it can benefit and enhance their applications.
Hundreds of our books are available online Sign up for our free monthly newsletter at Beginning ASP.NET 3.5
978-0-470-18759-3
through Books24x7.com newsletter.wrox.com
This book is for anyone who wants to build rich and interactive web
sites that run on the Microsoft platform. No prior experience in web
development is assumed.
Wrox Blox Browse
Beginning T-SQL
Download short informational pieces and Ready for more Wrox? We have books and Enhance Your Knowledge with Microsoft SQL Server 2005 and 2008
code to keep you up to date and out of e-books available on .NET, SQL Server, Java, 978-0-470-25703-6
Advance Your Career
This book will provide you with an overview of SQL Server query
trouble! XML, Visual Basic, C#/ C++, and much more!
operations and tools used with T-SQL, Microsoft’s implementation
of the SQL database query language.
Contact Us.
We always like to get feedback from our readers. Have a book idea?
Need community support? Let us know by e-mailing [email protected]
Professional
ADO.NET 3.5 with LINQ and the Entity Framework
Introduction .........................................................................................................xxvii
Part I: Getting a Grip on ADO.NET 3.5
Chapter 1: Taking a New Approach to Data Access in ADO.NET 3.5 ..................3
Part II: Introducing Language Integrated Query
Chapter 2: Understanding LINQ Architecture and Implementation ...................63
Chapter 3: Executing LINQ Query Expressions with LINQ to Objects ...............91
Chapter 4: Working with Advanced Query Operators and Expressions ...........155
Part III: Applying Domain-Specific LINQ Implementations
Chapter 5: Using LINQ to SQL and the LinqDataSource.................................195
Chapter 6: Querying DataTables with LINQ to DataSet .................................243
Chapter 7: Manipulating Documents with LINQ to XML ................................267
Chapter 8: Exploring Third-Party and Emerging LINQ Implementations ..........317
Part IV: Introducing the ADO.NET Entity Framework
Chapter 9: Raising the Level of Data Abstraction with the
Entity Data Model ......................................................................357
Chapter 10: Defining Storage, Conceptual, and Mapping Layers ...................393
Chapter 11: Introducing Entity SQL .............................................................433
Part V: Implementing the ADO.NET Entity Framework
Chapter 12: Taking Advantage of Object Services and LINQ to Entities .........469
Chapter 13: Updating Entities and Complex Types .......................................503
Chapter 14: Binding Entities to Data-Aware Controls ...................................533
Chapter 15: Using the Entity Framework as a Data Source ...........................567
Index .........................................................................................................607
ffffiirrss..iinndddd ii 1122//2222//0088 1122::2200::2277 PPMM
ffffiirrss..iinndddd iiii 1122//2222//0088 1122::2200::2288 PPMM
Professional
ADO.NET 3.5 with LINQ and the Entity
Framework
ffffiirrss..iinndddd iiiiii 1122//2222//0088 1122::2200::2288 PPMM
ffffiirrss..iinndddd iivv 1122//2222//0088 1122::2200::2288 PPMM
Professional
ADO.NET 3.5 with LINQ and the Entity
Framework
Roger Jennings
Wiley Publishing, Inc.
ffffiirrss..iinndddd vv 1122//2222//0088 1122::2200::2288 PPMM
Professional ADO.NET 3.5 with LINQ and the Entity Framework
Published by
Wiley Publishing, Inc.
10475 Crosspoint Boulevard
Indianapolis, IN 46256
www.wiley.com
Copyright © 2009 by Wiley Publishing, Inc., Indianapolis, Indiana
Published simultaneously in Canada
ISBN: 978-0-470-18261-1
Manufactured in the United States of America
10 9 8 7 6 5 4 3 2 1
Library of Congress Cataloging-in-Publication Data
Jennings, Roger.
Professional ADO.NET 3.5 with Linq and the Entity Framework / Roger Jennings.
p. cm.
Includes index.
ISBN 978-0-470-18261-1 (paper/website)
1. ActiveX. 2. Microsoft LINQ. 3. Database design. 4. Microsoft .NET. 5. Query languages
(Computer science) I. Title.
QA76.9.D26J475 2009
006.7'882—dc22
2008048201

No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by
any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted
under Sections 107 or 108 of the 1976 United States Copyright Act, without either the prior written
permission of the Publisher, or authorization through payment of the appropriate per-copy fee to the
Copyright Clearance Center, 222 Rosewood Drive, Danvers, MA 01923, [phone], fax [phone].
Requests to the Publisher for permission should be addressed to the Permissions Department, John Wiley &
Sons, Inc., 111 River Street, Hoboken, NJ 07030, [phone], fax [phone], or online at
http://www.wiley.com/go/permissions.
Limit of Liability/Disclaimer of Warranty: The publisher and the author make no representations or
warranties with respect to the accuracy or completeness of the contents of this work and specifically
disclaim all warranties, including without limitation warranties of fitness for a particular purpose. No
warranty may be created or extended by sales or promotional materials. The advice and strategies contained
herein may not be suitable for every situation. This work is sold with the understanding that the publisher is
not engaged in rendering legal, accounting, or other professional services. If professional assistance is
required, the services of a competent professional person should be sought. Neither the publisher nor the
author shall be liable for damages arising herefrom. The fact that an organization or Web site is referred to in
this work as a citation and/or a potential source of further information does not mean that the author or the
publisher endorses the information the organization or Web site may provide or recommendations it may
make. Further, readers should be aware that Internet Web sites listed in this work may have changed or
disappeared between when this work was written and when it is read.
For general information on our other products and services please contact our Customer Care Department
within the United States at [phone], outside the United States at [phone] or fax [phone].
Trademarks: Wiley, the Wiley logo, Wrox, the Wrox logo, Wrox Programmer to Programmer, and related
trade dress are trademarks or registered trademarks of John Wiley & Sons, Inc. and/or its affiliates, in the
United States and other countries, and may not be used without written permission. All other trademarks
are the property of their respective owners. Wiley Publishing, Inc. is not associated with any product or
vendor mentioned in this book.
Wiley also publishes its books in a variety of electronic formats. Some content that appears in print may not
be available in electronic books.
ffffiirrss..iinndddd vvii 1122//2222//0088 1122::2200::2299 PPMM
This book is dedicated to my wife, Alexandra.
ffffiirrss..iinndddd vviiii 1122//2222//0088 1122::2200::2299 PPMM
ffffiirrss..iinndddd vviiiiii 1122//2222//0088 1122::2200::2299 PPMM