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 vote298 views1 answer
Replace first occurrence of character in string c#
C#
2 votes297 views1 answer
Increase variable C#
C#
0 vote314 views1 answer
Make 2D object move at constant speed unity
C#
0 vote364 views2 answers
Add RowDefinition from cs xamarin
C#
0 vote301 views1 answer
Metadata publishing for this service is currently disabled
C#
50 votes292 views4 answers
Unity how to load a scene
C#
0 vote303 views1 answer
Csvhelper driver c# nuget
C#
49 votes305 views6 answers
Instantiate unity
C#
6 votes316 views3 answers
C# return switch
C#
1 vote317 views1 answer
Undefined constant 'STDIN'
C#