[ Pobierz całość w formacie PDF ]
PUBLISHED BY
Microsoft Press
A Division of Microsoft Corporation
One Microsoft Way
Redmond, Washington 98052-6399
Copyright © 2011 by Glenn Johnson
All rights reserved. No part of the contents of this book may be reproduced or transmitted in any form or by any
means without the written permission of the publisher.
Library of Congress Control Number: 2011927329
ISBN: 978-0-7356-2739-0
Printed and bound in the United States of America.
Microsoft Press books are available through booksellers and distributors worldwide. If you need support related
to this book, email Microsoft Press Book Support at mspinput@microsoft.com. Please tell us what you think of
this book at http://www.microsoft.com/learning/booksurvey.
Microsoft and the trademarks listed at http://www.microsoft.com/about/legal/en/us/IntellectualProperty
/Trademarks/EN-US.aspx are trademarks of the Microsoft group of companies. All other marks are property of
their respective owners.
The example companies, organizations, products, domain names, email addresses, logos, people, places, and
events depicted herein are ictitious. No association with any real company, organization, product, domain name,
email address, logo, person, place, or event is intended or should be inferred.
This book expresses the author’s views and opinions. The information contained in this book is provided without
any express, statutory, or implied warranties. Neither the authors, Microsoft Corporation, nor its resellers, or
distributors will be held liable for any damages caused or alleged to be caused either directly or indirectly by
this book.
Acquisitions Editor:
Martin Del Re
Developmental Editor:
Karen Szall
Project Editor:
Valerie Woolley
Editorial Production:
nSight, Inc.
Technical Reviewer:
Christophe Nasarre; Technical Review services provided by Content Master, a member of
CM Group, Ltd.
Copyeditor:
Kerin Forsyth
Indexer:
Luci Haskins
Cover:
Twist Creative • Seattle
Exam 70-516: TS: Accessing Data with
Microsoft .NET Framework 4
OBJECTIVE
CHAPTER LESSON
MODELING DATA (20%)
Map entities and relationships by using the Entity Data Model.
Chapter 6
Lesson 1
Map entities and relationships by using LINQ to SQL.
Chapter 4
Lesson 1
Create and customize entity objects.
Chapter 6
Lesson 1
Connect a POCO model to the entity Framework.
Chapter 6
Lesson 1
Create the database from the Entity Framework model.
Chapter 6
Lesson 1
Create model-deined functions.
Chapter 6
Lesson 1
MANAGING CONNECTIONS AND CONTEXT (18%)
Conigure connection strings and providers.
Chapter 2
Lesson 1
Create and manage a data connection.
Chapter 2
Lesson 1
Secure a connection.
Chapter 2
Lesson 1
Manage the DataContext and ObjectContext.
Chapter 4
Chapter 6
Lesson 1
Lesson 1
Implement eager loading.
Chapter 4
Chapter 6
Chapter 7
Lesson 1
Lesson 1
Lesson 1
Cache data.
Chapter 1
Chapter 4
Lesson 1
Lesson 3
Conigure ADO.NET Data Services.
Chapter 7
Lesson 1, 2
QUERYING DATA (22%)
Execute a SQL query.
Chapter 2
Lesson 2
Create a LINQ query.
Chapter 3
Chapter 4
Lesson 1, 2
Lesson 2
Create an Entity SQL (ESQL) query.
Chapter 3
Chapter 4
Chapter 6
Lesson 1, 2
Lesson 2
Lesson 2
Handle special data types.
Chapter 1
Chapter 2
Lesson 2
Lesson 2
Query XML.
Chapter 5
Lesson 1, 2, 3
Query data by using ADO.NET Data Services.
Chapter 7
Lesson 1
MANIPULATING DATA (22%)
Create, update, or delete data by using SQL statements.
Chapter 2
Lesson 2
Create, update, or delete data by using DataContext.
Chapter 4
Lesson 3
Create, update, or delete data by using ObjectContext.
Chapter 6
Lesson 2
Manage transactions.
Chapter 2
Chapter 6
Lesson 3
Lesson 2
Create disconnected objects.
Chapter 1
Lesson 1
DEVELOPING AND DEPLOYING RELIABLE APPLICATIONS (18%)
Monitor and collect performance data.
Chapter 8
Lesson 1
Handle exceptions.
Chapter 8
Lesson 2
Protect data.
Chapter 8
Lesson 3
Synchronize data.
Chapter 2
Chapter 8
Lesson 3
Lesson 4
Deploy ADO.NET components.
Chapter 9
Lesson 1
Exam Objectives
The exam objectives listed here are current as of this book’s publication date. Exam objectives
are subject to change at any time without prior notice and at Microsoft’s sole discretion. Please visit the Microsoft
Learning Web site for the most current listing of exam objectives: http://www.microsoft.com/learning/en/us/Exam
.aspx?ID=70-516.
Contents at a Glance
Introduction
xiii
CHAPTER 1
ADO.NET Disconnected Classes
1
CHAPTER 2
ADO.NET Connected Classes
63
CHAPTER 3
Introducing LINQ
143
CHAPTER 4
LINQ to SQL
237
CHAPTER 5
LINQ to XML
295
CHAPTER 6
ADO.NET Entity Framework
359
CHAPTER 7
WCF Data Services
459
CHAPTER 8
Developing Reliable Applications
503
CHAPTER 9
Deploying Your Application
581
Answers
601
Index
623
[ Pobierz całość w formacie PDF ]
zanotowane.pl doc.pisz.pl pdf.pisz.pl jajeczko.pev.pl
PUBLISHED BY
Microsoft Press
A Division of Microsoft Corporation
One Microsoft Way
Redmond, Washington 98052-6399
Copyright © 2011 by Glenn Johnson
All rights reserved. No part of the contents of this book may be reproduced or transmitted in any form or by any
means without the written permission of the publisher.
Library of Congress Control Number: 2011927329
ISBN: 978-0-7356-2739-0
Printed and bound in the United States of America.
Microsoft Press books are available through booksellers and distributors worldwide. If you need support related
to this book, email Microsoft Press Book Support at mspinput@microsoft.com. Please tell us what you think of
this book at http://www.microsoft.com/learning/booksurvey.
Microsoft and the trademarks listed at http://www.microsoft.com/about/legal/en/us/IntellectualProperty
/Trademarks/EN-US.aspx are trademarks of the Microsoft group of companies. All other marks are property of
their respective owners.
The example companies, organizations, products, domain names, email addresses, logos, people, places, and
events depicted herein are ictitious. No association with any real company, organization, product, domain name,
email address, logo, person, place, or event is intended or should be inferred.
This book expresses the author’s views and opinions. The information contained in this book is provided without
any express, statutory, or implied warranties. Neither the authors, Microsoft Corporation, nor its resellers, or
distributors will be held liable for any damages caused or alleged to be caused either directly or indirectly by
this book.
Acquisitions Editor:
Martin Del Re
Developmental Editor:
Karen Szall
Project Editor:
Valerie Woolley
Editorial Production:
nSight, Inc.
Technical Reviewer:
Christophe Nasarre; Technical Review services provided by Content Master, a member of
CM Group, Ltd.
Copyeditor:
Kerin Forsyth
Indexer:
Luci Haskins
Cover:
Twist Creative • Seattle
Exam 70-516: TS: Accessing Data with
Microsoft .NET Framework 4
OBJECTIVE
CHAPTER LESSON
MODELING DATA (20%)
Map entities and relationships by using the Entity Data Model.
Chapter 6
Lesson 1
Map entities and relationships by using LINQ to SQL.
Chapter 4
Lesson 1
Create and customize entity objects.
Chapter 6
Lesson 1
Connect a POCO model to the entity Framework.
Chapter 6
Lesson 1
Create the database from the Entity Framework model.
Chapter 6
Lesson 1
Create model-deined functions.
Chapter 6
Lesson 1
MANAGING CONNECTIONS AND CONTEXT (18%)
Conigure connection strings and providers.
Chapter 2
Lesson 1
Create and manage a data connection.
Chapter 2
Lesson 1
Secure a connection.
Chapter 2
Lesson 1
Manage the DataContext and ObjectContext.
Chapter 4
Chapter 6
Lesson 1
Lesson 1
Implement eager loading.
Chapter 4
Chapter 6
Chapter 7
Lesson 1
Lesson 1
Lesson 1
Cache data.
Chapter 1
Chapter 4
Lesson 1
Lesson 3
Conigure ADO.NET Data Services.
Chapter 7
Lesson 1, 2
QUERYING DATA (22%)
Execute a SQL query.
Chapter 2
Lesson 2
Create a LINQ query.
Chapter 3
Chapter 4
Lesson 1, 2
Lesson 2
Create an Entity SQL (ESQL) query.
Chapter 3
Chapter 4
Chapter 6
Lesson 1, 2
Lesson 2
Lesson 2
Handle special data types.
Chapter 1
Chapter 2
Lesson 2
Lesson 2
Query XML.
Chapter 5
Lesson 1, 2, 3
Query data by using ADO.NET Data Services.
Chapter 7
Lesson 1
MANIPULATING DATA (22%)
Create, update, or delete data by using SQL statements.
Chapter 2
Lesson 2
Create, update, or delete data by using DataContext.
Chapter 4
Lesson 3
Create, update, or delete data by using ObjectContext.
Chapter 6
Lesson 2
Manage transactions.
Chapter 2
Chapter 6
Lesson 3
Lesson 2
Create disconnected objects.
Chapter 1
Lesson 1
DEVELOPING AND DEPLOYING RELIABLE APPLICATIONS (18%)
Monitor and collect performance data.
Chapter 8
Lesson 1
Handle exceptions.
Chapter 8
Lesson 2
Protect data.
Chapter 8
Lesson 3
Synchronize data.
Chapter 2
Chapter 8
Lesson 3
Lesson 4
Deploy ADO.NET components.
Chapter 9
Lesson 1
Exam Objectives
The exam objectives listed here are current as of this book’s publication date. Exam objectives
are subject to change at any time without prior notice and at Microsoft’s sole discretion. Please visit the Microsoft
Learning Web site for the most current listing of exam objectives: http://www.microsoft.com/learning/en/us/Exam
.aspx?ID=70-516.
Contents at a Glance
Introduction
xiii
CHAPTER 1
ADO.NET Disconnected Classes
1
CHAPTER 2
ADO.NET Connected Classes
63
CHAPTER 3
Introducing LINQ
143
CHAPTER 4
LINQ to SQL
237
CHAPTER 5
LINQ to XML
295
CHAPTER 6
ADO.NET Entity Framework
359
CHAPTER 7
WCF Data Services
459
CHAPTER 8
Developing Reliable Applications
503
CHAPTER 9
Deploying Your Application
581
Answers
601
Index
623
[ Pobierz całość w formacie PDF ]