ADO.NET Command Strategies
William R. Vaughn · Apress eBooks · 2002
After you get your ADO.NET Connection 1 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. 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.