Datatable data copy to list using linq

Question

I would like to ask for help with this for loop which iterates the rows of a DataTable, that I would like to change into a LINQ query to make it faster. Can anyone assist?

for (i = 0; i < ds.Rows.Count; i++) { if ( m.EmailID.Equals ((ds.Rows[i["email"]).ToString())) { if (dsm.Exists(x => x.WorkOrderId == m.WorkOrderId)) { } else { DesktopSupportTicketModel dstm = new DesktopSupportTicketModel() { BranchId = Convert.ToInt32(ds.Rows[i["BranchID"]), StoreName = ds.Rows[i["Storename"].ToString(), Longitude = float.Parse(ds.Rows[i["Longitude"].ToString()), Latitude = float.Parse(ds.Rows[i]["Latitude"].ToString()), Address = ds.Rows[i["Address"].ToString(),}; dsm.Add(dstm) } } } }

Kindly format the code

sujith karivelil
– sujith karivelil

2017-03-10 05:26:46 +00:00
Commented Mar 10, 2017 at 5:26 — sujith karivelil
– sujith karivelil, Commented Mar 10, 2017 at 5:26

Shakti Prakash Singh · Accepted Answer · 2017-03-10 06:01:48Z

Try Something like this

var dstm = ds.Tables[0].AsEnumerable().Select(dataRow => new newDesktopSupportTicketModel { BranchId = dataRow.Field<string>("BranchId"), StoreName = dataRow.Field<string>("StoreName"), email = dataRow.Field<string>("email"), WorkOrderId = dataRow.Field<string>("WorkOrderId") } ).ToList().Where(x => x.email == m.EmailID && x.WorkOrderId != m.WorkOrderId ).ToList();

Collectives™ on Stack Overflow

Datatable data copy to list using linq

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related