Int list returned by LINQ query

Question

I have one table having ID and other attributes.

How can I get list of int of IDs by LINQ query on that table?

Answer 1

Try

var list = from b 
           in MyDataContext.Table
           select b.ID

Answer 2

Use the Select method to project your result into a different format:

var myList = myTable.Select(t => t.ID).ToList();

That should do it, note you can also use the more SQL-like syntax:

var myList = (from t in myTable
             select t.ID).ToList();

EDIT:

Also note, this is C# syntax, if you want a different syntax you need to clarify which language you're using.