I'm using dotConnect for Oracle and LinqDataSources to display data in a grid. When checking the dbMonitor I can see that some calls result in INNER JOINS and some in LEFT OUTER JOINS. When for instance I'm using this select parameter in my LinqDataSource:
Code: Select all
Select="new(TransId, Port.Name AS Portal, CreatedDate, UserMobileInf.Msisdn, UserEmail)">
Code: Select all
SELECT [....]
FROM [...] t2
LEFT OUTER JOIN USER_MOBILE_INF t3 ON t2.USER_ID = t3.USER_ID
INNER JOIN PORTS t4 ON t2.PORTAL_ID = t4.PORTAL_ID
WHERE [...]
I hope you can help!
Lasse