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

Posted on 2012-08-10
Medium Priority
Last Modified: 2012-08-15
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)
Question by:mwhodges
LVL 12

Accepted Solution

Kaushal Arora earned 2000 total points
ID: 38283150
Please have a look at this link:


It has all the things in LINQ which you perform in SQL.

Hope it helps you.

Author Closing Comment

ID: 38298312
Great reference site Thanks!

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Suggested Courses

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question