I'm just getting started with the Entity Framework. I'm trying to figure out the best way to approach building a table that contains calculated columns. For example, I have a table that has monthly values and I would like to have an entity that contains the average values for a given quarter. I can certainly do this the "old-fashioned" way but I'd like to stick with the new model as much as possible. Do I need to create a view and add that to the EDMX, figure out the XML command and use theWCF or is there something I'm missing? Similarly, what's the new way to get a scalar value back?
Thanks.