Stored Procedure.

3 posts, 0 answers
  1. Joebet
    Joebet avatar
    23 posts
    Member since:
    Jun 2010

    Posted 07 Jul 2010 Link to this post

    Good day sir. may I ask how to forward map my ReadSP upon runtime? heres the code
            public static IQueryResult ReadProducts(IObjectScope scope) 
            { 
                IQuery query = scope.GetSqlQuery("[ReadProducts]", null,""); 
                 
                IQueryResult res = query.Execute(new object[] {}); 
                int a = res.Count;//Actually executes the query 
                 
                 
                 
                return res; 
            } 

    And this is the original code from the database.
    USE [Inventory] 
    GO 
     
    SET ANSI_NULLS ON 
    GO 
    SET QUOTED_IDENTIFIER ON 
    GO 
     
    ALTER PROCEDURE [dbo].[ReadProducts] 
         
    AS 
    BEGIN 
         
        SET NOCOUNT ON; 
     
        
        SELECT  ProductName,Description from Products 
    END 
     

    As what I had mentioned earlier I want to forward map the first code above to the database at runtime. Yes OA can make SP but it lacks on the ability to give us Custom Read SP. Also is the Forward, Reverse Mapping Forms Open Source? Because I am planning to upgrade the feature that suites my needs? Or can you give us some links on how to do the wizard forms? Thanks
  2. Joebet
    Joebet avatar
    23 posts
    Member since:
    Jun 2010

    Posted 11 Jul 2010 Link to this post

    its been 5 days and still no answer..... anyone from the orm group?
  3. DevCraft banner
  4. Petko_I
    Admin
    Petko_I avatar
    184 posts

    Posted 12 Jul 2010 Link to this post

    Hi Joebet,

    Currently, forward mapping is available for CUD operations of stored procedures. Now, you cannot forward map a stored procedure that returns a result. With the new Visual Designer context you can call ExecuteStoredProcedure and have your procedure run but this is not the mapping you require. The feature you desire will be available at some point after the Q2 release. You can expect to see a dedicated UI to forward map stored procedures.

    As to your next questions, the Classic Wizards are not open source. You can always find information on working with the old wizards in our online documentation. But I am not sure as to exactly what you are trying to achieve, you will not be able to modify our product. However, you can request a feature and we might consider it for introduction in some of our next versions. 

    If you have any further questions, please do not hesitate to contact us.

    Regards,
    Petko_I
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
Back to Top