Left Outer Join Problem in Linq-To-Sql?

My guess is that it's the where clause which is messing you up. Don't forget that cc and ca can be null. Try changing the where clause to: where (cc == null ||!cc.

IsDeleted) && (ca == null ||!ca.IsDeleted) You may also then need to change the projections where you use cc and ca to: CDP = cc == null? 0 : cc. AltAmount, Actual = ca == null?0 : ca.ActualAmount I potentially nicer alternative to the existing where clause is to put the check for IsDeleted into the join: join al in this.Context.Actuals.

Where(x =>!x. IsDeleted) on ytl. Id equals al.AlteredTargets.

YearlyTargetId into cal and the same for the other one. Note that this changes the meaning of the query if Actual values do exist but they're all deleted. I suspect it changes it to what you want the behaviour to be though.

My guess is that it's the where clause which is messing you up. Don't forget that cc and ca can be null. Try changing the where clause to: where (cc == null ||!cc.

IsDeleted) && (ca == null ||!ca.IsDeleted) You may also then need to change the projections where you use cc and ca to: CDP = cc == null? 0 : cc. AltAmount, Actual = ca == null?0 : ca.ActualAmount I potentially nicer alternative to the existing where clause is to put the check for IsDeleted into the join: join al in this.Context.Actuals.

Where(x =>!x. IsDeleted) on ytl. Id equals al.AlteredTargets.

YearlyTargetId into cal and the same for the other one. Note that this changes the meaning of the query if Actual values do exist but they're all deleted. I suspect it changes it to what you want the behaviour to be though...

Thanks a lot, adding the verification in the join clause solved my problem. – Purusartha Apr 14 at 6:46.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.