public static List <LeontievInversegeneric> getalldatafor_LeontievInverse(String regionname) { PEIEntities7 Ganesh = new PEIEntities7(); List <LeontievInversegeneric> empList = null; if (regionname != null) { var empQuery = from emp in Ganesh.spAlabama_LeontievInverse(regionname + "_LeontievInverse").ToList()//Ganesh.Alabama_LeontievInverse select new LeontievInversegeneric { ID = emp.ID, VALUE = emp.VALUE }; empList = empQuery.ToList(); } return(empList); }