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


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

See more details below
Other sellers (Paperback)
  • All (14) from $1.99   
  • New (2) from $4.89   
  • Used (12) from $1.99   
Sending request ...


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:

  • 15% exam discount from Microsoft. (Limited time offer). Details inside.
  • 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.

A Note Regarding the CD or DVD

The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to

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

I am a Microsoft C# MVP and the founder of Wildermuth Consulting Services, LLC, a company that is dedicated to delivering software and training solutions in the Atlanta, Georgia area. I am also a speaker on the INEA Speaker's Bureau and have appeared at several national conferences to speak on a variety of subjects. I am the author of the book "Pragmatic ADO.NET", the upcoming "Prescriptive Data Architectures", both for Addison-Wesley as well as co-author of several certification books for Microsoft Press. I have been writing articles for a number of years for a variety of magazines and websites, including MSDN, MSDN Online, DevSource, The ServerSide .NET, and Intel's Rich Client Series. I have enjoyed building data-driven software for more than twenty years.

Mark Blomsma, Microsoft MVP for C#, specializes in .NET technologies, enterprise application development and integration, and software renovation

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)