Linq query not returning the generated SQL results in entity framework object context connection

arvinlml · January 2018

I'm using LINQPad 5 with IBM.Data.DB2 and could not see the 'Sql', though the results, Lambda, IL and tree look good.

JoeAlbahari · January 2018

The SQL translation is not supported with some of the third-party drivers.

arvinlml · February 2018

Hi Joe Albahari, Can you point a third-party library that I can use to query IBM.Data.DB2. It will be of immense help. Thank you

JoeAlbahari · February 2018

The only one I'm aware of is the LINQ-to-DB driver. If you're not seeing the SQL translation, you could try contacting the authors.

leon · February 2020

Does LINQPad 6 support previewing of a generated SQL query for EF Core (v3.1) for MSSQL and PostgreSQL?

JoeAlbahari · February 2020

You should be able to see the generated SQL in the SQL tab. Is it behaving differently for you? If so, can you provide a screenshot of your connection dialog?

leon · February 2020

Yes, I can see generated SQL for Postgres. Thank you.

Linq query not returning the generated SQL results in entity framework object context connection

Comments