This document presents some general guidelines to help you improve the performance of your .NET applications.
In addition, it contains C# code examples that illustrate best practices for optimizing performance, including:
- Determining connection requirements leads to better data source design and more effective use of connection pooling.
- Using managed code takes advantage of features in the .NET Framework such as security, automatic memory management, and garbage collection.
- Selecting the right .NET objects and methods can optimize resources. For example, choosing whether to use a DataReader or DataSet depends on your production environment. Similarly, using a CommandBuilder object can have drawbacks.
- Using the correct transaction model, managing commits, and retrieving and updating data efficiently can reduce network input/output.
Download the PDF.