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

12 votes169 views2 answers
Doing void when gameobject setactive unity
C#Unity
1 vote105 views1 answer
C# mongodb update multiple fields
C#
0 vote120 views1 answer
C# show list in richtextbox
C#
0 vote140 views1 answer
Unity get velocity at point
C#Unity
3 votes135 views1 answer
Unity pause animator
C#Unity
3 votes100 views1 answer
There is already an open DataReader associated with this Command which must be closed first c#
C#
0 vote151 views1 answer
Shut game unity
C#Unity
0 vote113 views1 answer
Process method in scala
C#
11 votes162 views3 answers
C# return two values
C#
0 vote70 views1 answer
Transform face player unity
C#