Linq query not returning the generated SQL results in entity framework object context connection
Options
I'm using LINQPad 5 with IBM.Data.DB2 and could not see the 'Sql', though the results, Lambda, IL and tree look good.
Comments
-
The SQL translation is not supported with some of the third-party drivers.
-
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
-
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.
-
Does LINQPad 6 support previewing of a generated SQL query for EF Core (v3.1) for MSSQL and PostgreSQL?
-
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?
-
Yes, I can see generated SQL for Postgres. Thank you.
