Entity Framework Core - Knowledge Base (KB)

Using SqlQuery<Dictionary<string, string>> in Entity Framework 6

I'm trying to execute a SQL query in EF 6. The ...select... query returns two string columns, e.g. ...select 'a', 'b'..., and can have any number of rows....I'd like to map the result to a dictionary, but I can't get ride of the following error....Error ...

EF Core: use a dictionary property

Is there a way to fill a dictionary property with Entity Framework Core?...For performance reasons, we like to search in the application instead of the database. As a list won’t scale well, we like to use a dictionary....For example (simplified example)...