In a project I'm working on I have a database (that I cannot modify) with two tables (Item and ItemSupplier). There is no foreignkey in the db. In my EF6 I have created two objects (database first):

```
public class Item {
    public string ItemCode { get; set;}
    public string Description { get; set; }
    public double SalesPrice { get; set; }
}

public class ItemSupplier {
    public string ItemCode { get; set; }
    public string AccountCode { get; set; }
}

```

What I want is a list of `Item` that belongs to a specific supplier. So my idea was to first get a list of `ItemSupplier` and then get the `Item` list using `Any()`:

```
public List<Item> GetItemsByAccountCode(string code)
{
    List<Item> itemList = new List<Item>();
    using(DbEntities context = new DbEntities())
    {
        // Get the list of items of a specific supplier
        List<ItemSupplier> itemSupList = context.ItemSupplier.Where(p => 
                                          p.AccountCode == code).ToList();

        // Get al the items based on the itemSupList
        // Below is not working
        itemList = context.Item.Where(p => itemSupList.Any(x => x.ItemCode));
    }
}

```