Lambda Expression for join operation

Question

I have a SQL query which I am performing on two tables.

Here is my query

Select a.cSubGroupName,a.cAddedBy,a.dAddedOn,b.cGroupName 
from sys_Log_Account_SubGroup a,sys_Account_Primary_Group b 
where a.cAuthorizedStatus='Pending'  and a.nGroupCode=b.nGroupCode

I am trying to perform the same query using Lambda expression.

Paul Fleming · Accepted Answer · 2012-07-30 09:20:50Z

2

var query = tA
    .Where(a => a.cAuthorizedStatus == "Pending")
    .Join(tB, a => a.nGroupCode, b => b.nGroupCode, (a, b) => new 
    { 
        cSubGroupName = a.cSubGroupName, 
        cAddedBy = a.cAddedBy, 
        dAddedOn = a.dAddedOn, 
        cGroupName = b.cGroupName 
    });

or

var query = tA
    .Join(tB, a => a.nGroupCode, b => b.nGroupCode, (a, b) => new 
    { 
        cSubGroupName = a.cSubGroupName, 
        cAddedBy = a.cAddedBy, 
        dAddedOn = a.dAddedOn, 
        cGroupName = b.cGroupName,
        cAuthorizedStatus = a.cAuthorizedStatus
    })
    .Where(j => j.cAuthorizedStatus == "Pending")
    .Select(j => new
    { 
        cSubGroupName = j.cSubGroupName, 
        cAddedBy = j.cAddedBy, 
        dAddedOn = j.dAddedOn, 
        cGroupName = j.cGroupName
    });

Note that the last select is only necessary if you want to explicity exclude the cAuthorizedStatus column in the return set.

edited Jul 30, 2012 at 9:20

answered Jul 30, 2012 at 9:15

Paul Fleming

24.6k8 gold badges79 silver badges113 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Priyank Patel Over a year ago

Thanks for the answer, trying to understand the expression ,thanks.

Paul Fleming Over a year ago

@freebird. The .Join method takes: 1. set to (inner) join on 2. key to join left set on 3. key to join right set on 4. output set (column list).

Collectives™ on Stack Overflow

Lambda Expression for join operation

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related