views:

159

answers:

1

There seems to be a Bug with the Outer Join statement in SubSonic 3, or maybe it's just my ignorance, but the following craps out:

var Objeto = from t in Table1.All()
             join su in table2.All() on t.Id equals su.Id
             join tab2 in Table1.All() on t.PId equals tab2.Id into gj
             from j in gj.DefaultIfEmpty()
             select new
             {
                 t.Field1,
                 SN = su.Field123,
                 PTN = (j == null ? null : j.FieldABC)
              };

With:

The expression of type 'System.Linq.IQueryable` xxxx is not a sequence
A: 

They already had issues with IQueryable:

Blog Entry

Just for your Information...

bastianneu
dude, this is a comment, not an answer ;)
sebastian
yeah true...i am still looking for an solution. So the Blog Entry is a good starting point...
bastianneu
I haven't found a solution yet to this...
hminaya
seems complicated...
bastianneu
For now the answer seems to be that this is a bug in SubSonic.
hminaya