Cannot Call Stored Procedure using Entity Framework

 How to call Stored Procedure using Entity Framework?

First you have to Add the SP to Entity Framework Model.

But you cannot see the SP name under Complex Types or Function Model under Model Browser.

It lies with your SP that using Temp table. If you are using Temp Table in your SP, you must add

SET FMTONLY OFF;   

On top of the SP, and re-add the SP, the SP will be usable in Entity Framework.