LINQ to DataSet to get generic list from DataTable

Question

DataTable table = DataProvider.GetTable()

var clientIds = from r in table.AsEnumerable()
                select r.Field<string>("CLIENT_ID");

I want clientIds to be a List<string>. Currently it's an EnumerableRowCollection<>

What am I missing?

Answer 1

this may work

DataTable table = DataProvider.GetTable()

var clientIds = (from r in table.AsEnumerable()
                select r.Field<string>("CLIENT_ID")).ToList();