entity framework stored procedure with parameters

[Jonam]

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

[Peter]

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

[Jonam]

thank you this solution worked perfect for me!