O'Reilly logo

Programming Microsoft® ADO.NET 2.0 Core Reference, 2nd Edition by David Sceppa

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

Application Design Considerations

Creating a helpful and intuitive user interface is just one of many facets of building an effective Windows-based application. Let’s discuss some important application design considerations.

Fetching Only the Data You Need

As you develop your application, it’s important that you consider how your database will grow. Executing a SELECT ... FROM MyTable query when your application starts up might seem fine while you’re developing the application, but as the table grows in size, fetching the results of the query will take more time. The more data you retrieve, the more time your application will take to retrieve that data.

Take our sample order entry application. As the application starts, it issues queries to retrieve ...

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