Cannot convert lambda expression to type 'string' because it is not a delegate type

Question

The error is shown at select when i write next LINQ query:

DataTable dtbl = //...
int count = (from p in dtbl select p.RecordID).Max();

please help me out.

Answer 1

Try this.

int count = dtbl.Max(p => p.RecordID);

Edit:

You can't easily use Linq on a DataTable.

See: LINQ query on a DataTable