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(); db. if parameter is available then pass into it.