LINQmagick

linqmagick.md

Convert DataTable into a Dictionary

let's assume your dt looks like

|key |value|
|----------|
|your|mum  |

code

Dictionary<string, string> config = (from row in dt.AsEnumerable()
						  select new
						  {
							   key = row.Field<string>("key"),
							   value = row.Field<string>("value")
						  }
						  ).AsEnumerable().ToDictionary(k => k.key, v => v.value);