Dave,
>When I try to invoke a method on an object on the object test bench I get:
>"
>An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll
>
>Additional information: Incorrect syntax near 'ClaimSelectByPK'.
>"
>I don't see any Incorrect syntax anywhere near ClaimSelectByPk.
>The solution builds without errors.
>The stored procedure executes fine from within M$ SQL server...
Check your business object, and if there is a line of code in the constructor that sets the DefaultCommandType property, remove it. Next time you run the the Business Layer Generator, make sure you uncheck the option on the second page of the wizard to "Set DefaultCommandType".
Best Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com