Difference in generated sql when using defining query

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
Ido Flatow
Posts: 8
Joined: Tue 21 Apr 2009 07:50

Difference in generated sql when using defining query

Post by Ido Flatow » Tue 21 Apr 2009 07:56

When I have an entity set which is a table, the generated sql is something like:
select "extent1".column1, "extent1".column2 from table "extent1"

But if I use a defining query instead of a table name, the generated sql is something like:
select "extent1"."column1", "extent1"."column2" from (...) "extent1"
and my inner sql statement is something like :
select column1, column2 from table

Why in normal mode there are no double-quotes on the columns and in defnining query there are? This requires me to change all my defining queries to the double-quote format (using aliases).

Is there some way to tell the provider to not use double-quotes?

Thanks in advance,
Ido.

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Thu 23 Apr 2009 13:49

Thank you for the report, we are investigating this issue.

Post Reply