Print Page | Close Window

Need to call Stored procedure on server

Printed From: IdeaBlade
Category: DevForce
Forum Name: DevForce 2010
Forum Discription: For .NET 4.0
URL: http://www.ideablade.com/forum/forum_posts.asp?TID=4004
Printed Date: 07-Sep-2025 at 7:15am


Topic: Need to call Stored procedure on server
Posted By: hijaggu
Subject: Need to call Stored procedure on server
Date Posted: 25-Feb-2013 at 12:04am
How do I call stored procedure on server using untyped entity manager? I am unable to get stored procedure query.



Replies:
Posted By: kimj
Date Posted: 25-Feb-2013 at 9:59am
The methods auto-generated by DevForce for stored procedures are just helper methods to make query execution easier, they aren't required.  In your code you can "new" a StoredProcQuery just as you see done in the helper methods, and then execute that query.  Here's more information on the http://drc.ideablade.com/ApiDocumentation/IdeaBlade.EntityModel~IdeaBlade.EntityModel.StoredProcQuery~_ctor.html - StoredProcQuery .
 
As an alternative, you can use the EntityManager copy constructor to create a typed entity manager from the base EM, giving you access to your EntityQuery and StoredProcQuery methods and properties.



Print Page | Close Window