ADO.NET

ADO.NET (Syllabus)
Chapter 01: Introduction to ADO.NET

1. • Understand what a data provider is.
2. • Understand what a connection object is.
3. • Understand what a command object is.
4. • Understand what a DataReader object is.
5. • Understand what a DataSet object is.
6. • Understand what a DataAdapter object is.

Chapter 02: The SqlConnection Object

1. • Know what connection objects are used for.
2. • Learn how to instantiate a SqlConnection object.
3. • Understand how the SqlConnection object is used in applications.
4. • Comprehend the importance of effective connection lifetime management.

Chapter 03: The SqlCommand Object

1. • Know what a command object is.
2. • Learn how to use the ExecuteReader method to query data.
3. • Learn how to use the ExecuteNonQuery method to insert and delete data.
4. • Learn how to use the ExecuteScalar method to return a single value.

Chapter 04: Reading Data with the SqlDataReader

1. • Learn what a SqlDataReader is used for.
2. • Know how to read data using a SqlDataReader.
3. • Understand the need to close a SqlDataReader.

Chapter 05: Working with Disconnected Data - The DataSet and SqlDataAdapter

1. • Understand the need for disconnected data.
2. • Obtain a basic understanding of what a DataSet is for.
3. • Learn to use a SqlDataAdapter to retrieve and update data.

Chapter 06: Adding Parameters to Commands

1. • Understand what a parameter is.
2. • Be informed about the benefits of using parameters.
3. • Learn how to create a parameter.
4. • Learn how to assign parameters to commands.

Chapter 07: Using Stored Procedures

1. • Learn how to modify the SqlCommand object to use a stored procedure.
2. • Understand how to use parameters with stored procedures.

for more information mail us bhupentiwari@gmail.com