can anyone solve me for this query

Question

anyone solve this issue

Faisal Pathan · Accepted Answer

something like var orderIds = db.Orders.Where(a => a.QtyBags > 0).Select(a => a.OrderNo).ToArray();   var orders = from map  in  db.Orders   where paertyName =  "Your party name"  && orderIds.Contains(map.OrderNo)   select map;   If it helpes you please accept as an answer.

ejaz mirza · Answer

Thax faisal

ejaz mirza · Answer

please any one can write the linq query for me
select * from orders where PartyName='" + partynameddmain.SelectedItem + "' and OrderNo in (Select OrderNo from OrderBookingDetails where QtyBags>Isnull(DOExecutedQty,0))

Packiaraj Santhiyagu · Answer

Hi,    you comapre one column with one list.     compare columns of two list.

ejaz mirza · Answer

will u write the linq query for this bro

Faisal Pathan · Answer

simple, you are trying to compare tabel with orderno,insted of table just compare orderno.