EXAM PREP GUIDEAce your preparation for the skills measured by MCTS Exam 70-516—and on the job—with this official Microsoft study guide. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce and apply what you’ve learned through real-world case scenarios and practice exercises.
Maximize your performance on the exam by mastering the skills and experience measured by these objectives:
Modeling data
Managing connections and context
Querying data
Manipulating data
Developing and deploying reliable applications
PRACTICE TESTSAssess your skills with the practice tests on CD. You can work through hundreds of questions using multiple testing modes to meet your specific learning needs. You get detailed explanations for right and wrong answers—including a customized learning path that describes how and where to focus your studies.
Chapter 1 ADO.NET Disconnected Classes
Before You Begin
Lesson 1: Working with the DataTable and DataSet Classes
Lesson 2: Serialization, Specialized Types, and Data Binding
Case Scenarios
Suggested Practices
Take a Practice Test
Chapter 2 ADO.NET Connected Classes
Before You Begin
Lesson 1: Connecting to the Data Store
Lesson 2: Reading and Writing Data
Lesson 3: Working with Transactions
Case Scenarios
Suggested Practices
Take a Practice Test
Chapter 3 Introducing LINQ
Before You Begin
Lesson 1: Understanding LINQ
Lesson 2: Using LINQ Queries
Case Scenarios
Suggested Practices
Take a Practice Test
Chapter 4 LINQ to SQL
Before You Begin
Lesson 1: What Is LINQ to SQL?
Lesson 2: Executing Queries Using LINQ to SQL
Lesson 3: Submitting Changes to the Database
Case Scenario
Suggested Practices
Take a Practice Test
Chapter 5 LINQ to XML
Before You Begin
Lesson 1: Working with the XmlDocument and XmlReader Classes
Lesson 2: Querying with LINQ to XML
Lesson 3: Transforming XML Using LINQ to XML
Case Scenario
Suggested Practices
Take a Practice Test
Chapter 6 ADO.NET Entity Framework
Before You Begin
Lesson 1: What Is the ADO.NET Entity Framework?
Lesson 2: Querying and Updating with the Entity Framework
Case Scenarios
Suggested Practices
Take a Practice Test
Chapter 7 WCF Data Services
Before You Begin
Lesson 1: What Is WCF Data Services?
Lesson 2: Consuming WCF Data Services
Case Scenario
Suggested Practices
Take a Practice Test
Chapter 8 Developing Reliable Applications
Before You Begin
Lesson 1: Monitoring and Collecting Performance Data
Lesson 2: Handling Exceptions
Lesson 3: Protecting Your Data
Lesson 4: Synchronizing Data
Case Scenario
Suggested Practices
Take a Practice Test
Chapter 9 Deploying Your Application
Before You Begin
Lesson 1: Deploying Your Application
Case Scenario
Suggested Practices
Take a Practice Test
Appendix Answers
Chapter 1: Lesson Review Answers
Chapter 1: Case Scenarios Answers
Chapter 2: Lesson Review Answers
Chapter 2: Case Scenarios Answers
Chapter 3: Lesson Review Answers
Chapter 3: Case Scenario Answers
Chapter 4: Lesson Review Answers
Chapter 4: Case Scenario Answers
Chapter 5: Lesson Review Answers
Chapter 5: Case Scenario Answers
Chapter 6: Lesson Review Answers
Chapter 6: Case Scenario Answers
Chapter 7: Lesson Review Answers
Chapter 7: Case Scenario Answers
Chapter 8: Lesson Review Answers
Chapter 8: Case Scenario Answers
Chapter 9: Lesson Review Answers
Chapter 9: Case Scenario Answers
Title:
MCTS Self-Paced Training Kit (Exam 70-516): Accessing Data with Microsoft® .NET Framework 4
Glenn Johnson is a trainer and writer focusing on ASP.NET, ADO.NET, C#, and .NET internals. He is author of Programming Microsoft® ADO.NET 2.0 Applications: Advanced Topics.