Admission
This course is essential for trainees aspiring to build database applications.
ADO.NET 3.5 Core
Exam # |
Duration |
Language |
Level |
Type |
Classroom |
Code |
Fees |
-- |
15 |
English |
Core |
Course |
Classroom |
Cs476 |
0 LE |
Description :
This course provides a comprehensive introduction to ADO.NET 3.5. It is intended to qualify trainees to build desktop database application using Visual C# 2008. However, the information and skills acquired in this course could be easily utilized to create other types of applications that connect to a database or other data sources.
Objectives :
-
Describe ADO.Net Architecture and Object Model
-
Connect to SQL and other data sources
-
Perform connected database operations
-
Perform disconnected database operations
-
Implement multiple DataView
-
Implement transactions
Topics :
Introduction to ADO.NET
-
What is ADO.NET?
-
ADO.NET and the .NET Framework
-
ADO.NET components
-
.NET Framework Data Providers
-
ADO.NET object model
-
Connected objects
-
Disconnected objects
Connecting to Data Sources
-
Specifying the data source
-
Specifying the server and the database
-
Choosing the database objects
-
Programmatic connection
-
Creating connection objects
-
Managing the connection
-
Establishing and testing the connection
-
Customizing connection strings
Retrieving Scalar Values and Result Sets
-
Instantiating the command object
-
Specifying the SQL statement
-
Executing the command
-
Retrieving a re
-
sult set
-
Specifying the SQL query command
-
Reading the result set
Working with DataSets
-
What is a DataSet?
-
DataSet object model
-
DataSet versus DataTables
-
DataColumns and DataRows
-
DataSets properties & constraints
-
Filling DataSets manually
-
Filling DataSets programmatically
-
Finding data in DataSets
-
Relational DataSets
-
Creating relations between DataTables
Working with DataAdapters
-
What is DataAdapter?
-
DataAdapter structure
-
Filling DataSets with fetched data
-
Updating data sources with DataSets
Working with DataViews
-
What is DataView?
-
Creating a DataView
-
Manipulating data through DataViews
-
Converting a DataView to a DataTable
DataSets & Data Sources Integration
-
Manipulating disconnected data
-
SqlCommandBuilder object
-
Sending disconnected data to applications
ADO.NET Transactions
-
ACID properties
-
Connected mode transactions
-
Disconnected mode transactions
-
Implementing transactions
Recommended Knowledge :
This course requires having basic skills using Microsoft Windows operating system (Version XP or any later version). It also requires reasonable understanding of object-oriented programming concepts, SQL Server 2008, .NET Framework 3.5 and Visual C# 2008.
Recommended Course(s) :
SQL Server 2008 Core
Visual C# 2008 Core
Training Materials :
EnterCaps Official Courseware
Labs :
This course includes several labs to ensure you will gain the targeted skills and experience.
Credential :
This course is an essential part of EnterCaps Professional Diploma in Programming
Category :
Programming
The Instructor: