ambiguous columns error

[jerryk]

Hi,

When using Entity Framework to query a view (5 tables or so) I am generating an ambiguous column error. The query of the view works fine when I run it standalone, ie. in Toad or other SQL command line interface. What is the best approach to troubleshoot this issue? Specifically I would like to see the generated SQL that is throwing the error and understand how I can alter the SQL.

Thanks,

Jerry

[Shalex]

1. Please turn on the dbMonitor tool, find the generated SQL, and execute it via plain ADO.NET or some database management tool. Does the problem persist in this case? If yes, specify the SQL.
2. Tell us the exact text of the exception and its call stack.
3. If possible, send us a small test project to reproduce the issue in our environment.