Link to home
Start Free TrialLog in
Avatar of mwhodges
mwhodgesFlag for United States of America

asked on

How can I do an outer join in the LinqDataSourceSelectEventArgs.Result function

I am trying to run a query that will get results from both tables in the LinqDataSourceSelectEventArgs.Result.  I am including my query any help would be greatly appreciated.  Thanks in advance

 Dim qry = (From c In db.tblTable1 Join d In db.tblTable2 On c.ProductServiceName Equals d.ServiceName
        Where (c.fk_Planid = intInitial)
                    Select c.pkTargetPlanID, d.Product_ProductServiceName, c.TargetActive, d.ProjectClass, c.fk_Planid)
ASKER CERTIFIED SOLUTION
Avatar of Kaushal Arora
Kaushal Arora
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mwhodges

ASKER

Great reference site Thanks!