Linq : select value in a datatable column

Question

How do you use LINQ (C#) to select the value in a particular column for a particular row in a datatable. The equivalent SQL would be:

select NAME from TABLE where ID = 0 

Thanks in advance.

Answer 1

Thanks for your answers. I didn't understand what type of object "MyTable" was (in your answers) and the following code gave me the error shown below.

DataTable dt = ds.Tables[0]; var name = from r in dt            where r.ID == 0            select r.Name; 

Could not find an implementation of the query pattern for source type 'System.Data.DataTable'. 'Where' not found

So I continued my googling and found something that does work:

var rowColl = ds.Tables[0].AsEnumerable(); string name = (from r in rowColl               where r.Field<int>("ID") == 0               select r.Field<string>("NAME")).First<string>(); 

What do you think?

Answer 2

var name = from r in MyTable             where r.ID == 0             select r.Name; 

If the row is unique then you could even just do:

var row = DataContext.MyTable.SingleOrDefault(r => r.ID == 0); var name = row != null ? row.Name : String.Empty;