views:

151

answers:

0

New to subsonic and having issues figuring it out. I am simply just trying to do a distinct search and any documentation I find is telling me to use the class/method

SubSonic.SqlQuery

Though I am finding out that since I am using the newest version, a lot of the documentation I am finding does not apply. For example, I am getting this query working beautifully using Subsonic.Query.SqlQuery though there is NO distinct method hanging off of it as suggested by what I have seen. Please advice!

    SubSonic.Query.SqlQuery query =
        brickDB.SelectColumns(new string[] { "DomainName" }).From<Web.Data.DB.WebLog>()
        .Where(Web.Data.DB.WebLogTable.DomainNameColumn).IsNotNull();  -> No distinct hanging off of From<>()....