Under the Table: How Data Access Code Affects Database Performance

Posted: Jul/24/2009 By: pankaj Points:15 Category: .NET - .NET Framework Views:82 Vote Up (0) Vote Down (0)

In this article, the author delves into some commonly used ways of writing data access code and looks at the effect they can have on performance.Bob BeaucheminMSDN Magazine August 2009

View Complete Post

Comments:

Be the first to comment this post.

Post Comment

Please login to post your comment

More Related Resources

Cloud Security: Crypto Services and Data Security in Windows Azure

Many early adopters cloud platforms have questions about security. We review some of the cryptography services and providers in Windows Azure along with some security implications for applications in the cloud.Jonathan WiggsMSDN Magazine January 2010

Code Cleanup: 9 Useful Tactics for Paying Back Technical Debt

Now that you've identified technical debt in your code base, let's turn our attention to some specific tactics that will help you pay back that debt.David LaribeeMSDN Magazine January 2010

Extreme UI: Line Charts with Data Templates

Charles Petzold continues his investigation into robust XAML coding made possible by Windows Presentation Foundation, this time tackling the complicated process of creating line charts.Charles PetzoldMSDN Magazine January 2010

Generation Test: Automated Unit Tests for Legacy Code with Pex

Creating and maintaining a unit test suite for legacy code can be a challenge. Pex automatically produces a small test suite with high code and assertion coverage.Nikhil SachdevaMSDN Magazine December 2009

Code Cleanup: Using Agile Techniques to Pay Back Technical Debt

Every codebase contains some measure of technical debt - code that is maddeningly hard to test and maintain. We outline some ideas for identifying and dealing with the high-interest debt in your code.David LaribeeMSDN Magazine December 2009

Data Access: Building a Desktop To-Do Application with NHibernate

Building an NHibernate-based desktop application isn't any harder than building a web application, and in many cases NHibernate simplifies elements of session handling and concurrency.Oren EiniMSDN Magazine December 2009

Toolbox: Database and OR/M Tools, Oren Eini and Custom Visual Studio Tabs

This month we look at tools for enhancing the LINQ to SQL and Entity Framework designers, Oren Eini's .NET development blog, Visual Studio tab customization, and more.Scott MitchellMSDN Magazine December 2009

Cutting Edge: Live Data Binding in ASP.NET AJAX 4.0

Dino Esposito discusses various forms of client-side data binding as they are coming out in ASP.NET AJAX 4.0, focusing on some advanced features of data binding and observable objects.Dino EspositoMSDN Magazine December 2009

Concurrent Affairs: Data-Parallel Patterns and PLINQ

Multicore processors are now ubiquitous on mainstream desktop computers, but applications that use their full potential are still difficult to write. Version 4 of the .NET Framework will deliver several tools that programmers can employ to make this task easier. This article explores the use of one of those tools: Parallel LINQ (PLINQ).Igor OstrovskyMSDN Magazine December 2009

Toolbox: Database Documentation, API for Pre- and Post-Conditions, Blogs and More

In this month's column, Scott explores one-click database documentation, covers an API for pre- and post-conditions, takes a look at an interesting blog, and reviews the latest book about the ASP.NET MVC Framework.Scott MitchellMSDN Magazine November 2009