How to not return all properties in SqlRaw

[giscus[bot]]

How to not return all properties in SqlRaw

Entity Frameworks SqlRaw has a small, sometimes annoying limitation:
The SQL query must return data for all properties of the entity type.
Sometimes that isn't desireable, so let's overcome that super easy.

https://steven-giesel.com/blogPost/c6bea409-9e49-4915-8529-8a8a8574ba80/how-to-not-return-all-properties-in-sqlraw

[radu-v]

would setting a default value PropB in the record work as well?

[linkdotnet]

The short answer is no. It has to be part of the result set