Summary  
This chapter covers executing a SQL SELECT query with a data reader to retrieve rows that meet a specified condition and iterating through the result set. It demonstrates extracting column values from each row and printing each record in a formatted string.

General domain of usage  
Inventory management

The store owner wants to retrieve a list of all the products that are under `100` in terms of quantity so that they can order more stock in advance.

Your task is to retrieve and display all the products from the `store` table **where the quantity is less than 100**. You have to retrieve all the columns from the selected products. **You need to display each row in the following format:**

```
{id}, {name}, {category}, {price}, {quantity}
```


This course will give you a solid foundation to begin making applications using .NET in C#. Covering console applications, asynchronous programming, web services, database fundamentals, and ADO.NET CRUD operations, you'll gain practical skills. From creating apps and handling exceptions to optimizing database access, this course ensures a robust understanding of essential .NET development concepts.

This module will give you a solid foundation to begin making applications using .NET in C#. Covering console applications, asynchronous programming, web services, database fundamentals, and ADO.NET CRUD operations, you'll gain practical skills. From creating apps and handling exceptions to optimizing database access, this course ensures a robust understanding of essential .NET development concepts.

Challenge: Using SELECT