This is a migrated thread and some comments may be shown as answers.

How to execute stored procedure?

4 Answers 215 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Richard M
Top achievements
Rank 1
Richard M asked on 21 Jun 2011, 04:25 PM
I have a stored procedure in sql server that takes 2 parameters, and does not return any values.  How do I do this with Open Access?  Here's what I have so far, but it doesn't work:

MyEntityDiagram conn = new MyEntityDiagram();

var results = conn.SpCopyUserSettings(userID1, userID2);
return results;

4 Answers, 1 is accepted

Sort by
0
Damyan Bogoev
Telerik team
answered on 22 Jun 2011, 05:08 PM
Hi Richard M,

I prepared a sample application that demonstrates how to achieve that goal.
Hope you will find the attached application helpful. If any other questions arise, do not hesitate to contact us back.

Best wishes,
Damyan Bogoev
the Telerik team
Q1’11 SP1 of Telerik OpenAccess is available for download; also available is the Q2'11 Roadmap for Telerik OpenAccess ORM.
0
Richard M
Top achievements
Rank 1
answered on 22 Jun 2011, 08:31 PM
That is very easy to use, thank you very much
0
Matt
Top achievements
Rank 1
answered on 20 Feb 2013, 09:42 PM
Hi

Im trying the same but calling a stored procedure using Silverlight ria services. I have built the stored procedures and am trying to populate a listbox. Can you please provide an example of a persistent type SP into a listbox

regards
matt
0
Boris Georgiev
Telerik team
answered on 25 Feb 2013, 01:06 PM
Hello Matt, 

As this thread is duplicating with another, please find my answer here.


All the best,
Boris Georgiev
the Telerik team
Q3'12 SP1 of OpenAccess ORM packs Multi-Table Entities mapping support. Check it out.
Tags
General Discussions
Asked by
Richard M
Top achievements
Rank 1
Answers by
Damyan Bogoev
Telerik team
Richard M
Top achievements
Rank 1
Matt
Top achievements
Rank 1
Boris Georgiev
Telerik team
Share this question
or