Hi Raman,Suppose you are working with Linq to sql then drag and drop your stored procedure to right side window of dbml and build the project.
then you use it like a method in your project.
Ex: if you are creating Datacontext Object then use that Object to retrieve your stored procedure.
DataContext db=new DataContext();
if parameter is available then pass into it.