ADO.NET Command Strategies
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.
KeywordsSelect Statement Visual Studio Structure Query Language Action Query Parameter Collection
Unable to display preview. Download preview PDF.