I think its a bug and not going to be supported by Subsonic. I had the same issue when doing other things here
Jon
2009-07-16 11:49:30
+3
A:
I have a fork for left join that I'll be pulling in the next few days - gimme a week and I'll push another release with this.
Rob Conery
2009-07-19 06:21:01
Hi Rob any update on when this is likely to be fixed?
Naz
2009-08-18 16:53:42
I am also in need of this to be fixed. It seems it still doesn't work! Thanks!
ullmark
2009-09-24 12:54:16
A:
t seems there still isn't a fix in place for this. A simple fix (dirty one albeit) is to create a view that handles the left join and fills the empty data from the right with default data and have SubSonic do a simple join on that view.
I know it's terrible but its a fix for now. I couldn't see dropping SubSonic due to this limitation. I'm sure it will be fixed soon.
used2could
2010-01-25 02:32:58