There are times where you want to use a stored procedure that doesn't return just normal rows out of a database. One classic example is if you are doing Full-Text Searching and want to return the Rank.
The first step to doing this is the get your stored procedures exposed in the ADO.NET Entity Data Model. Instead of going through the steps for doing that here, I'll just point you to a great post by Julie Lerman on her blog: Implement SELECT Stored Procedures that return miscellaneous data in CTP2 of EF Designer.
After following those steps, you will have the stored procedures all ready to be called from the Entity Data Model. You can then use these stored procedures from ASP.NET, ASP.NET MVC, or anything else that can ...
Go to the complete details ...