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

1 vote203 views1 answer
Unity click on 2d object
C#Unity
1 vote152 views1 answer
Monogame fullscreen
C#
8 votes205 views1 answer
Round to float unity
C#Unity
4 votes349 views1 answer
Raycast from camera to mouse unity
C#
0 vote136 views1 answer
Range to 01
C#
0 vote155 views1 answer
Set teh screen rect of camera unity
C#
0 vote168 views1 answer
C# .net 3.5 post json httpclient
C#
0 vote198 views1 answer
Unity check if swipe not tap
C#Unity
0 vote150 views1 answer
What is napalm made of
C#
1 vote133 views1 answer
Protected override void OnExiting(Object sender, EventArgs args) { base.OnExiting(sender, args); Environment.Exit(Environment.ExitCode); }
C#