NET has to dedicate less resources to managing the internal record pointer and can speed up access.
Another beautiful thing about using a Reader to move through data is because they are “forward only”.
Since you can only move to the next record at a time and can’t go back, .
One great place to find connection string data for tons of different databases is at
I am using a local instance of an access database that doesn’t require any real credentials to access. Ole Db namespace so we get to use Ole Db Connection as well as other classes you will see later.
The Data Adapter will use our connection (a well???