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

0 vote143 views1 answer
Unity color by rgb
C#Unity
0 vote92 views1 answer
Guicontrol text ahk
C#
0 vote276 views1 answer
How to make text show a variable in unity
C#Unity
5 votes123 views2 answers
How to deactivate an object unity
C#Unity
0 vote104 views2 answers
How can I display image from database in asp.net mvc. I created image table and image path as varchar
C#
0 vote97 views1 answer
Deleting an item from a vector c#
C#
7 votes96 views6 answers
C# how to exit program
C#
1 vote104 views1 answer
Mvc list to jsonresult
C#
0 vote100 views2 answers
How to close a form c#
C#
0 vote95 views2 answers
Write N lines with M numbers each that describe the layout of the second layer in the way shown above
C#