Influence Linq to Entity Frameork SQL generation

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
markaw
Posts: 13
Joined: Mon 11 Aug 2008 12:45

Influence Linq to Entity Frameork SQL generation

Post by markaw » Wed 22 Oct 2008 14:46

Hi,

Is there a way to influence a SQL that the OraDirect.NET generates while working with EntityFramowrk and Linq?

Lets say I would like to filter the all the numbers and return +1 while selecting.

In other words if normally this sql statement would by generated
"select num from table" I wold like to have "select num + 1 from table".

Can it by done?

Regards,
Mak

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

Post by AndreyR » Fri 24 Oct 2008 12:10

There is no way to influence the generated SQL. But you can modify the LINQ query to get the appropriate result.

Post Reply