Use Case:?

• DataReader is ideal when you only need to read the data sequentially and

don’t need to modify the data or navigate backward.

• DataSet is better when you need to work with disconnected data, modify it

offline, and later update the database.

Example (using DataReader for better performance):

SqlCommand command = new SqlCommand("SELECT * FROM Customers",

connection);

connection.Open();

SqlDataReader reader = command.ExecuteReader();

while (reader.Read())

{

Console.WriteLine(reader["CustomerName"].ToString());

}

reader.Close();

When to Use:

• Use DataReader for large result sets where you need fast, sequential data access

without requiring complex data manipulation.

• Use DataSet when you need to work with a disconnected data model or need to

modify data offline.