Mapped Stored Procedures in EF 1

Posted by michael.lukatchik on Stack Overflow See other posts from Stack Overflow or by michael.lukatchik
Published on 2010-05-17T13:41:27Z Indexed on 2010/05/17 13:50 UTC
Read the original article Hit count: 345

Filed under:
|

All,

I'm using mapped Stored Procedures in EF 1. I've completed the following steps:

1) I've created my INSERT, UPDATE, and DELETE queries in SQL Server. 2) I've built the EDMX and imported the INSERT, UPDATE, and DELETE sprocs as part of my model. 3) I've set up a Stored Procedure Mapping on a table inside of my EDMX file. The INSERT, UPDATE, and DELETE sprocs were mapped accordingly.

Using this approach, I would expect to rebuild the application (and mine builds successfully) and then see the Stored Procedures as available function names via my EDMX object, such as:

_entities.InsertComment(..), _entities.UpdateComment(..), and _entities.DeleteComment(..)

Intellisense is not picking these names up and I can't figure out why.

If I perform these same steps using EF4, the function names are automatically picked up by Intellisense after adding the Stored Procedure Mappings.

Is this a bug in EF1? Is there something else I should be doing?

Thanks in advance,

Mike

© Stack Overflow or respective owner

Related posts about entity

Related posts about entity-framework