I have a problem when creating lookup from a table with more than 200000 rows.
System.InvalidOperationException: 'AsyncEnumerableReader' reached the configured maximum size of the buffer when enumerating a value of type 'Microsoft.EntityFrameworkCore.Internal.InternalDbSet
1[--my model--]'. This limit is in place to prevent infinite streams of 'IAsyncEnumerable<>' from continuing indefinitely. If this is not a programming mistake, consider ways to reduce the collection size, or consider manually converting 'Microsoft.EntityFrameworkCore.Internal.InternalDbSet1[--my model--]' into a list rather than increasing the limit.
I've read Lookup to large Dataset (CRUD pages) times out and I've checked the option when creating the page.
Are there any workaround for me?