DataReader with Column Names

[rsdelapaz]

Hi, guys,

i am using OpenXML and i have OutOfMemory problems because i am trying to export to a Excel file 4 Sheets with more than 100K.

Therefore i would like to try it with MiniExcel, but i am not sure if it's possible to use DataReader with Column Names, not with the name of the column from my SQL query.

Is this the best way to export the Excel file as i have previously described?

Thank you in advace,

Rspaz

[shps951023]

@rsdelapaz
You can make an IEnumerable yield Dictionary method, document link, e.g.

private IEnumerable<IDictionary<string, object>> GetData()
{
	var reader = Connection.ExecuteReader("select 1 keyId,'Jack' name");
	while (reader.Read())
	{
		yield return new Dictionary<string, object>(){
			{"ID",reader.GetValue(0)},
			{"First Name",reader.GetValue(1)},
		};
	}
}

Or you could help me to create a issue, I'll think like dynamic mapping logic to resolve the issue easily.