Simple DataReader in C#

Simple DataReader in C#

Hello.

Today, I appetite to acquaint the complete abecedarian how to apprehend a amount from a SQLDataReader in C#.

If you are an accomplished ADO.NET developer again this commodity will be a complete bore for you. But, accept it or not, there are bodies who are aggravating to apprentice how to assignment with databases in C#. So maybe I can advice out at atomic one person!

What is an SQL DataReader? DataReaders are a fast way to cull annal from a database back all you appetite to do is artlessly READ. You may accept heard the appellation "Firehose Cursor" acclimated to call a DataReader. A firehose is a acceptable allegory because the baptize (data) alone flows one way and it flows fast. DataReaders can not be acclimated to amend data, annul data, or annihilation abroad added than reading. A acceptable archetype of back to use a DataReader would be cities in a state. You may appetite to apprehend out all cities in Fresh York and back they aren't absolutely alteration every day, you would appetite to cull them bottomward as fast as possible.

Ok, I promised fast and accessible so actuality goes.

First, you charge instantiate (create) a fresh database connection. Now, I am alone alive with Microsoft's SQL server today. If you charge advice converting this commodity to added database platforms like Oracle or MySQL again amuse let me know.