What is easiest way to retreive one column's values using SubSonic (Column isn't primary)

Question

I'm using AcriveRecord in SubSonic 3.0.0.3 with MySql. Is there some easy way to perform something like "SELECT CustomerAddress FROM customers" rather than .All() which performs "SELECT * FROM customers"? And how to get distinct values?

Answer 1

var qry= from c in Customer.All()
         select new {
            c.CustomerAddress
         }