Stored procedures not visible if schema is other than dbo

Discussion of open issues, suggestions and bugs regarding Entity Developer - ORM modeling and code generation tool
Post Reply
hanneseklund
Posts: 3
Joined: Wed 27 Apr 2011 13:35

Stored procedures not visible if schema is other than dbo

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
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Wed 27 Apr 2011 15:54

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

hanneseklund
Posts: 3
Joined: Wed 27 Apr 2011 13:35

Post by hanneseklund » Thu 28 Apr 2011 05:39

"Show all Objects" makes no difference.

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

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
Site Admin
Posts: 8240
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Tue 03 May 2011 11:22

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

Shalex
Site Admin
Posts: 8240
Joined: Thu 14 Aug 2008 12:44

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
Posts: 3
Joined: Wed 27 Apr 2011 13:35

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
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

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
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Tue 31 May 2011 10:22

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

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

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.

Post Reply