How to convert a data table to a list of strongly typed objects in C# using LINQ?

Question

I am doing a WPF Application written with C# code, My problem is I need to convert a data table from a dataset but sadly it throws me the exception "Cannot convert lambda expression to type 'string' because it is not a delegate type" can you guys please help me with this.(I had the code which throws me the exception)

        SqlDataAdapter da = new SqlDataAdapter(commBuildingSelector);
        DataSet ds = new DataSet();
        da.Fill(ds);
        DataTable myTable = ds.Tables[0];
        List<Building> buildings = new List<Building>();
        buildings = (from bl in myTable
                    select new Building()
                    {
                        BuildingID = bl.BuildingID,
                        BuildingName = bl.BuildingName,
                        isActive = bl.isActive,
                        LastEditDate = bl.LastEditDate,
                        LastEditUser = bl.LastEditUser
                    }).ToList();
        return new List<Building>();

Convert DataTable to Generic List in C#

Sen Jacob
– Sen Jacob

2012-10-24 06:13:38 +00:00
Commented Oct 24, 2012 at 6:13 — Sen Jacob
– Sen Jacob, Commented Oct 24, 2012 at 6:13

Jeff Ogata · Accepted Answer · 2011-10-08 00:44:48Z

4

Use AsEnumerable and Field<T>:

buildings = (from bl in myTable.AsEnumerable()
             select new Building()
             {
                 BuildingID = bl.Field<int>("BuildingID")
                 // etc
             }).ToList();

answered Oct 8, 2011 at 0:44

Jeff Ogata

58k20 gold badges117 silver badges128 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Allan Chua Over a year ago

Gee men you're a heck of genius. thanks this really helps allot to me :)

Jeff Ogata Over a year ago

@Allan Chua, you're welcome. Just as an FYI, if you want to mark an answer as accepted, you can click the checkmark outline next to it. As you ask more questions, a "% accepted" will show up under your name, and people will be more willing to answer your questions if you have a high % accepted number :)

Allan Chua Over a year ago

can you help me again buddy i have a boolean value here that supposed to determine its value from a string(y/n) from the database. IsActive = (rt.Field<string>("IsActive") == "Y" || rt.Field<string>("IsActive") == "y" ? true : false) It always threw me false values can you help me please :)

Khan Aamir Over a year ago

use trim .. there must be some space.

Collectives™ on Stack Overflow

How to convert a data table to a list of strongly typed objects in C# using LINQ?

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related