O'Reilly logo

Sams Teach Yourself ADO.NET in 24 Hours by Paul Bertucci, Jason Lefebvre

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Summary

In this hour, you learned some practical techniques for improving the speed and effectiveness of your application's data access. First, you saw some general techniques for tweaking ADO.NET to achieve faster data access. Then, you learned how to use the Trace object in ASP.NET to locate potential bottlenecks in your application. By using the SQL Query Analyzer, you can find out exactly why a database query is running slowly, and also some ways to improve the speed of the query. Lastly, data caching was used to reduce the number of repetitive calls to the database.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required