EF: The text data type cannot be selected as DISTINCT because it is not comparable

Simple answer is “don’t use text”.

It was deprecated for varchar(max) years ago when SQL Server 2005 was released.

The code you have is issuing SELECT DISTINCT.
You need to fix the model/tables so it isn’t text datatype