mwhodges
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 LinqDataSourceSelectEventA rgs.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_ProductServiceNa me, c.TargetActive, d.ProjectClass, c.fk_Planid)
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_ProductServiceNa
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER