Use a Dictionary to store results from a DataReader

Quick way to get a DataReader result into a Dictionary:


while (dr.Read())
{

Dictionary<string, object> surveyDict = new Dictionary<string, object>();

aDict = Enumerable.Range(0, dr.FieldCount).ToDictionary(dr.GetName, dr.GetValue);

}


 

 

Advertisements
Use a Dictionary to store results from a DataReader

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s