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

entity framework stored procedure with parameters

2 Answers 142 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Jonam
Top achievements
Rank 1
Jonam asked on 28 Dec 2010, 08:56 PM
Hello,

when i use the telerik report wizard to create a datasource from the entity framework it works good when i use a stored procedure that has no parameters. But when i use i select a stored procedure that depends on a parameter the details stay empty.

is it possible to use a parameterized stored procedure in combination with the entity framework?

kind regards,

Jonam

2 Answers, 1 is accepted

Sort by
0
Accepted
Peter
Telerik team
answered on 03 Jan 2011, 04:23 PM
Hi Jonam,

The EntityDataSource component is working with parametrized stored procedure. This scenario is elaborated in the  Using parameters with the EntityDataSource component help article. In order the detail section to stay empty, most probably you have set an incorrect parameter. Please check out if the stored procedure returns data by executing it with the Server Explorer with the same parameter.

Generally for executing stored procedures the straightforward way is using the SqlDataSource component.

Best wishes,
Peter
the Telerik team
Get started with Telerik Reporting with numerous videos and detailed documentation.
0
Jonam
Top achievements
Rank 1
answered on 20 Jan 2011, 10:12 PM
thank you this solution worked perfect for me!
Tags
General Discussions
Asked by
Jonam
Top achievements
Rank 1
Answers by
Peter
Telerik team
Jonam
Top achievements
Rank 1
Share this question
or