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

6 votes248 views1 answer
Unity call function on animation end
C#
1 vote276 views1 answer
C# socket bind to localhost
C#
3 votes279 views1 answer
Difference between public and serializefield unity
C#Unity
2 votes245 views2 answers
C sharp or operator in if statement
C#
0 vote264 views1 answer
Convert-integer-to-binary-in-c-sharp
C#
5 votes284 views1 answer
How to change rotate with script unity
C#Unity
36 votes274 views5 answers
How to find length of list c#
C#
2 votes247 views2 answers
How to deactivate objects through scripts in unity
C#
14 votes324 views3 answers
String to int c# unity
C#Unity
4 votes252 views2 answers
How to make particle in unity
C#