There is an unsaved comment in progress. You will lose your changes if you continue. Are you sure you want to reopen the work item?
Moving from EF5 -> EF6: Invalid Column Name error
Hi, I'm investigating migration from EF5 to EF 6.0.1 for our application and I think I've identified a bug in EF6 that was not present in EF5.
I now get Invalid Column Name exceptions when querying some models that worked fine before.
I've attached a solution that reproduces the problem we are experiencing, and also what the resolution is - if you uncomment the line that ignores the COSwap model during model creation, the error is resolved.
Basically, it looks like EF6 cannot handle navigation / FK property pairs that have the same name in totally unrelated areas of the model hierarchy - the COSwap and IRSwap models both have a ReceiveLeg association, and the invalid column name is ReceiveLegId1.
Please let me know when a fix will be available for this.