Devart Forums

We are using EF to Postgresql. We have just upgraded from postgresql 550 pro Build 237 to 570 pro and a LINQ query is now returning an error. The inner exception is:

'column Project8.C2 does not exist'

It appears that the parsing of the SQL from the LINQ query has failed. I have checked and the query has not been changed. We have also checked out the very newest release (from the end of Feb I think) the the problem remains. I can send you the query , but it is a very complex query and I just wanted to check first that no-one else had reported this problem (because it's going to be a little bit of work getting you the set of tables you'll need).

Could you please compare (between 5.50.237 and 5.70.311) the generated SQL using dbMonitor tool, try to localize the issue, and send us a small test project with the corresponding DDL/DML script?

Download link: http://www.devart.com/dbmonitor/dbmon3.exe
Documentation: http://www.devart.com/dotconnect/postgr ... nitor.html

Hi - I emailed you some sample stuff on the 6th. Could I have an update please?

We have asked you to send an additional information to us by e-mail.

Shalex wrote:We have asked you to send an additional information to us by e-mail.

Extra stuff emailed to you.

Thank you for the test project. We have reproduced the issue and are investigating it.

The bug with using expression aliases in complex queries is fixed. We will post here when the corresponding build of dotConnect for PostgreSQL is available for download.

New build of dotConnect for PostgreSQL 5.80.332 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/postgr ... nload.html (trial version) or from Registered Users' Area (for users with active subscription only).
For more information, please refer to http://www.devart.com/forums/viewtopic.php?t=23777 .