MCTS Exam 70 - 561: Microsoft.NET Framework 3.5, ADO.NET
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;
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
Candidates for this course/exam use Microsoft Visual Studio to develop data-access portions of applications.
Candidates should have a minimum of two to three years of experience developing Web, Windows, or distributed applications by using the Microsoft .NET Framework.
Candidates should have a thorough understanding of relational database concepts and should have a minimum of one to two years of experience using Microsoft SQL Server and other relational database management systems, such as Oracle, DB2, and MySQL.
Credit Toward Certification Exam 70-561: TS: Microsoft .NET Framework 3.5, ADO.NET Application Development: counts as credit toward the following certification(s):
Our Partners
