in Entity framework environment, I would not advice using stored procedure...

although, if u r working on old system where bulk of logic is already writen instored procedures, then u can use SP with entity framework... as explained in this tutorial

http://www.asp.net/web-forms/tutorials/getting-started-with-ef/the-entity-framework-and-aspnet-getting-started-part-7

but, if u r creating a new app with fresh logic, avoid SP

hope this helps...