How to take the UNIQUE or first Row

Epicor ERP 10
1

Would someone please show me how can I take the first row out of this query or get the UNIQUE values in this query.

var kquery = (from OrderH in Db.OrderHed
join OrderD in Db.OrderDtl on OrderH.OrderNum equals OrderD.OrderNum
join OrderR in Db.OrderRel on OrderH.OrderNum equals OrderR.OrderNum
join ShipT in Db.ShipTo on OrderH.ShipToNum equals ShipT.ShipToNum
where (
(string.Compare(OrderD.Company, callContextClient.CurrentCompany, true ) == 0) &&
(string.Compare (OrderH.Company, callContextClient.CurrentCompany, true) == 0) &&
( (int)OrderH.OrderNum == (int)OrderHeaderXRow2.OrderNum) &&
( (int)OrderD.CustNum == (int)ShipT.CustNum )
)
select new {
HCompany = OrderH.Company
,HOrderNum = OrderH.OrderNum
,HCustNum= OrderH.CustNum
,HOTSState = OrderH.OTSState
,HOTSCountryNum = OrderH.OTSCountryNum
,HUseOTS = OrderH.UseOTS
,HShipToNum = OrderH.ShipToNum
,HCheckBox07 = OrderH.CheckBox07
,HCheckBox08 = OrderH.CheckBox08
,HCheckBox19 = OrderH.CheckBox19
,HCheckBox20 = OrderH.CheckBox20
,RCheckBox17 = OrderR.CheckBox17
,SState = ShipT.State
,SCountry = ShipT.Country

}).ToList();

2

To get unique values, you can just add a Distinct() call before your ToList():

(LINQ query).Distinct().ToList();
2 Likes
3

THANK YOU VERY much …

4

Remember to mark it as solution if it is the solution @windowsmanager

1 Like