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 ...

Get Programming Microsoft® ADO.NET 2.0 Core Reference, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.