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
Monday, June 23, 2008
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)};
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)};
Subscribe to:
Posts (Atom)