LINQ => PostgreSQL & stored function

LINQ => PostgreSQL & stored function

Postby 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
ChrisMH
 
Posts: 14
Joined: Tue 15 Mar 2011 18:11

Postby 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

Postby 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.
StanislavK
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Postby ChrisMH » Thu 24 Mar 2011 14:35

Fixed in 2.20.17

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


Return to LinqConnect (LINQ to SQL support)