DevForce Community Forum : Stored procedure non-query calls http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2009 : Stored procedure non-query calls Tue, 28 Apr 2026 21:41:17 -700 Fri, 25 Sep 2009 17:29:47 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=1222 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Stored procedure non-query calls : FunctionImports (and the DevForce... http://www.ideablade.com/forum/forum_posts.asp?TID=1222&PID=5489#5489 Author: kimj
Subject: 1222
Posted: 25-Sep-2009 at 5:29pm

FunctionImports (and the DevForce StoredProcQuery) can only be used for queries, both by DevForce and by EF.  What's happening is that the proc is executed, but then DevForce will throw when trying to process its "results".  For the record, the PassthruEsqlQuery can also be used for queries only.
 
EF (and DevForce) does support DeleteFunctions, but expects you to load up the entity and call .Delete() on it; the stored proc is then called instead of the usual delete command when SaveChanges is called.  Probably not what you want, though, since it is slow to have to both load items and then individually delete them.  Here's some info on stored proc support in EF - http://msdn.microsoft.com/en-us/library/bb399203.aspx.
 
You can also define a cascading delete constraint, where a delete on the parent will automatically force deletion of the children, but again all items must already have been retrieved.
 
Your best option might be to use either ADO.NET or EF Object Services to directly call the stored proc.  If you want to run this only on the server you'll need to use InvokeServerMethod to call a custom method on the server.  Your next issue is then ensuring that what's in the EntityManager cache now corresponds with the DB -- EM.RemoveEntities may help with this.
 
 
 
]]> Fri, 25 Sep 2009 17:29:47 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1222&PID=5489#5489 Stored procedure non-query calls : I have also created a stored procedure... http://www.ideablade.com/forum/forum_posts.asp?TID=1222&PID=5481#5481 Author: pucsoftware
Subject: 1222
Posted: 25-Sep-2009 at 10:49am

I have also created a stored procedure to deleted the relationship record in a many-to-many scenario. I originally tried doing this using the navigation properties of the parent objects but the response was really slow. So, I opted to try the old Import Function feature of the Entity Framework. This appears to work however I'm getting an exception in the DomainModel that I can't seem to capture (and handle/ignore) so it crashes my application. The exception reads:
 
"The data reader is incompatible with the specified [devforce class]. A member of the type, [key field], does not have a corresponding column in the data reader with the same name."
 
My code is using its class the signature of EntityManager.DefaultManager.MyDeleteMethod
 
It appears that the record is being deleted outside of the persistence cache and throwing an error because all of sudden the record no longer exists. The record is being deleted from the database, though. Is there a proper way to go about this? Can you explain what I should do about this?
 
 
]]> Fri, 25 Sep 2009 10:49:07 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1222&PID=5481#5481 Stored procedure non-query calls : You could use Remote Service Method... http://www.ideablade.com/forum/forum_posts.asp?TID=1222&PID=4420#4420 Author: davidklitzke
Subject: 1222
Posted: 17-Apr-2009 at 4:22pm

You could use Remote Service Method Call (RSMC).  Read about this in Chapter 12 of the Developer's Guide.
 
The EntityManager has an InvokeServerMethod() method that facilitates the running of server-side-only methods.
]]> Fri, 17 Apr 2009 16:22:15 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1222&PID=4420#4420 Stored procedure non-query calls : I was wondering if it is possible... http://www.ideablade.com/forum/forum_posts.asp?TID=1222&PID=4417#4417 Author: kmg-pm
Subject: 1222
Posted: 17-Apr-2009 at 1:43pm

I was wondering if it is possible in DevForceEF to call a stored procedure that is a non-query?
 
My stored proc does not return any data mapped to objects.  I was trying to figure out the how (and if) the "StoredProcRdbQuery" or "PassthruRdbQuery" classes worked in EF, but could find no documentation other than a brief mention in the Developers Guide.
 
Of course I could do this through a straight SQL/ADO mechanism, but I wanted to try and keep all of my DB interfacing through DevForceEF.
 
Any help would be greatly appreciated!
 
Thanks,
Kevin
]]> Fri, 17 Apr 2009 13:43:59 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1222&PID=4417#4417