Share via

How do I query FreeTextTable() using Entity Frameworks?

David Thielen 3,231 Reputation points
2023-10-09T23:53:54.77+00:00

Hi all;

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.

thanks - dave

Developer technologies | .NET | Entity Framework Core

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.