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 scenario
· Disconnected scenario
Working with Data Sources - Connected scenario
· Preparing connections by using SQLConnection Class
· Querying data by using SQLDatareader Class
· Making data modifications by using SQLCommnd Class
· Controlling concurrency transactions by using SQLTransaction Class
Working with Data Sources - Disconnected scenario
· Working with DataSet Class
· Creating DataColumns, DataRows, Data relations in DataSet Class
· Working With DataAdapter
· Filtring data by using databinding, DataView .
· Binding Data Controls
Working with Data Sources - Data Entity Model
· Retrieving data by using Linq
Making data modification using DEM.