What steps will reproduce the problem?

SQL 2005/ASP.net 2.0

when seperating the query into parts such as below it causes the addition of DISTINCT twice to the end query

SqlQuery objQuery = new Select().Distinct(); if (Top != null) { objQuery = objQuery.Top(Top); } objQuery .From(Tables.CrvEvent) .Where(CrvEvent.Columns.EventDate) .IsGreaterThan(DateTime.Today) .And(CrvEvent.Columns.EventHasBeenUpdateByClub) .IsEqualTo(true) .OrderAsc(CrvEvent.Columns.EventDate);

I forgot to add: this only occurs when using .Top and .Distinct together.

Have you updated to latest trunk?

I belive canofunk fixed it here: http://code.google.com/p/subsonicproject/source/detail?r=521

hi, thanks for the quick response - i havent updated to the latest trunk as this is a relatively large-sized commercial project and am hesitate to use a non-point release.

is the latest source relatively bug-free?