DevForce Community Forum : calling stored procedure http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : calling stored procedure Tue, 12 May 2026 21:28:11 -700 Fri, 04 Oct 2013 10:54:03 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=4460 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ calling stored procedure : There's nothing within DevForce... http://www.ideablade.com/forum/forum_posts.asp?TID=4460&PID=17018#17018 Author: kimj
Subject: 4460
Posted: 04-Oct-2013 at 10:54am

There's nothing within DevForce to directly support this.  One option is to use ADO.NET within a server RPC method.]]> Fri, 04 Oct 2013 10:54:03 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4460&PID=17018#17018 calling stored procedure : what if i don't want to create... http://www.ideablade.com/forum/forum_posts.asp?TID=4460&PID=17017#17017 Author: BillG
Subject: 4460
Posted: 04-Oct-2013 at 10:30am

what if i don't want to create a stored procedure but i just want to code a simple Delete or Update SQL statement? Is that possible?

For Example i want to run the following SQL statement

delete from benefits where categoryCd = 'AB'

i really don't want to loop through a collection to delete the above items. How can i call a delete sql query from my code?

Bill

]]> Fri, 04 Oct 2013 10:30:43 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4460&PID=17017#17017 calling stored procedure : If you've mapped the stored... http://www.ideablade.com/forum/forum_posts.asp?TID=4460&PID=17015#17015 Author: kimj
Subject: 4460
Posted: 04-Oct-2013 at 9:30am

If you've mapped the stored procedure within the EDM Designer the appropriate procedure will be called automatically for update/delete actions on entities.  More info on that here - http://msdn.microsoft.com/en-us/library/cc716711.aspx.
 
Otherwise,  a stored procedure which returns no data can be mapped within the EDM as a "query", and DevForce will generate calling methods for it within the EntityManager.
 
If the stored procedures aren't part of your EDM, within a server-side RPC method you can work directly with either the ObjectContext or Connection to call the stored procedure.
]]> Fri, 04 Oct 2013 09:30:12 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4460&PID=17015#17015 calling stored procedure : i am trying to find out the... http://www.ideablade.com/forum/forum_posts.asp?TID=4460&PID=17011#17011 Author: BillG
Subject: 4460
Posted: 04-Oct-2013 at 7:24am

i am trying to find out the syntax for calling an update or delete store procedure from within my code. Is there an easy IdeaBlade way to do this?
 
Bill
 
]]> Fri, 04 Oct 2013 07:24:54 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4460&PID=17011#17011