Is there way to use Distinct in LINQ query syntax?

Question

Is there way to rewrite:

var tbl = ds.TABLES; var q = from c in tbl         select c.TABLE_TYPE; string s = ""; foreach (var item in q.Distinct()) {     s += "[" + item + "]"; }         MessageBox.Show(s); 

So that the Distinct() call is in the LINQ query?

Answer 1

There is no Distinct() method syntax in the language integrated query syntax. The closest you could do would be to move the current call:

var q = (from c in tbl          select c.TABLE_TYPE).Distinct();