subsonic distinct

Code
try
            {
                string selectList = string.Format("{0},{1}", Infomation.TitleColumn.ColumnName, Infomation.AddressColumn.ColumnName);
                Query q = new Query(Infomation.Schema).SetSelectList(selectList).DISTINCT().ORDER_BY(Infomation.TitleColumn.ColumnName);

                string sql = q.GetSql();
                InfomationCollection infos = new InfomationController().FetchByQuery(q);
                listBox1.DisplayMember = Infomation.AddressColumn.ColumnName;
                listBox1.DataSource = infos;
            }
            catch (Exception ex)
            {

                throw ex;
            }

需要调用方法.SetSelectList(selectList)，即指定需要检索的列，不然不会实现distinct功能

转载于:https://www.cnblogs.com/joe-yang/archive/2009/05/16/1458242.html