[Solved] Calling a stored proc from EF Crud event handler?

[Julian]

I have data that requires views to properly pull the correct updated columns from various tables. So a user can update on one webpage a Column for "EstimatedCompletionDate" of a task. Another page has this same date but it applies to a different task. So the easiest way to get the right data into the right grid is to utilize views. I'd like to use the Entity Framework DataSource but I'm not sure how to execute the stored procedure call?

Is there an example of how to do this?

I'm using Rad Controls for ASP.NET AJAX version 2013.1.220.

Thanks

[Marin]

Hello,

 The stored procedure should be mapped to the Entity Data Model first. Then you can try calling it by using the CommandText property or the QueryCreated event to specify more complex LINQ queries executed by the control. Or if you prefer you can directly query an entity created from the custom view in the database.
More information can also be found in the following links:
http://stackoverflow.com/questions/717740/can-i-call-a-stored-procedure-from-an-entitydatasource
http://msdn.microsoft.com/en-us/library/cc488556(v=vs.100).aspx
http://msdn.microsoft.com/en-us/library/ee404748(v=vs.100).aspx

I hope this helps.

Regards,
Marin
Telerik

[Julian]

Thanks I'll review the links! :)