Convert data table to generic list

Published by Mritunjay Kumar, Mindfire Solutions, about 5 years ago.

1674 Views

code block for converting a data table to generic list of custom class object.

public static List<T> ToList<T>(this DataTable table) where T : class, new()
{
    var list = new List<T>();
    foreach (var row in table.AsEnumerable())
    {
        var obj = new T();
        foreach (var prop in obj.GetType().GetProperties())
        {
            var propertyInfo = obj.GetType().GetProperty(prop.Name);
            propertyInfo.SetValue(obj, Convert.ChangeType(row[prop.Name], propertyInfo.PropertyType), null);
        }

        list.Add(obj);
    }

    return list;
}

Discussion

25 - Five

** To prevent abusing comments from publishing, posted comments will be reviewed and then published!

Mritunjay Kumar

Works at Mindfire Solutions

I mostly work with C#, ASP.NET, MVC, WCF, Web API, Entity FrameWork, MS Sql.

More under this category...

Extension method to convert a delimited string to list of generic primitive type

Published by Mritunjay Kumar , Mindfire Solutions, about 5 years ago 1504 Views

Convert generic list to data table

Published by Mritunjay Kumar , Mindfire Solutions, about 5 years ago 2163 Views

Generate random string from set of fixed chars

Published by Mritunjay Kumar , Mindfire Solutions, about 5 years ago 1833 Views

Google cloud storage API - Rename a file

Published by Mritunjay Kumar , Mindfire Solutions, about 5 years ago 2203 Views

Initializing X509Certificate2, Windows 2012 + IIS8 + .Net 4.5

Published by Mritunjay Kumar , Mindfire Solutions, about 5 years ago 1988 Views

Google cloud storage API - upload file with progress bar

Published by Mritunjay Kumar , Mindfire Solutions, about 5 years ago 6 if (6 > 1) { Comments } else { Comment } 6666 Views

Google cloud storage API - download file with progress bar

Published by Mritunjay Kumar , Mindfire Solutions, about 5 years ago 4 if (4 > 1) { Comments } else { Comment } 6102 Views

All under this category...