70-516 C# : MCPD - Accessing Data with C# .NET Framework 4

Retired. This product is no longer available.

The exam is targeted at software developers who use Microsoft Visual Studio 2010 and ADO.NET 4 to develop the data access layer of an application. The exam cover mapping of data and relationships by using the Entity data Model, managing connection and context, manipulating data and developing the reliable applications.
11 11
MCPD - Accessing Data with C# .NET Framework 4

Here's what you will get

The certifcation requires minimum of one to two years of experience in using a relational database management system. Candidates should have good grasp of ADO.NET 4 coding techniques, ADO.NET Data Services LINQ, LINQ to SQL, SQL, Stored procedures, Database structures/schemas (objects) XML.

Glossary of terms
Pre-assessment Questions
Full Length Tests
Post-Assessment Questions

Videos and How To..

uCertify course includes videos to help understand concepts. It also includes How Tos that help learners with how to accomplish certain tasks.

Video Lessons
Exam FAQs
What is the exam registration fee? USD 150
Where do I take the exam? The Microsoft 70-516 exam is administered by Pearson VUE at testing centers worldwide. Click here to find a testing center near you.
What is the format of the exam? The exam consists of linear, performance based and multiple choice questions.
What are the pre-requisites of the exam? While there are no official prerequisites to take the exam, but both Microsoft and uCertify strongly recommend that the candidate should have a minimum of two to three years of experience developing application components that interact with a variety of data sources and a thorough understanding of relational database concepts.
How many questions are asked in the exam? The exam contains 40-60 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?

Retake Policy for Microsoft 70-516 exam is:

  • Retake vouchers can only be used to retake the same exam that was failed.
  • All vouchers must be used prior to their expiration dates, without exception.
  • Retake vouchers must be used within 30 days of the initial failed exam.
  • There is no waiting period for retaking a failed MCTS exam.
What is the validity of the certification? Microsoft Certified Professional Developer 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-516-CSHARP, click here.
Which certification covers this exam?
What are the career opportunities after passing this exam?
  • Software Developer
  • Application Developer
  • Web Developer
  • Enterprise Developer
  • Windows Developer

Here's what you will learn

  • Map entities and relationships by using the Entity Data Model
  • Map entities and relationships by using LINQ to SQL
  • Create and customize entity objects
  • Connect a POCO model to the Entity Framework
  • Create the database from the Entity Framework model
  • Create model-defined functions
  • Configure connection strings and providers
  • Create and manage a data connection
  • Secure a connection
  • Manage the DataContext and ObjectContext
  • Implement eager loading
  • Cache data
  • Configure ADO.NET Data Services
  • Execute a SQL query
  • Create a LINQ query
  • Create an Entity SQL query
  • Handle special data types
  • Query XML
  • Query data by using ADO.NET Data Services
  • Create, update, or delete data by using SQL statements
  • Create, update, or delete data by using DataContext
  • Create, update, or delete data by using ObjectContext
  • Manage transactions
  • Create disconnected objects
  • Monitor and Collect performance data
  • Handle exceptions
  • Protect data
  • Synchronize data
  • Deploy ADO.NET components
  • DOWNLOADcourse outline
  • INSTRUCTOR ?free evaluation copy
  • Download Course Outline 70-516 C#
  • Request for free evaluation copy for MCPD - Accessing Data with C# .NET Framework 4
  • Customer Testimonials

    I believe in uCertify product. Will try for more exams.
    Good product, like the fact that the material isn't a brain dump, use uCertify for 3-4 days before the exam to focus your study areas.
    I am really happy to use uCertify prepkits. It gave me a broad knowledge with its quality content