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