Fix: "The required column 'X' was not present in the results of a 'FromSql' operation" in EF Core 11
EF Core throws this when your raw SQL does not return every column the entity maps to, or the column names do not match. Return all mapped columns with matching names, or query a scalar/keyless type instead.