70-561 C# : MCPD - C# .NET Framework 3.5, ADO.NET Application Development

Retired. This product is no longer available.

The Microsoft's MCTS certification is an industry recognized credential. The certification is proof of a person's competence across a spectrum of skills including developing Web, Windows, or distributed applications by using the Microsoft .NET Framework.
58 58
MCPD - C# .NET Framework 3.5, ADO.NET Application Development

Here's what you will get

The .NET Framework 3.5, ADO.NET Application Development exam is a part of Microsoft's MCTS .NET Framework 3.5 ADO .NET Applications certification which comprises of two exams. It is a required piece to the certification.

The certification is targeted to those professionals who are using Visual Studio 2008 and the Microsoft .NET Framework 3.5, or who anticipate working with these technologies in the near future. MCTS .NET Framework 3.5 ADO .NET Applications also requires that you pass 70-536-CSHARP exam.

Pre-assessment Questions
Full Length Tests
Post-Assessment Questions
Exam FAQs
What is the exam registration fee? 150
Where do I take the exam? The Microsoft .NET Framework 3.5, ADO.NET Application Development exam is administered by Prometric at testing centers worldwide. Click here to find a testing center near you.
What is the format of the exam? The exam consists of adaptive, multiple choice questions, hot area, drag and drop, build list and reorder, and builds a tree questions.
What are the pre-requisites of the exam?

Microsoft has the following pre-requisites for MCTS:

Microsoft SQL Server and other relational database management systems, such as Oracle, DB2 and MySQL.

In addition, candidates should have a good grasp of the following:

  • Structured Query Language (SQL)
  • Stored procedures
  • Data-bound controls
How many questions are asked in the exam? The exam contains 50 questions.
What is the duration of the exam? 120 minutes
What is the passing score? 700

(on a scale of 0-1000)

What is the exam's retake policy?

In the event that you fail your first attempt at passing the MCTS certification examination, Microsoft's retake policy is:

  • If a candidate does not achieve a passing score on an exam the first time, the candidate must wait at least a 24-hour period before retaking the exam.
  • If a candidate does not achieve a passing score the second time, the candidate must wait at least a 14-day period before retaking the exam a third time.
  • A 14-day waiting period will also be imposed for the fourth and fifth subsequent exam retakes. A candidate may not take a given exam any more than five times per year. This 12-month period would start the day of the fifth unsuccessful exam retake. The candidate would then be eligible to retake the exam 12 months from that date. In order to take a given exam more than five times per year, a candidate must submit a request and obtain prior permission from Microsoft.
  • If a candidate achieves a passing score on an exam, the candidate cannot take it again.
What is the validity of the certification?

Microsoft Certified Technology Specialist has no expiration. The certification holder is certified for life unless the vendor changes their policy.

Click here for more information.

Where can I find more information about this exam? To know more about the 70-561-CSHARP, click here.
Which certification covers this exam?
What are the career opportunities after passing this exam?

A MCTS certified professional has several career opportunities open up to them, including:

  • WCF Programmer
  • Application developer

Here's what you will learn

  • Manage connection strings. Using the ConnectionS...nceManaging User Instance and AttachDBfilename
  • Manage connection objects. Managing connection s...Result Sets (MARS)Encrypting and decrypting data
  • Work with data providers. LimitationsBehaviorsPe...d providersThird-party providersNative providers
  • Connect to a data source by using a generic data... interface. System.Data.Common namespace classes
  • Handle and diagnose database connection exceptions. Implementing Try/Catch handlers
  • Build command objects. Building Parameters colle...der classChoosing an appropriate CommandBehavior
  • Query data from data sources. Writing queries to...ing data paging SortingFilteringAggregating data
  • Retrieve data source data by using the DataReade...ored proceduresWorking with multiple result sets
  • Manage data by using the DataAdapter or the Tabl...TableAdaptersModifying TableAdapter Fill methods
  • Execute an asynchronous query. Handling asynchronous events
  • Handle special data types. Binary Large Objects (BLOBs)FileStreamSpatialTable Value Parameters
  • Query data sources by using LINQ. Extended metho...Classes of the System.LINQ.Expressions namespace
  • Manage exceptions when selecting data. Identifying and resolving syntax errorsSecurity exceptions
  • Manage transactions. Selecting an appropriate tr...buted transactionsUsing declarative transactions
  • Manage data integrity. Cascading updatesCascadin...nt-side data validationBusiness rulesConstraints
  • Update data. Update data by using stored proceduresUpdate DataSet to data sourceManaging concurrency
  • Manage exceptions when modifying data. Resolve e...tionsData locking conflictsData collision issues
  • Transform data by using LINQ. Aggregation operatorsJOIN operatorQUERY operatorLIKEOther operators
  • Monitor event notifications. Implement notificat...nt notifications by using SqlNotificationRequest
  • Cache data. SqlCacheDependencyLocal Data Cache
  • Manage update conflicts between online data and offline data.
  • Partition data for synchronization.
  • Implement Synchronization Services. SyncAgentSyn...eClientSyncProviderServerSyncProviderSyncAdapter
  • Manage occasionally connected data.
  • Programmatically create data objects. DataTableDataSet
  • Work with un-typed DataSet and DataTable. Populating a DataSet Populating a DataTable
  • Expose a DataTableReader. Using a DataTableUsing a DataSet
  • Work with strongly typed DataSet and DataTable.
  • Define and implement an Entity Data Model. Mapping schemasStorage of metadataEDM Generator
  • Query data by using Object Services. Querying da...tsManaging the object contextCustomizing objects
  • Map data by using the Entity SQL Language. Manua...ecute an Entity SQL Query by using EntityCommand
  • Access entity data by using the EntityClient Pro...using EntityDataReaderManaging EntityTransaction