Lambda Expression equivalent of "<>" in from clause of SQL with Join

Question

Can anyone help me? I am not able to convert the following expression in the SQL to equivalent Lambda expression,

ON nextT.TaskID = a.NextTaskID AND a.TaskID <> nextT.TaskID

SQL to be converted

SELECT a.*
FROM            dbo.Action AS a INNER JOIN dbo.Task AS t 
ON t .TaskID = a.TaskID 
INNER JOIN dbo.Task AS nextT 
ON nextT.TaskID = a.NextTaskID AND a.TaskID <> nextT.TaskID //This need to converted

My incomplete attempt to convert expression is as follows

Equivalent Lambda Expression

    var context = new DataClassesDataContext();
    var data = (from a in context.Actions
                join t in context.Tasks on a.TaskID equals t.TaskID
                join nextT in context.Tasks 
on 
.......new {v1 = a.NextTaskID, v2 = a.TaskID} equals new {v1 = nextT.TaskID , v2 = nextT.TaskID}.....<---This is the problem.
                select new vw_NextTask1
                {
                    TaskID = a.TaskID,
                    Task = t.Title,
                    ActionID = a.ActionID,
                    Action = a.Title,
                    NextPhaseID = a.NextPhaseID,
                    NextTaskID = nextT.TaskID,
                    NextTask = nextT.Title,
                          Type = a.Type
                }).ToList<vw_NextTask1>();
    return data;

m1o2 · Accepted Answer · 2016-03-10 10:45:57Z

1

you can add a where clause.

var data = (from a in context.Actions
        join t in context.Tasks on a.TaskID equals t.TaskID
        join nextT in context.Tasks
        where nextT.TaskID != a.TaskID

answered Mar 10, 2016 at 10:45

m1o2

1,6592 gold badges21 silver badges29 bronze badges

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

2 Comments

Shomaail Over a year ago

can we remove all the checks with ON and make all the checks in the where clause. Are these both ways equivalent?

Shomaail Over a year ago

There is a difference b/w condition in Where clause and On clause stackoverflow.com/questions/8311096/…

Collectives™ on Stack Overflow

Lambda Expression equivalent of "<>" in from clause of SQL with Join

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related