lambda expression to get first value where

Question

I am running this query

dr[0] = dt.AsEnumerable()
    .Where(l => l.Field<int?>("ID") == "5")
    .Select(l => new {k = l.Field<int?>("description")})
    .First()
    .ToString();

I am trying to get the description where id = 5. But it is giving error

Specified cast is not valid.

What is wrong with this query ?

Answer 1

Check your field types - For "ID" you are comparing int to string... for "description" you are casting to an int which also doesn't look correct.