p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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.

Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old September 23rd, 2009, 10:36 PM
Authorized User
Points: 48, Level: 1
Points: 48, Level: 1 Points: 48, Level: 1 Points: 48, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Sep 2009
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Reddit!
Reply With Quote
  #2 (permalink)  
Old October 29th, 2009, 05:59 PM
Authorized User
Points: 319, Level: 6
Points: 319, Level: 6 Points: 319, Level: 6 Points: 319, Level: 6
Activity: 82%
Activity: 82% Activity: 82% Activity: 82%
 
Join Date: Mar 2009
Posts: 72
Thanks: 4
Thanked 4 Times in 4 Posts
Default

post the error here and I will see if I can help you.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Reddit!
Reply With Quote
  #3 (permalink)  
Old October 29th, 2009, 07:06 PM
Authorized User
Points: 262, Level: 5
Points: 262, Level: 5 Points: 262, Level: 5 Points: 262, Level: 5
Activity: 25%
Activity: 25% Activity: 25% Activity: 25%
 
Join Date: Mar 2008
Location: New York, NY, USA.
Posts: 62
Thanks: 1
Thanked 3 Times in 3 Posts
Send a message via Yahoo to kalel_4444
Default

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Reddit!
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ORM Framework related whyvenky Intro Programming 2 April 10th, 2006 08:52 AM
ActiveX Designer error '80043ac1' Anish BOOK: Professional Crystal Reports for VS.NET 0 May 20th, 2005 09:41 AM
Creating DataEnvironment Designer jdeaver VB How-To 0 February 3rd, 2005 12:39 PM
Parse error: CH7 p198 willburke BOOK: Beginning PHP, Apache, MySQL Web Development ISBN: 978-0-7645-5744-6 0 October 16th, 2004 09:07 PM



All times are GMT -4. The time now is 05:47 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
© 2008 Wiley Publishing, Inc