I have spent a good long time looking at solutions on the web and can't seem to find any solution to fit my situation.
What I'm trying to do is grab 2 specific columns in my datatable with LINQ.
Here's a couple things that I have tried:
var query = dt.ASEnumerable().SELECT(s=>s.Field<int>("tablename")); - query returns no results. It says that the specified cast is not valid.
I have also tried many "from,select" queries and they yield no results either. I don't need to include any where clauses.
Would anyone happen to have any insight into how to get a result from LINQ?