CREATE PROCEDURE `sp_getdiseases`()

BEGIN

SELECT Id,DiseaseName FROM healthcard.diseases;

END

healthcardEntities db = new healthcardEntities();

var Disease = db.sp_getdiseases().ToList();