Stored Procedures - Lets Get Clear Once and For All...

[Tayonee]

OK, I have seen many different posts and help topics around the usages of stored procedues. I have one main goal using the ORM with them - I want to be able to call my custom created procedures with VERY LITTLE coding on my part - certainly less than ADO.NET requires of me. 

I have several possible scenarios:

1. Stored procedures without no return result
2. Stored procedures with a custom return result (does not match shape of an existing entity)
3. Stored procedures with a result set that matches an existing entity.

I am coming from a LINQ to SQL framwork where executing a procedure is as simple as:

Dim context As New SOREOTimeAndBillingL2QLDataContext
context.PayrollPeriodStart(StartDate, EndDate)

.. blah, blah, blah.
I have seen refernces to the ORM API but to be honest if I am going to have to write that muchg code I may as well use what I already kow - ADO.NET.
So, my question is - how many of the scenarios I listed above can be *currently* accomplished with the ORM framework using that little code?
Are there any near term plans to address the scenarios listed above which are not currently possible without writing as much code as ADO.NET requires to get the job done?

[Damyan Bogoev]

Hi Tayonee,

Currently we are working on a stored procedure editor that will allow users to specify the result shape of a stored procedure and generate a method that will execute it.
We will do our best to implement for the next service pack of the product.

All the best,
Damyan Bogoev
the Telerik team

[Tayonee]

That sounds great. Is there any way we can get notification of the inclusion (or not) of that feature when it becomes available?

[Damyan Bogoev]

Hi Tayonee,

We will notify you in this thread once the service pack is available.

Regards,
Damyan Bogoev
the Telerik team

[Damyan Bogoev]

Hi Tayonee,

The Q3 release is available now. You could download it from your account. 
You can have a look at the release notes.

Greetings,
Damyan Bogoev
the Telerik team