SubSonic 3 LeftOuterJoin

Posted by michaelpearce on Stack Overflow See other posts from Stack Overflow or by michaelpearce
Published on 2010-05-30T23:48:20Z Indexed on 2010/05/30 23:52 UTC
Read the original article Hit count: 220

Filed under:

subsonic3

I have read in this forum that left outer join syntax is not supported by subsonic in an answer to a question on the topic by "Apocatastasis".

I have the same issue in that when I create a query using the .LeftOuterJoin the resulting sql has an inner join rather than a left outer join.

Can someone please confirm that LeftOuterJoin is indeed not supported and, if that is the case, why is it included in the active record syntax?

Thanks Michael

Related posts about subsonic3

How to log subsonic3 sql

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I'm starting to develop a new asp.net application based on subsonic3 (for queries) and log4net (for logs) and would like to know how to interface subsonic3 with log4net so that log4net logs the underlying sql used by subsonic. This is what I have so far: public static IEnumerable<arma_ocorrencium>… >>> More
Left Join in Subsonic3

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi there, I'm new in subsonic3, and I'm getting some errors when I try to use LeftJoin var q = from c in categories join p in products on c equals p.Category into ps from p in ps.DefaultIfEmpty() select new { Category = c, ProductName = p == null ? "(No products)" : p.ProductName… >>> More
Help with Subsonic3 ActiveRecord LINQ query

as seen on Stack Overflow - Search for 'Stack Overflow'
I have the following subsonic entities TInvoiceHeader TAccountAssociation How can I achieve the following in LINQ (subsonic) SELECT * from TInvoiceHeader WHERE custid IN (SELECT custid FROM TAccountAssociation WHERE username = 'a') I need to bind the results to a GridView. >>> More
Help with Subsonic3 LINQ query

as seen on Stack Overflow - Search for 'Stack Overflow'
I have the following subsonic entities TInvoiceHeader TAccountAssociation How can I achieve the following in LINQ SELECT * from TInvoiceHeader WHERE custid IN (SELECT custid FROM TAccountAssociation WHERE username = 'a') I need to bind the results to a GridView. >>> More
Using constructor to load data in subsonic3?

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm getting an error while trying to load an record through the constructor. The constructor is: public Document(Expression<Func<Document,bool>> expression); and i try to load a single item in like this var x = new Document(f=>f.publicationnumber=="xxx"); publicationnumber isn't… >>> More

Developer IT

SubSonic 3 LeftOuterJoin - Developer IT

SubSonic 3 LeftOuterJoin

subsonic3

Related posts about subsonic3

How to log subsonic3 sql

Left Join in Subsonic3

Help with Subsonic3 ActiveRecord LINQ query

Help with Subsonic3 LINQ query

Using constructor to load data in subsonic3?

Categories cloud