score:2

Accepted answer
list<productincategory> uncategorize = await _context.productsincategories
    .where(pic => pic.product.productgroupid == productgroupid)
    .tolistasync();

score:0

.where(pic => products && pic.productid == products.any(p => p.id)
    && pic.productcategoryid == secondary_id)

score:1

list<productincategory> uncategorize = await _context.productsincategories
    .where(pic => products.select(p => p.id).contains(pic.productid)
        && pic.productcategoryid == secondary_id)
    .tolistasync();

score:1

_context.products.where(g => g.productgroupid == product.productgroupid).deletefromquery();

Related Query

More Query from same tag