I have multiple EDMX projects in my project which contain different databases. These databases have most of the tables with the same name. Within my project I record in one or in another database according to the logic I require it.
I have already separated the EDMX folders and the project compiles OK, the problem is in execution time when trying to access the model because it gives the following error:
The mapping of CLR type to EDM type is ambiguous because multiple CLR types match the EDM type 'TABLA_001'. Previously found CLR type 'MODEL_01.TABLA_001', newly found CLR type 'MODELO_02.TABLA_001'.
I can not change anything at the Database level.
Has anyone been able to solve this?