Helpful DataRow/DataTable Extensions

DataTableExtensions.cs

public static class DataTableExtensions
{
  public static List<T> ToList<T>(this DataTable table) where T : new()
  {
    IList<PropertyInfo> properties = typeof(T).GetProperties().ToList();
    List<T> result = new List<T>();

    foreach (var row in table.Rows)
    {
      var item = CreateItemFromRow<T>((DataRow)row, properties);
      result.Add(item);
    }
    return result;
  }

  // Consider moving to DataRowExtensions class
  private static T CreateItemFromRow<T>(DataRow row, IEnumerable<PropertyInfo> properties) where T : new()
  {
    if (properties == null) throw new ArgumentNullException(nameof(properties));
    T item = new T();
    foreach (var property in properties)
    {
      if (row.Table.Columns.Contains(property.Name))
      {
        if (property.PropertyType == typeof(DayOfWeek))
        {
          DayOfWeek day = (DayOfWeek)Enum.Parse(typeof(DayOfWeek), row[property.Name].ToString());
          property.SetValue(item, day, null);
        }
        else
        {
          property.SetValue(item, row[property.Name] == DBNull.Value ? null : row[property.Name], null);
        }
      }
    }
    return item;
  }
}