Simple linq query to DB times out

Hello.

The following query times out.

public IEnumerable<int> GetOrderNumberForOrdersNotProcessed(string key, object value)
        {
            return (from a in _genericAttributeRepository.Table
                    where a.Key == key &&
                          a.Value == value.ToString()
                    select a.EntityId).ToList();
        }

Any idea why?

I need it so i can see if a order has been processed by an external source.

I can only suggest that you execute the 'equivalent' SQL (in a tool like SSMS) to see what happens...

SELECT EntityId FROM GenericAttribute WHERE [Key] = '...' and [Value] = '...'

There are a few things to check. Start by restarting your appPool. Check sql for any locks.

I highly recommend you download and install http://demo.prefix.io/. You can see slow queries as well as other http related stuff.

New York wrote:

That works as it should.