locked
ADO.NET Entity Model doesn't show my stored procedure RRS feed

  • Question

  • Hi, I have a problem with entity data model (edmx).

    I generate my db's modal and tables are perfectly working, but i tried to execute a stored procedure, and i added my stored procedure to "Function Imports" give the return type Int32 (Sp returns int value) then i can see in my sp under Model browser->Entity Container->Function Imports tree with given name.

    But here is the problem, i cannot call my sp like http://msdn.microsoft.com/en-us/library/bb896334.aspx this link, it isn't generating GetID() method under my Entities.

    Thanks for help

    • Moved by Damien Guard Wednesday, May 12, 2010 2:53 PM (From:LINQ to SQL)
    Wednesday, May 12, 2010 11:44 AM

Answers

  • Hello Sehlor,

    Please delete the function import and right click the stored procedure name -> Add Function Import... to add it. If it persists, please reset settings of Visual Studio (Tools -> Import and export setting) and try again.

    Best regards


    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    If you have any feedback, please tell us.
    Welcome to the All-In-One Code Framework!
    Monday, May 17, 2010 11:01 AM