Home Quiz Interview Questions Tip of the day Certification Dot Net SQL Server
Home / dot net / linq-data-table-to-dictionary-c-sharp
Linq - Transform DataTable to Dictionary using C#
3/25/2021 1:59:15 PM


When we need to transform 2 columns of data table to a dictionary, we can use LINQ.

Dictionary is a Key Value Pair collection and Key should be unique.

The generic method ToDictionary has 3 parameters .

  1. Dictionary<string, string> dict = ds.Tables[0].AsEnumerable()
  2. .ToDictionary<DataRow, string, string>(
  3. row => row.Field<string>("COLUMN1"),
  4. row => row.Field<string>("COLUMN2"));