ambiguous columns error

ambiguous columns error

Postby jerryk » Fri 22 Feb 2013 13:04

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
jerryk
 
Posts: 8
Joined: Mon 02 Aug 2010 18:47

Re: ambiguous columns error

Postby Shalex » Fri 22 Feb 2013 17:53

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.
Shalex
Devart Team
 
Posts: 7602
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle