Programmatically getting executable SQL from a LINQ query at run-time

Question

I know about Scott Gu's LINQ to SQL visualiser, but is there a way to take a LINQ expression at run-time and do something to find out the full resulting SQL?

Answer 1

You could use the Log feature on the DataContext and write your own code to evaluate the sql. An example here on logging SQL to the debug window should get you started on pulling out the SQL.

Answer 2

Try this:

yourProvider.GetCommand(yourQuery).CommandText;

Answer 3

Hi, If your database is SQL server and if you use DBML, you could visualize your Linq queries as native sql queries using Linq to Sql Visualizer. In case you use ADO.NET entity data model against SQL server or any other database server which supports Linq you could use a similar free visualizer available at http://visualstudiogallery.msdn.microsoft.com/en-us/99468ece-689b-481c-868c-19e00e0a4e69

Regards Venkat

Answer 4

If you are using LINQ2SQL you can just call .ToString() from the composed query.