ADO.NET Entity Framework

[Pankaj Saha]

Hi, I am fetching the recored with a sql procedure, which returns a collection of values with the help of ADO.NET Entity framework. Now if I need to use stored procedure then I have to import that procedure in my .edmx file and map with a entity. Now the problem is that, I am fetching the records with inner join that's why it can not be map any single Entity. Is it compulsory to map the sotred procedure to an Entity? Can we use stored procedure without mapping with an Entity ?

Pankaj

[Not Active]

You can create an entity in the designer that maps to multiple tables then map the stored proc to it. Otherwise, yes you can use stored procs. Check here[^] for some use extensions and samples.

---

only two letters away from being an asset