Stored procedures not visible if schema is other than dbo

hanneseklund · Post by **hanneseklund** » Wed 27 Apr 2011 13:41

I have tons of stored procedures (SQL Server) that are under other schemas than dbo. I can't find them anywhere. Under procedures in Database Explorer, only dbo procedures are displayed.

Same in 3.2 and 3.5 beta. Is this a bug or is it just me ?

AndreyR · Post by **AndreyR** » Wed 27 Apr 2011 15:54

Please make sure that you have selected the Database Explorer -> Show All Objects button.

hanneseklund · Post by **hanneseklund** » Thu 28 Apr 2011 05:39

"Show all Objects" makes no difference.

AndreyR · Post by **AndreyR** » Thu 28 Apr 2011 12:51

Thank you for the report, we have reproduced the issue.
I will let you know as soon as this error is fixed.

Shalex · Post by **Shalex** » Tue 03 May 2011 11:22

The problem is fixed. Look forward to the next build of Entity Developer.

Shalex · Post by **Shalex** » Thu 19 May 2011 10:42

New version of Entity Developer 3.50.128 is released!
It can be downloaded from http://www.devart.com/entitydeveloper/download.html (trial version) or from Registered Users' Area (for users with valid subscription only): http://secure.devart.com/ .

For more information, please refer to http://www.devart.com/forums/viewtopic.php?t=21037 .

hanneseklund · Post by **hanneseklund** » Mon 23 May 2011 06:26

The procedures are now showing in the interface, however when trying to create methods from them I get the error

"Failed to obtain metadata of procedure result set.
DeriveParameters requires the command to have a transaction when the connection assigned to the command is in a pending local transaction. The Transaction property of the command has not been initialized."

And the method is created with return type "None"

AndreyR · Post by **AndreyR** » Mon 23 May 2011 07:24

Thank you for the report, this issue was already fixed.
I will let you know when the fixed build is available.

AndreyR · Post by **AndreyR** » Tue 31 May 2011 10:22

We plan to release the fixed build in a week or so.

AndreyR · Post by **AndreyR** » Wed 01 Jun 2011 16:58

We have released the new 3.50.132 build of Entity Developer for SQL Server. This build can be dowloaded from here (the trial version) or from Registered Users' Area (for users with active subscription only).
For the detailed information about the improvements and fixes available in Entity Developer for SQL Server 3.50.132, please refer to this announcement.