MCTS Self-Paced Training Kit (Exam 70-561): Microsoft .NET Framework 3. 5 - ADO. NET Application Development


EXAM PREP GUIDE Ace your preparation for the skills measured by MCTS Exam 70-561—and on the job. 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. This official Microsoft study guide is designed to help you make the most of ...

See more details below
Other sellers (Paperback)
  • All (36) from $1.99   
  • New (8) from $3.86   
  • Used (28) from $1.99   
Sending request ...


EXAM PREP GUIDE Ace your preparation for the skills measured by MCTS Exam 70-561—and on the job. 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. This official Microsoft study guide is designed to help you make the most of your study time.

Maximize your performance on the exam by learning to:

  • Connect to data sources; query and retrieve data
  • Manage data integrity and transactions
  • Use LINQ to query data across types, including XML
  • Work with DataSets and in-memory stores
  • Synchronize data—including smart-caching strategies
  • Generate an EDM using the Entity Framework
  • Use ADO.NET Data Services for Internet applications


Assess 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.

Your kit includes:

  • Official self-paced study guide.
  • Practice tests with multiple, customizable testing options and a learning plan based on your results.
  • 240+ practice and review questions.
  • Code samples in Microsoft Visual Basic and Visual C# on CD.
  • 90-day trial of Microsoft Visual Studio 2008 Professional Edition.
  • Fully searchable eBook of this guide.

For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.

Read More Show Less

Product Details

  • ISBN-13: 9780735625631
  • Publisher: Microsoft Press
  • Publication date: 3/25/2009
  • Pages: 528
  • Product dimensions: 7.50 (w) x 9.10 (h) x 1.70 (d)

Meet the Author

Jim Wightman is a programmer, architect, and consultant with 27+ years of software development experience. He currently focuses on Windows Azure, Windows 7, and applying Microsoft technologies to environmental issues.

Read More Show Less

Table of Contents

Exam 70-561: Microsoft .NET Framework 3.5—ADO.NET Application Development;
Shawn Wildermuth;
Mark Blomsma;
James Wightman;
Hardware Requirements;
Software Requirements;
Using the CD;
Microsoft Certified Professional Program;
Technical Support;
Evaluation Edition Software Support;
Chapter 1: Creating Database Connections;
1.1 Before You Begin;
1.2 Lesson 1: Connecting to a Data Source;
1.3 Lesson 2: Using Data Providers and More Complex Connection Scenarios;
1.4 Lesson 3: Working with Multiple Active Result Sets;
1.5 Chapter Review;
1.6 Suggested Practice;
1.7 Take a Practice Test;
Chapter 2: Selecting and Querying Data;
2.1 Lesson 1: Building Command Objects;
2.2 Lesson 2: Consuming Data Before You Begin;
2.3 Chapter Review;
2.4 Suggested Practice;
2.5 Take a Practice Test;
Chapter 3: DataSets;
3.1 Before You Begin;
3.2 Lesson 1: Introduction to DataSets;
3.3 Lesson 2: Working with Typed DataSets;
3.4 Chapter Review;
3.5 Suggested Practices;
3.6 Take a Practice Test;
Chapter 4: Updating Data;
4.1 Before You Begin;
4.2 Lesson 1: Updating Data;
4.3 Lesson 2: Data Integrity and Transactions;
4.4 Chapter Review;
4.5 Suggested Practices;
4.6 Take a Practice Test;
Chapter 5: Synchronizing Data;
5.1 Before You Begin;
5.2 Lesson 1: Caching Data;
5.3 Lesson 2: Microsoft Sync Framework;
5.4 Chapter Review;
5.5 Suggested Practices;
5.6 Take a Practice Test;
Chapter 6: Introducing LINQ;
6.1 Before You Begin;
6.2 Lesson 1: Constructing Queries with LINQ;
6.3 Lesson 2: Shaping Results with LINQ;
6.4 Chapter Review;
6.5 Suggested Practices;
6.6 Take a Practice Test;
Chapter 7: XML;
7.1 Before You Begin;
7.2 Lesson 1: DataSets and XML;
7.3 Lesson 2: Querying XML with LINQ;
7.4 Chapter Review;
7.5 Suggested Practices;
7.6 Take a Practice Test;
Chapter 8: LINQ to SQL;
8.1 Before You Begin;
8.2 Lesson 1: Introduction to LINQ to SQL;
8.3 Lesson 2: Updating Data;
8.4 Using Stored Procedures;
8.5 Chapter Review;
8.6 Suggested Practices;
8.7 Take a Practice Test;
Chapter 9: Using the Entity Framework;
9.1 Before You Begin;
9.2 Lesson 1: Generating and Querying an Entity Data Model;
9.3 Chapter Review;
9.4 Suggested Practice;
9.5 Take a Practice Test;
Chapter 10: ADO.NET Data Services;
10.1 Before You Begin;
10.2 Lesson 1: Exposing the Data Service;
10.3 Lesson 2: Consuming the Data Service;
10.4 Chapter Review;
10.5 Suggested Practices;
10.6 Take a Practice Test;
Chapter 1: Lesson Review Answers;
Chapter 1: Case Scenario Answer;
Chapter 2: Lesson Review Answers;
Chapter 2: Case Scenario Answer;
Chapter 3: Lesson Review Answers;
Chapter 3: Case Scenario Answer;
Chapter 4: Lesson Review Answers;
Chapter 4: Case Scenario Answer;
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 Answer;
Chapter 9: Lesson Review Answers;
Chapter 9: Case Scenario Answer;
Chapter 10: Lesson Review Answers;
Chapter 10: Case Scenario Answers;
System Requirements;
Hardware Requirements;
Software Requirements;
About the Authors;
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Terms of Use.
  • - Barnes & reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)