Dear,
I have following table
itemstatus(id, itemcode, itemstatus) with values
1,E123, Expired
2,E123, ReturnedToAgency
3,E124, Expired
4,E124,ReturnedToAGency
5,E125, Delivered
5,E126, Expired
5,E127, Stored
5,E128, Expired
5,E129, Expired
5,E129, REturnedToAgency
5,E130, Delivered
from this, I want to fetch the itemcode with item status "Expired" but it doenst have row with "returned toagency". From the above table, it should show E126, E128. and it should not show E123,E124,E129 because its has also has rows with status "Returned To Agency".
How can write an entity framework query to fetch this
Please help me
regards
Azeem