Stop using strings in Entity Framework Core !
Just stop.
Because Brent told you to.

Unless you specify the length of the string.
It is even ok to say it is 2GB long, if it really is that long.

It is all about how much RAM your server has, and how it is used.
NVARCHAR(MAX) columns are difficult to work with (no indexing, use too much RAM).

Read Brent Ozar's entire blog post here:

https://www.brentozar.com/archive/2025/01/i-feel-sorry-for-untrained-developers-using-entity-framework/

Worth a read (as always).