I understand using FromSqlRaw() to pass in the query that returns the list of records that FreeTextTable returns (PK, Rank). But how do I get a List of those records?
I think Keyless Entity Types is the way to do this. But everything I've read on these says there's a matching underlying view for the type. In this case, there is no view.
Do I have to fall back to ADO.NET calls? I'm very familiar with ADO.NET so no problem using it. But if there's an EF approach, I'd prefer that.