I have been looking at Dynamic Entities but I'm not sure if they will work how I need them to. Can you create an updateable dynamic entity that is populated from multiple tables? From what I understand so far, to populate a dynamic entity from multiple tables you will have to use a query that joins both tables. Can you do this and still make it persistable?
Also, if I do have to use dynamic entities it will be a bit of a hassle to have to create them at runtime and lose strong typing for accessing the properties. Not a huge deal but will still be a nuisance.