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
entity
|entity-framework
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