Convert DataTable to IEnumerable

by

There’s also a DataSetExtension method called “AsEnumerable()” (in System.Data) that takes a DataTable and returns an Enumerable. See the MSDN doc for more details, but it’s basically as easy as:

dataTable.AsEnumerable()

The downside is that it’s enumerating DataRow, not your custom class. A “Select()” LINQ call could convert the row data, however:

private IEnumerable<TankReading> ConvertToTankReadings(DataTable dataTable)
{
    return dataTable.AsEnumerable().Select(row => new TankReading      
            {      
                TankReadingsID = Convert.ToInt32(row["TRReadingsID"]),      
                TankID = Convert.ToInt32(row["TankID"]),      
                ReadingDateTime = Convert.ToDateTime(row["ReadingDateTime"]),      
                ReadingFeet = Convert.ToInt32(row["ReadingFeet"]),      
                ReadingInches = Convert.ToInt32(row["ReadingInches"]),      
                MaterialNumber = row["MaterialNumber"].ToString(),      
                EnteredBy = row["EnteredBy"].ToString(),      
                ReadingPounds = Convert.ToDecimal(row["ReadingPounds"]),      
                MaterialID = Convert.ToInt32(row["MaterialID"]),      
                Submitted = Convert.ToBoolean(row["Submitted"]),      
            });
}

More Related Contents:

  1. Convert IEnumerable to DataTable
  2. How can I convert a DataTable into a Dynamic object?
  3. ERROR: Cannot convert method group ‘CopyToDataTable’ to non-delegate type ‘System.Data.DataTable’. Did you intend to invoke the method?
  4. Can anyone explain IEnumerable and IEnumerator to me? [closed]
  5. Best way to remove duplicate entries from a data table
  6. How can I add an item to a IEnumerable collection?
  7. How can I turn a DataTable to a CSV?
  8. How I can filter a Datatable?
  9. How to get the index of an element in an IEnumerable?
  10. How to check if IEnumerable is null or empty?
  11. How to bind DataTable to Datagrid
  12. Export DataTable to Excel File
  13. Convert DataTable to CSV stream
  14. Converting from IEnumerable to List [duplicate]
  15. Convert DataTable to generic List?
  16. When a class is inherited from List, XmlSerializer doesn’t serialize other attributes
  17. Merge 2 DataTables and store in a new one
  18. How to concatenate two IEnumerable into a new IEnumerable?
  19. Creating a SQL Server table from a C# datatable
  20. DataTable, How to conditionally delete rows
  21. Why does IEnumerable inherit from IEnumerable?
  22. Return all enumerables with yield return at once; without looping through
  23. Is there an IEnumerable implementation that only iterates over it’s source (e.g. LINQ) once?
  24. Recreating a Dictionary from an IEnumerable
  25. IEnumerable and order
  26. IEnumerable as return type
  27. Finding symmetric difference with LINQ
  28. Why use .AsEnumerable() rather than casting to IEnumerable?
  29. Replacing a DataReader with a DataTable
  30. Convert DataTable to Generic List in C#

Leave a Comment