I recently heard someone suggest that the Entity Framework can be used to denormalize data. For example, let's say you have a table of game genres and a table of games.
Your initial EF model can go to the name of the game genre through game.Genre.Name. There seems to be a way to reassign things so that you can get into the name of the genre of the game through game.GenreName.
I can not find an example of this. The only approach I know is to manually add an abstraction layer that displays this (e.g. new GameAbstraction() {GenreName = gameEntity.Genre.Name }).
Could this do something to EF, or is it all about raising normalization (like creating SportsGame when, for example Genre.Name == 'Sports' or ActionGame when Genre.Name = 'Action')?
source
share