DevForce Community Forum : Stored Procedure Issue http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2009 : Stored Procedure Issue Sat, 11 Apr 2026 20:33:14 -700 Mon, 15 Jun 2009 19:02:08 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=1321 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Stored Procedure Issue : This would be a bug. The Entity... http://www.ideablade.com/forum/forum_posts.asp?TID=1321&PID=4768#4768 Author: kimj
Subject: 1321
Posted: 15-Jun-2009 at 7:02pm

This would be a bug.  The Entity Framework strips off key properties when any type of query is run, while DevForce does some fixup to add these properties back, in the form of the xx_fk_yy synthetic properties you see for entities in the domain model.  Unfortunately, DevForce isn't currently doing this fixup for the results of a stored procedure, with inconsistent and incorrect results. 
 
We've opened a defect report for this. 
]]> Mon, 15 Jun 2009 19:02:08 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1321&PID=4768#4768 Stored Procedure Issue : Hi, We're attempting... http://www.ideablade.com/forum/forum_posts.asp?TID=1321&PID=4763#4763 Author: ken.nelson
Subject: 1321
Posted: 15-Jun-2009 at 11:27am

Hi,
 
We're attempting to use a stored prodecure to pull in data.  We've successfully imported the stored procedure, and have run the stored procedure 'successfully', meaning we've got data back from the stored procedure.  The problem is, it seems that the records we're getting back are missing some data.  Everything that is missing appears to be a foreign key to another table.  If the foreign key is nullable, the field value is null.  If the foreign key is not nullable, an exception is thrown.  I'm not even attempting to access the navigation properties, I'm literally trying to get at the keys, and the keys are bad.  When we run the stored proc in the database, the data returned is correct.
 
Is this expected?  Any idea what's going on?
 
Thanks,
Ken


Edited by ken.nelson - 15-Jun-2009 at 11:28am]]> Mon, 15 Jun 2009 11:27:55 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1321&PID=4763#4763