supervised and delivers only the official training programs for more than 3000 Courses and 480 Certificates, through 30 dedicated Learning Centers in Egypt, Kuwait, and UAE.....


learning process

partner of the most world's technology leaders such as: Microsoft, Cisco, Math-Works, CompTia, WiMax, CWNP, Oracle, EC-Council, CIW, Symantec, ETS, Parametric, PearsonVUE, and more ...


Warm welcome

WE aimed to improve and develop the human resources to be qualified for job Opportunities. By assure quality through the four basic elements of learning process (Official curriculum, Expert Teaching Staff, Hand-ON labs, Suitable Environment)...


Quality assurance

our quality control and montoring system is added value, allow our customers watching the secure cams 24/7, performance and evaluate the training progress. ...

Nada Youssef
Date: 2012-11-10
nice site... More...
Ahmed Ali
Date: 2012-11-10
I like the site design, it's sweet .. simple ... well organized. Hope to see next projects... More...
Maha el Said
Date: 2012-11-11
Very Helpful and very organized company...it opens its doors for people who are willing to learn and develop their designing abilities.... More...
mohamed saad
Date: 2012-11-28
it\'s very nice website go ahead..... More...

  • Category: Microsoft Office
    Date: 2012-11-12

  • Category: Adobe
    Date: 2012-11-12

  • Category: Adobe
    Date: 2012-11-12

  • Category: Entercaps Traning Center
    Date: 2012-11-11
  • Photoshop CS5-The Missing Manual
    Photoshop CS5-The Missing Manual
  • Photoshop CS6 For Dummies
    A dobe Photoshop is one of the most impo
  • Pro .NET Best Practices
    Pro .NET Best Practices
  • Hardening Cisco Routers
    Hardening Cisco Routers
   ADO.NET 2.0 Advanced


This course suits developer with basic knowledge of accessing data stores using ADO.NET 2.0 and willing to further their skills by learning more advanced techniques.

ADO.NET 2.0 Advanced
Exam # Duration Language Level Type Classroom Code Fees
-- 12 English Advanced Course Classroom Cs125 0 LE
Description :
Microsoft ADO.NET 2.0 represents a major improvement in data access capabilities. This book pick up where the core course left off and dives deep into advanced implementations of the new and old ADO.NET features.


Objectives :
  • Set up trace logging
  • Identify the situation where caching can be used to optimize performance and manage to minimize the effects of stale data.
  • Recognize the security capabilities available for ADO.NET 2.0 and demonstrate ability to use available features to improve security.
  • Identify and differentiate between the available large objects (LOBs) type, and demonstrate ability to implements routines that read and write BLOBs Data.
  • Demonstrate ability to use the available tools that enable dealing with XML data type.
  • Demonstrate understanding for the connection pooling concept.

Topics :

Trace Logging

  • Using the logman.exe Utility
  • Performance Logs and Alerts Snap-In
  • Working with Event Trace Log Files


  • Application Security Overview
  • Partial Trust Support
  • Preventing SQL Injection Attacks
  • Storing Encrypted Connection Strings
  • Using Stored Procedures

Working with Large Objects (LOBs)

  • Storing LOBs
  • Reading BLOBs
  • Writing BLOBs

Working with XML Data

  • Introducing XPath and XQuery
  • The xml Data Type
  • Using XML with ADO.NET

Data Caching and Performance

  • Deciding what to cache
  • Using the SqlDependency class

Advanced Connectivity to the Data Store

  • Connection Pooling
  • Asynchronous Data Access

Recommended Knowledge :

Ability to use one of the .NET Languages and basic knowledge of using ADO.NET 2.0 are two prerequisites to this course.

Recommended Course(s) :
 ADO.NET 2.0 Core
 Visual Basic .NET Core
 Visual C# .NET Core


Training Materials :

Official Courseware

Labs :

This course includes several labs to ensure you will gain the targeted skills and experience.

Credential :

This course is part of EnterCaps Professional Diploma in Programming – Expert Level.

Category :

The Instructor: