Convert DataTable to List<T>

c# .net generics datatable
Kris-I picture Kris-I · Sep 15, 2009 · Viewed 230.6k times · Source

I have an strongly typed DataTable of type MyType, I'd like convert it in a List<MyType>.

How can I do this ?

Thanks.

Answer

Yuriy Faktorovich picture Yuriy Faktorovich · Sep 16, 2009

The following does it in a single line:

dataTable.Rows.OfType<DataRow>()
    .Select(dr => dr.Field<MyType>(columnName)).ToList();

[Edit: Add a reference to System.Data.DataSetExtensions to your project if this does not compile]

Related questions

How to get the type of T from a member of a generic class or method?

Let say I have a generic member in a class or method, so: public class Foo<T> { public List<T> Bar { get; set; } public void Baz() { // get type of T } } When I instantiate the class, the …

Read More
ArrayList vs List<> in C#

What is the difference between ArrayList and List<> in C#? Is it only that List<> has a type while ArrayList doesn't?

Read More
A generic list of anonymous class

In C# 3.0 you can create anonymous class with the following syntax var o = new { Id = 1, Name = "Foo" }; Is there a way to add these anonymous class to a generic list? Example: var o = new { Id = 1, Name = "Foo" }; var o1 = new { …

Read More