Convert DataRow to Dictionary using LINQ

Question

I need to convert DataRow into Dictionary using LINQ.

The code below will get the DataRow, the next step is I need convert it to dictionary(ColumnName, RowVale)

var WorkWeekData = from data in mWorkWeekData.AsEnumerable ()
            where data.Field<string> ("Code") == code
            select data;

chech this [SO link](http://stackoverflow.com/questions/953919/convert-linq-query-result-to-dictionary) — Pavan Teja, Mar 01 '16 at 05:51

score 46 · Accepted Answer · answered Mar 01 '16 at 05:52

46

It's definitely possible, yes:

var dict = row.Table.Columns
              .Cast<DataColumn>()
              .ToDictionary(c => c.ColumnName, c => row[c]);

answered Mar 01 '16 at 05:52

Rob

26,989
16
82
98

score 1 · Answer 2 · edited Jul 07 '22 at 07:10

1

You 'can' use this approach but when I tried it, hoping to improve performance, I found it was MUCH slower than using the longer solution.

This way:

foreach (DataRow row in dtIn.Rows)
{
    dictionary.Clear();
    foreach (DataColumn dataColumn in dtIn.Columns)
    {
        dictionary.Add(dataColumn.ColumnName, row[dataColumn.ColumnName].ToString());
    }
}

Is much faster than:

foreach (DataRow row in dtIn.Rows)
{
    dictionary = row.Table.Columns.Cast<DataColumn>()
        .ToDictionary(c => c.ColumnName, c => row[c].ToString());
}

edited Jul 07 '22 at 07:10

Gert Arnold

105,341
31
202
291

answered Jul 06 '22 at 14:00

Skattch

11
1

Just a note that you need to account for nullable columns as well. .ToString() will throw an error if your value is DBNull. – Storm Aug 03 '22 at 09:39

Convert DataRow to Dictionary using LINQ

2 Answers2