IQueryable stored procedure

Question

hi How to get IQueryable result from stored procedure? i need a result like IQueryable IUSP=result fetch from USP

Muralidharan Deenathayalan · Answer

Are you using entity framework to execute the query? If so you will get the results in the form of ObjectResult. ObjectResult empImage = this.Context.GetPhoto(EmpId); var image = (from i in empImage select i).FirstOrDefault(); Here we are getting the employee photo from db by using sp in a form ObjectResult . On this result we applied the linq query to extract the result.