Use OpenAccess to generate SQL-Select by Linq-Query

[Florian]

I found out, that your OpenAccess is a very advanced Linq-Provider. I'd like to use it to generate SQL-Selects.
Is is possible to just get the sql-command that would be used to query the database by executing the IQueryable<Entity> query?

I'd like to use this query to execute it directly on the server using an insert into .. select ... command-chain without the unecessary traffic back and forth to the client.

Any suggestions would be appreciated.

[Adrian]

Hello Florin (Salut Florian)
Check this link:
http://www.telerik.com/help/openaccess-orm/openaccess-tasks-howto-execute-sql-query.html

[Florian]

Hi Neagoe!

Thanks for your answer which unfortunately doesn't answer my question ;-) (Or I didn't get it)

Regards,
Florian

[Alexander]

Hello Florian,

You can just call ToString() on the Linq query to get the SQL statement which would be executed on the server. Any parameter values, however, would not be included in this string, so you may have to add them manually. Here is an example how to obtain the SQL:

EntitiesModel context = new EntitiesModel();

var query = context.Categories.Where(c => c.CategoryID == 2);
string sql = query.ToString();

Regards,
Alexander
the Telerik team

[Florian]

Alexander, thanks for your answer.
I'll see, it that fits my needs.
I thought there would be a way to get the parametrized dbCommand.

Regards,
Florian

[Alexander]

Hi Florian,

I am afraid that there is no way to obtain the dbCommand that OpenAccess uses internally. The ToString() trick is the only option at the moment.

Kind regards,
Alexander
the Telerik team

[Fawad]

Old thread but this link can give you trace functionality now.