locked
function import for stored procedures using mySQL RRS feed

  • Question

  • When trying to do a function import from my stored procedures ( we are using mySQL databases) the paramters do not come up when mapping even though the stored procs have parameters. Anyone have an idea how to fix this? Can i just add them manually via the XML? The sample stored procedure from mySQL is below. Is there a syntax difference so EF can pick up the parameters?

    CREATE DEFINER=`root`@`localhost` PROCEDURE `show_notes`(iSym varchar(9))
    BEGIN
    
    select date, note
    
    from notesdata
    
    where
    
    symbol = iSym
    
    order by date desc;
    
    END
    


    Sunday, October 2, 2011 5:30 PM

All replies