LINQ => PostgreSQL & stored function

Discussion of open issues, suggestions and bugs regarding LinqConnect – Devart's LINQ to SQL compatible ORM
Post Reply
ChrisMH
Posts: 14
Joined: Tue 15 Mar 2011 18:11

LINQ => PostgreSQL & stored function

Post by ChrisMH » Wed 16 Mar 2011 16:19

I have a function in my PostgreSQL database that uses pl/pgsql to RAISE an error under certain conditions. In my .NET code using LINQ, I would expect that calling this function would generate some type of exception in my code that contains the error string from my RAISE command.

Instead, the call to the function times out and I get a SocketException.

Is this the expected behavior? Is there a way to get the RAISE exception to propagate back to my code?

Thanks,
Chris

StanislavK
Devart Team
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Post by StanislavK » Thu 17 Mar 2011 17:34

Thank you for the report, we've reproduced the issue. We will investigate it and inform you about the results.

StanislavK
Devart Team
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Post by StanislavK » Tue 22 Mar 2011 09:25

We have fixed this issue, PgSqlException should be thrown for an exception raised inside a function now. The fix will be available in the nearest build. We will post here when this build is released.

ChrisMH
Posts: 14
Joined: Tue 15 Mar 2011 18:11

Post by ChrisMH » Thu 24 Mar 2011 14:35

Fixed in 2.20.17

Thanks!

Post Reply