Custom Entity Object from Database View

Today's concept-of-the-day: the Entity Framework DefiningQuery.

The DefiningQuery is a customizable XML element in the EF edmx file that allows one to map a raw SQL query to a straight-up Entity POCO.

There are a few, uh, provisos. Ah, a couple of quid pro quo. Still, handy when you're in a tight spot.

• This guy lays it down in get-er-done style.
• This person goes a bit farther down the rabbit hole.
• And there's straight from the horse's mouth.

You're welcome, internet.