Print Page | Close Window

Stored Procedure Issue

Printed From: IdeaBlade
Category: DevForce
Forum Name: DevForce 2009
Forum Discription: For .NET 3.5
URL: http://www.ideablade.com/forum/forum_posts.asp?TID=1321
Printed Date: 29-Apr-2025 at 12:26pm


Topic: Stored Procedure Issue
Posted By: ken.nelson
Subject: Stored Procedure Issue
Date 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


Replies:
Posted By: kimj
Date 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. 


Print Page | Close Window