Book Image

High-Performance Programming in C# and .NET

By : Jason Alls
Book Image

High-Performance Programming in C# and .NET

By: Jason Alls

Overview of this book

Writing high-performance code while building an application is crucial, and over the years, Microsoft has focused on delivering various performance-related improvements within the .NET ecosystem. This book will help you understand the aspects involved in designing responsive, resilient, and high-performance applications with the new version of C# and .NET. You will start by understanding the foundation of high-performance code and the latest performance-related improvements in C# 10.0 and .NET 6. Next, you’ll learn how to use tracing and diagnostics to track down performance issues and the cause of memory leaks. The chapters that follow then show you how to enhance the performance of your networked applications and various ways to improve directory tasks, file tasks, and more. Later, you’ll go on to improve data querying performance and write responsive user interfaces. You’ll also discover how you can use cloud providers such as Microsoft Azure to build scalable distributed solutions. Finally, you’ll explore various ways to process code synchronously, asynchronously, and in parallel to reduce the time it takes to process a series of tasks. By the end of this C# programming book, you’ll have the confidence you need to build highly resilient, high-performance applications that meet your customer's demands.
Table of Contents (22 chapters)
1
Part 1: High-Performance Code Foundation
7
Part 2: Writing High-Performance Code
16
Part 3: Threading and Concurrency

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

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