Program Overview

ITE503 ADO.NET Application Development

This subject gives students the skills required to use Microsoft Visual Studio to develop data-access portions of applications.

Subject Information

Grading System

The grading system for this subject is SY/US.

Duration

The duration of this subject is one session.

School

This subject is offered by the School of Computing and Mathematics."

Enrolment Restrictions"

This subject is available only to students in the Master of Systems Development, Graduate Certificate in Systems Development, Graduate Certificate in Account Management, and Master of Management (IT).

Prerequisites

The prerequisite for this subject is ITI500.

Learning Outcomes

Upon successful completion of this subject, students should:

• be able to connect to a data source
• be able to diagnose database connection exceptions
• be able to query data from data sources
• be able to retrieve source data
• be able to execute an asynchronous query
• be able to query data sources using LINQ
• be able to manage exceptions
• be able to manage transactions
• be able to manage data integrity issues
• be able to update data
• be able to monitor event notifications
• be able to manage update conflicts
• be able to partition data for synchronization
• be able to map data by using the Entity SQL Language
• be able to access entity data by using the EntityClient Provider

Syllabus

This subject will cover the following topics:

• Connecting to Data Sources
• Selecting and Querying Data
• Modifying Data
• Synchronizing Data
• Working with Disconnected Data
• Object Relational Mapping by Using the Entity Framework