DB.SelectAllColumnsFrom [BUG]

Hi there,

I recently came across a bug when using DB.SelectAllColumnsFrom()

With the following query: 

 string r = DB.SelectAllColumnsFrom<Competition>()
                .From(Competition.Schema)
                .InnerJoin(UserCompetition.Schema)
                .Where(UserCompetition.Columns.UserCompetitionID).IsEqualTo(userCompetitionID)
                .BuildSqlStatement();

It produces: (notice how it is selecting 2x times)

SELECT [dbo].[Competition].[CompetitionID], [dbo].[Competition].[Name], [dbo].[Competition].[IsDeleted], [dbo].[Competition].[OpeningTotal]                  [dbo].[Competition].[CompetitionID], [dbo].[Competition].[Name], [dbo].[Competition].[IsDeleted], [dbo].[Competition].[OpeningTotal]FROM [dbo].[Competition],[dbo].[Competition]
INNER JOIN [dbo].[UserCompetition] ON [dbo].[Competition].[CompetitionID] = [dbo].[UserCompetition].[CompetitionID]
WHERE UserCompetitionID = @UserCompetitionID

Thanks in advance 

Regards DotnetShadow 

Why are you calling From two times?

You can try
DB.Select().From(Competition.Schema)

Calling FROM twice here is the the problem. I had thought about stripping duplicates in the FROM collection, but then that would cause all kinds of problems - especially running a join on a table to itself :).

Interesting issue though - wondering best way to get around it...

Sorry guys my bad I didn't realise the SelectAllColumnsFrom had the FROM part I assumed it was just selecting the columns from a particular table not using it as part of the join

Regards Dotnetshadow