Advertisement

ADO.NET Command Strategies

  • William R. Vaughn
  • Peter Blackburn

Abstract

After you get your ADO.NET Connection1 object instantiated, you’re ready to start running queries. No, your code doesn’t necessarily have to explicitly open the connection to run a query, but you do need a well-written SQL SELECT statement. For the last twenty years, it’s been clear that improving poorly written queries plays a bigger role in best practice designs than any other single issue. The impact of a 100,000 row query on an ADO.NET application is no less serious than in an ADOc application. This chapter shows how to get Visual Studio to construct that optimal SQL query and pass it on to ADO.NET for execution.

Keywords

Select Statement Visual Studio Structure Query Language Action Query Parameter Collection 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Apress 2002

Authors and Affiliations

  • William R. Vaughn
  • Peter Blackburn

There are no affiliations available

Personalised recommendations