Search code examples
linqsubsonicsubsonic3outer-join

SubSonic Outer Join


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

Solution

  • They already had issues with IQueryable:

    Blog Entry

    Just for your Information...