>>>What's GetAll() ?
>>>
>>I got pointed out to this thread
>>http://stackoverflow.com/questions/16530959/entity-framework-5-get-all-method
>>
>>It was
>>

>>IEnumerable <T> GetAll()
>>         {
>>             return _dbSet;
>>        }
>>

>>I've just changed it to IQueryable in the base classes. Now I'll have to fix all application errors due to this change.
>
>Changing to IQueryable should fix your problem - shouldn't think you'll find many side effects

Hi Viv,

I was discussing this same problem here

https://social.msdn.microsoft.com/Forums/en-US/b0b5ba30-0700-4bcc-97f9-1c55a293f333/ef-and-sql?forum=transactsql

Do you think my last suggestion will work? Because if I just attempt to change, I got too many errors.