|
|
|
| Title | Enhance the performance of the ExecuteReader method in ADO .NET |
|---|
| Keywords | SQL Server, database, ExecuteReader, SqlCommand, OleDbCommand, ADO.NET |
|---|
| Categories | Database |
|---|
|
|
|
You can sometimes improve the performance of the ExecuteReader method by passing it
one of these parameters:
| Parameter | Meaning |
|---|
| KeyInfo | The query returns primary and column key information only |
| SchemaOnly | The query returns column information only |
| SingleRow | The query returns a single row of data |
For more information on database programming in VB .NET, see my book
Visual Basic .NET Database Programming.
|
| |
-->
|
|
