Linq.in.action

For more ebooks: http://latestebook.com

For more ebooks: http://latestebook.com

For more ebooks: http://latestebook.com

LINQ in Action

For more ebooks: http://latestebook.com

For more ebooks: http://latestebook.com

For more ebooks: http://latestebook.com

For more ebooks: http://latestebook.com

LINQ in Action
FABRICE MARGUERIE STEVE EICHERT JIM WOOLEY

MANNINGGreenwich (74° w. long.)

For more ebooks: http://latestebook.com

For more ebooks: http://latestebook.com

For online information and ordering of this and other Manning books, please visit www.manning.com. The publisher offers discounts on this book when ordered in quantity. For more information, please contact: Special Sales Department Manning Publications Co. Sound View Court 3B fax: (609)877-8256 Greenwich, CT 06830 email: orders@manning.com

©2008 by Manning Publications Co. All rights reserved.

No part of this publication may be reproduced, stored in a retrieval system, or transmitted, in any form or by means electronic, mechanical, photocopying, or otherwise, without prior written permission of the publisher.

Many of the designations used by manufacturers and sellers todistinguish their products are claimed as trademarks. Where those designations appear in the book, and Manning Publications was aware of a trademark claim, the designations have been printed in initial caps or all caps.

Recognizing the importance of preserving what has been written, it is Manning’s policy to have the books we publish printed on acid-free paper, and we exert our best efforts tothat end. Recognizing also our responsibility to conserve the resources of our planet, Manning books are printed on paper that is at least 15% recycled and processed without the use of elemental chlorine.

Manning Publications Co. Sound View Court 3B Greenwich, CT 06830

Copyeditor: Benjamin Berg Typesetter: Gordan Salinovic Cover designer: Leslie Haimes

ISBN 1-933988-16-9 Printed in theUnited States of America 1 2 3 4 5 6 7 8 9 10 – MAL – 13 12 11 10 09 08

For more ebooks: http://latestebook.com

For more ebooks: http://latestebook.com

brief contents
PART 1 GETTING STARTED ....................................................... 1
1 2 3
■ ■ ■

Introducing LINQ

3 44 82

C# and VB.NET language enhancements LINQ building blocks

PART 2

QUERYING OBJECTS IN MEMORY............................... 113
4 5
■ ■

Getting familiar with LINQ to Objects Beyond basic in-memory queries 160

115

PART 3

QUERYING RELATIONAL DATA ................................... 203
6 7 8
■ ■ ■

Getting started with LINQ to SQL Advanced LINQ to SQL features

205 237 267

Peeking under the covers of LINQ to SQL

PART 4

MANIPULATING XML............................................... 311
9 10 11
■ ■ ■

Introducing LINQ to XML

313 350 385

Query and transform XML with LINQ to XML Common LINQ to XML scenarios
v

For more ebooks: http://latestebook.com

For more ebooks: http://latestebook.com

vi

BRIEF CONTENTS

PART 5

LINQING IT ALL TOGETHER ..................................... 435
12 13
■ ■

Extending LINQ

437

LINQ inevery layer 482

For more ebooks: http://latestebook.com

For more ebooks: http://latestebook.com

contents
foreword xv preface xvii acknowledgments xix about this book xxii

PART 1 GETTING STARTED ......................................... 1

1

Introducing LINQ 3
1.1 What is LINQ?
■

4
■

Overview 5 LINQ as a toolset 6 extensions 7

LINQ as language

1.2

Why do we needLINQ? 9
Common problems 10 LINQ to the rescue 18
■

Addressing a paradigm mismatch

12

1.3 1.4

Design goals and origins of LINQ
The goals of the LINQ project 20
■

19
21

A bit of history

First steps with LINQ to Objects: Querying collections in memory 23
What you need to get started 23
■

Hello LINQ to Objects 25

vii

For more ebooks: http://latestebook.com...