Is AppId unique in the ItemEntity table?
If so, you can Fetch using a unique constranit:
Adapter example:
DataAccessAdapter adapter = new DataAccessAdapter();
CustomerEntity customer = new CustomerEntity();
customer.CompanyName = "Chop-suey Chinese";
adapter.FetchEntityUsingUniqueConstraint(customer, customer.ConstructFilterForUCCompanyName());
Or you can use adapter.FetchNewEntity(); which accepts a relationPredicateBucket.