Entity Framework Contains method and objects

Question

Hi,

Is there a way of using the Contains method in Entity Framework 4 with the actual id of the object?

Take these entities as an example:

public class Order
{
  public int OrderId { get; set; }              // PK
  public string CustomerId { get; set; }        // FK to Customer
}

public class OrderItem
{
  public int OrderId { get; set; }              // PK
  public int ItemId { get; set; }               // PK, FK to Item
}

public class Item
{
  public int ItemId { get; set; }               // PK
  public string ItemName { get; set; }
}

and I want to return a list of all orders that have item '5' in them.

I want to be able to do:

List<Order> orders = db.Orders.Where(m => m.OrderItems.Contains(5)).ToList()

But that won't work because Contains needs an actual OrderItem object.

Thanks

Answer 1

Try this:

List<Order> orders = db.Orders.Where(m => m.OrderItems.Any(i=>i.OrderId==5)).ToList()

OR

List<Order> orders = db.OrderItems.Where(m => m.OrderId==5).Orders.ToList()

Answer 2

var orders = db.Orders.Where(m => m.OrderItems.Any(i => i.OrderId == 5)).ToList();