9

Closed

Error while creating respository classes when SQL schema is not DBO

description

When stored procedures are generated to alternative schema than DBO, the receipt "Create data repository classes from business entities" throws an error "There was an error trying to obtain the stored procedure result set".
 
Only way to create a new operation and mapping is to move stored procedures under the DBO schema.
 
Current SQL 2005 schema feature should be supported.
Closed Dec 10, 2007 at 7:18 PM by donsmith
This issue is being closed because it is related to the Data Access Guidance Package that was released with the second version of the Service Factory. This guidance package has since been taken out of the Service Factory project and made its own project called the Repository Factory. This project's community site can be found at http://codeplex.com/repositoryfactory

comments

alexanderQX wrote Apr 25, 2007 at 10:08 PM

Just a small clarification, when stored procedures are generated by this receipt FROM alternative or non standard schema (DBO), then this error is throw. It’s not possible to complete the receipt as input mappings fields are not populated.