I'm trying to do a task that I believed to be straightforward while using Entity Framework 6 Code First for the first time. In my database environment, I want to first establish a SQL View and then have an Entity I can use to query the view.
Although I have experimented with articles like this, the main distinction in my situation is that the SQL View does not come from an already-existing database.
I looked into the idea put out in this piece, but it seems like overkill to me that I would need to write some extension methods in order to perform something as basic as creating a view/entity combo and using it in my database context.
Do I have something missing? I'm aware that it would be much simpler if I weren't using Code First, but remember that I'm trying to design a view rather than reuse one from an existing database.