How to map datatable to list in c#

public List<T> ConvertToList<T>(DataTable dt)
{
    var columnNames = dt.Columns.Cast<DataColumn>()
            .Select(c => c.ColumnName)
            .ToList();
    var properties = typeof(T).GetProperties();
    return dt.AsEnumerable().Select(row =>
    {
        var objT = Activator.CreateInstance<T>();
        foreach (var pro in properties)
        {
            if (columnNames.Contains(pro.Name))
            {
                 PropertyInfo pI = objT.GetType().GetProperty(pro.Name);
                 pro.SetValue(objT, row[pro.Name] == DBNull.Value ? null : Convert.ChangeType(row[pro.Name], pI.PropertyType));
            }
        }
        return objT;
   }).ToList();
}

Source: stackoverflow.com

Similar codes

11 votes127 views9 answers
Trump
C#
38 votes313 views2 answers
Get mouse position unity
C#Unity
0 vote144 views1 answer
Unity add explosion force
C#
17 votes122 views1 answer
Float c++
C#
0 vote143 views1 answer
Order 3 integers in c#
C#
0 vote141 views1 answer
Disable alt + f4 in c# forms
C#
1 vote146 views1 answer
.net create ienumerable of strings
C#
3 votes190 views1 answer
Unity get speed of object
C#Unity
-2 votes139 views1 answer
Random position unity 2d
C#
0 vote158 views2 answers
JsonConvert.DeserializeObject options camelcasing c# .net
C#