convert generic list to datatable using linq..?

Question

List<Employee> objEmpList = new List<Employee>();
    for (int i = 0; i < 5; i++)
    { 
        objEmpList.Add(new Employee(){ID=i, Name="aa" + i});
    }

I want to create table with generic list items as rows using linq or lambda expressions...How to do that..??I did that using loops but I want do that using linq..!

Did what using loops? You didn't do anything using loops that was an attempt to what you want to do? — LukeHennerley, Feb 21 '13 at 14:06

Sergey Berezovskiy · Answer 1 · 2013-02-21T14:17:23.223

9

Use CopyToDataTable extension. See msdn article How to: Implement CopyToDataTable Where the Generic Type T Is Not a DataRow

DataTable table = objEmpList.CopyToDataTable();

BTW here is simpler way to create list of employees:

Enumerable.Range(0,5)
          .Select(i => new Employee { ID = i, Name = "aa" + i })
          .ToList();

Consider also using NBuilder:

Builder<Employee>.CreateListOfSize(5).Build()

edited Feb 21 '13 at 14:17

answered Feb 21 '13 at 14:08

Sergey Berezovskiy

232,247
41
429
459

@EliGassert yep, especially when you working with databables - you even don't need to write any object shredders – Sergey Berezovskiy Feb 21 '13 at 14:11
Yes, with the assumption that `Employee` is a `DataRow`. Or maybe I don't anderstand the sentence in question. He want to create firstly rows from list of objects or these objects are data rows. – Ryszard Dżegan Feb 21 '13 at 14:15
@yBee nope, see the linked article which shows how custom `CopyToDataTable` extension method implemented – Sergey Berezovskiy Feb 21 '13 at 14:19

convert generic list to datatable using linq..?

1 Answers1