I'm working with an existing database that has multiple schemas. In addition, different schemas duplicatate table names. Code First deployment is not an option.
When generating my edmx, I'm hitting multiple issues, but the main one I'm concerned about is naming convention - I'd like to prefix all entities with the schema name unless the schema name is dbo.
So for example, I have a Person table in both the emp schema and the dbo schema, I'd like to have two entities - emp_Person and Person.
I know it's possible to add prefixes (I found an example at codeplex) but it looks like it's always going to apply the same prefix everywhere.
Any suggestions or links?