ADO.NET ( .NET Database) CMP945

Register for a Class

Course Description:

This class is taught using C# language. The ActiveX Data Objects (ADO) .NET is comprised of the Connection, Command, DataReader / DataSet, and DataAdapter objects. These objects will be used in various examples and classroom exercises to process data from a local database. Specific course topics include relational database structure, disconnected data, and Structured Query Language (SQL); a mixture of SQL queries of increasing complexity will be demonstrated using a SQL test program. A sample relational data base application will be used as an example to explain and demonstrate the adding, viewing, updating, and deleting of the data and the underlying relationships.

Prerequisites: C# Foundation Skills with ASP.NET or equivalent experience.

Textbook: Please bring your textbook to the first class session. See MC Bookstores for more information on your textbook, bring to first class along with a USB Flash Drive/memory stick (at least 512 MB).

Classroom hours: 15
Course Objectives:

This course introduces the ADO.NET wizards and the ADO.NET objects. Emphasis is placed on the ADO objects and the disconnected dataset architecture of ADO.NET. The Connection, Command, Dataset, and DataAdapter objects are used to access and update local relational databases.

Course Outline: