I used the following query to limit data read from a database log:
logViewModel.LogEntries = db.LogEntries.Skip(count-1000).OrderByDescending(x => x.EventTime).ToList();
And I got the error as in the title.
It seems that Linq.Skip is not supported with tables that have a ntext, text or image field.
Stupid me, why did I set up the table with ntext, as I understand it’s going to be removed from the future Sql Server versions anyway.
You can try to go around the problem by converting the Text fields to nvarchar(1234) or similar, but for me the easier way was to drop the table and add it with a nvarchar(1000) field instead.