How to get DataTable records in to list using lambda expression?

Question

In given code I have written lambda expression but it shows an error that -- Can't convert lambda expression to type 'string' because it is not a delegate type.

        EmployeeDataOperation emp = new EmployeeDataOperation(); //Class to perform CRUD operation.

        List<EmployeeProp> data = new List<EmployeeProp>();

        dt = emp.getEmployeeData();//return datatable with records.

        //I want to use lambda expression to use Datatable data as a list
        data = (from a in dt
                select new EmployeeProp { Name = a.Name, Email = a.Email }).ToList();
        //error near select

        return View(data);

here I have mentioned that I want to use lamda expression. – Ankit Modi May 27 '16 at 06:05 — Ankit Modi, May 27 '16 at 06:05

Hari Prasad · Accepted Answer · 2016-05-26T10:17:40.620

5

You could use either .Field linq extension or index/columnname (ex row["columnname"] to access values from a DataRow. I suggest using Field extension as it even handle nullable types.

data  = dt.AsEnumerable()
  .Select(row=>  new EmployeeProp ()
   {
       Name = row.Field<string>("Name"),
       Email = row.Field<string>("Email ") 
       // Other properties....      
   })
   .ToList();

edited May 26 '16 at 10:17

answered May 26 '16 at 10:05

Hari Prasad

16,716
4
21
35

score 0 · Answer 2 · edited May 26 '16 at 17:05

0

 var myData = (from a in dt.AsEnumerable()
               select new EmployeeProp { 
                   Name = a.Field<string>("Name"), 
                   Email = a.Field<string>("Email") 
              }).ToList();

edited May 26 '16 at 17:05

Andre Figueiredo

12,930
8
48
74

answered May 26 '16 at 10:10

Cetin Basoz

22,495
3
31
39

I just want to try, otherwise, I am using entity framework which will return DbSet<> and easily convert into a list. – Ankit Modi May 26 '16 at 10:13
I missed that you had new EmployeeProp {}. So it would be a List. Yes, a DbSet would be much cleaner and easier, doesn't need this cumbersome string syntax and provides intellisense on fields. If the source is something like MS SQL, MySQL, Sqlite ... then you might as well use Linq To SQL too instead of Linq to EF. – Cetin Basoz May 26 '16 at 10:16

score 0 · Answer 3 · answered May 26 '16 at 10:19

0

you can try this too, make EmployeeProp() object

data = (from a in dt
                select new EmployeeProp() { Name = a.Name, Email = a.Email }).ToList();

answered May 26 '16 at 10:19

visvesan

76
2

How to get DataTable records in to list using lambda expression?

3 Answers3