Monday, June 23, 2008

LINQ for right outer join and not equal

Hi to all,
Today i got struggle for query right outer join and not equal condition. finally i got result by this way. I have hope this will help to you.

var sorder= (from S in qryGen.T_order
select new { S.F_order_Id, S.F_order_Number }).Except
(from P in qryGen.T_Purchases
join G in qryGen.T_order on P.F_order_Id equals G.F_order_Id
select new { P.F_order_Id,G.F_order_Number });


Please post your comments!

Cheers!
Murali

Saturday, June 21, 2008

LINQ Query with group,join and sum

var gname = from S in qryGen.T_Grn_details
join G in qryGen.T_Grade_Masters on S.F_GradeMaster_Id equals G.F_GradeMaster_Id
where S.F_Grn_Id == int.Parse(cboGRNNumber.SelectedValue.ToString())
group S by new {G.F_GradeName_Id,G.F_GradeName} into d
select new {d.Key.F_GradeName_Id,
d.Key.F_GradeName,
TotalWeight = d.Sum(o => o.F_Weight)};