anyone convert this sql query to linq

Jul 11 2018 4:50 AM

select * from OrderBookingDetails where OrderType='" + ordertypedd.SelectedItem + "' and PartyName='" + partynameddmain.SelectedItem + "'and LEN(RTRIM(ISNULL(Status,'')))=0 and (LEN(RTRIM(ISNULL(OrderConfirmedBy, ''))) > 0) and ((LEN(RTRIM(ISNULL(OrderIssuedBy, ''))) > 0)) and StockLocationName in (" + stloc + ") and OrderNo in (Select OrderNo from OrderBookingDetails where QtyBags>Isnull(DOExecutedQty,0))

Answers (16)

Split a list into sub-lists taking

Using lambda unable to do join, groupby and where in EF Core