Introduction to ADO.NET
o What is ADO.NET?
o ADO.NET and the .NET Framework
o ADO.NET components
o .NET Framework Data Providers
o ADO.NET object model
o Connected objects
o Disconnected objects
Connecting to Data Sources
o Specifying the data source
o Specifying the server and the database
o Choosing the database objects
o Programmatic connection
o Creating connection objects
o Managing the connection
o Establishing and testing the connection
o Customizing connection strings
Retrieving Scalar Values and Result Sets
o Instantiating the command object
o Specifying the SQL statement
o Executing the command
o Retrieving a re
o sult set
o Specifying the SQL query command
o Reading the result set
Working with DataSets
o What is a DataSet?
o DataSet object model
o DataSet versus DataTables
o DataColumns and DataRows
o DataSets properties & constraints
o Filling DataSets manually
o Filling DataSets programmatically
o Finding data in DataSets
o Relational DataSets
o Creating relations between DataTables
Working with DataAdapters
o What is DataAdapter?
o DataAdapter structure
o Filling DataSets with fetched data
o Updating data sources with DataSets
Working with DataViews
o What is DataView?
o Creating a DataView
o Manipulating data through DataViews
o Converting a DataView to a DataTable
DataSets & Data Sources Integration
o Manipulating disconnected data
o SqlCommandBuilder object
o Sending disconnected data to applications
ADO.NET Transactions
o ACID properties
o Connected mode transactions
o Disconnected mode transactions
o Implementing transactions
