Database query performance

We saw in Chapter 6, The .NET Collection, how IEnumerator is different from IEnumerable, and how IEnumerator performs faster than IEnumerable when iterating through an in-memory collection. Now, we will query a database and iterate through the resulting collection using various benchmarked techniques. To do so, we will follow these steps:

1. Add a new class called IEnumeratorVsIQueryable.
2. You will be connecting to a SQL Server database and will have the information you need to keep secret. Your secret.json files do not get checked into version control. So, right-click on the project and select Manage User Secrets from the context menu.
3. A dialog will pop up informing you that additional packages are required. Click on Yes.

Figure 7.3: Dialog Informing you that additional packages are required to manage user secrets

4. Visual Studio will then open the secrets.json file in a new tab. This is where you will add your...