in my MVC 3 project I'm usint the MySQL connector. When I try to invoke that method, I get the Specified method is not supported error. Why ?
public IList<Order> GetOrders()
{
return (from x in db.Order
where (x.Address.FirstOrDefault() != null)
orderby x.Created //it's a DateTime
descending select x).ToList();
}
edit
I see there's a problem with the x.Address.FirstOrDefault() != null
edit2
That code also works
return (from x in db.Order
from y in db.Address
where (y.OrderID == x.OrderID)
orderby x.Created descending
select x).ToList();