score:2

Accepted answer
var codes = boxes.select(c => c.inventory.productcode).tolist();
int placeid = (int)model.placeid;

var products = generalcontext.inventory
.join(generalcontext.products,
    invtry => invtry.productid,
    prdct => prdct.productid,
   (invtry, prdct) => new { inventory = invtry, product = prdct })
.where(q =>
    q.inventory.placeid == placeid &&
    q.inventory.inventorystatu == (int)enums.reason.stok &&
    q.product.iswithrecipe == false &&
    codes.contains(q.inventory.parentproductcode))
.tolist();

Related Query

More Query from same tag