|
|
 |
BOOK: ASP.NET 3.5 Enterprise Application Development with Visual Studio 2008: Problem Design Solutio
 | This is the forum to discuss the Wrox book ASP.NET 3.5 Enterprise Application Development with Visual Studio 2008: Problem Design Solution by Vincent Varallo; ISBN: 9780470396865 |
|
Welcome to the p2p.wrox.com Forums.
You are currently viewing the BOOK: ASP.NET 3.5 Enterprise Application Development with Visual Studio 2008: Problem Design Solutio section of the Wrox p2p Programmer to Programmer discussion community. This is a community of more than 40,000 computer programmers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining our free Wrox p2p community you can post your own programming questions and respond to other programmers’ questions. Registered users also don't have to see the ads that are displayed to guests. Registration is fast, simple and absolutely free so please, join today!
Join today and post to win prizes! Post more to increase your chances of being Wrox’s top poster of the month.
|
 |

September 23rd, 2009, 10:36 PM
|
|
Authorized User
|
|
Join Date: Sep 2009
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Ch7 - error creating methos with ORM designer
Hello,
when trying to drag and drop stored procedures onto concerned table, i get an error. i cut and pasted code from chapter download. but ican't figure out what is the problem.
same error for all "custom" stored procedures defined on page 207 and the following. other sp are ok,
seems that the pb comes with sp with "select count() statement
any idea?
thx. Georges
Last edited by moulot : September 25th, 2009 at 01:05 AM.
Reason: more explanation
|

October 29th, 2009, 05:59 PM
|
|
Authorized User
|
|
Join Date: Mar 2009
Posts: 72
Thanks: 4
Thanked 4 Times in 4 Posts
|
|
post the error here and I will see if I can help you.
|

October 29th, 2009, 07:06 PM
|
|
Authorized User
|
|
Join Date: Mar 2008
Location: New York, NY, USA.
Posts: 62
Thanks: 1
Thanked 3 Times in 3 Posts
|
|
You need to drop Stored Procedures that are not entity objects into the method pane not onto the table object.
When doing this an object with the same name as the sproc + "Result" will be created.
Don't take blame, this wasn't mentioned to do this in the book and could be confusing.
The rule of thumb to follow is, procedures that are delete, insert, update, or select that does not return the entity object itself (such as count), drop it into the ORM Method Pane. Otherwise you'll get the error you're getting because the sproc's result doesn't match the table.
FYI: NOT all custom sproc's. Some return an entity, but are custom because it passes a different parameter... eg. SelectByWorkflowId(int workflowId)
Ronnie
|
| Thread Tools |
Search this Thread |
|
|
|
| Display Modes |
Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
 |