public static List <generic_AMatrix> getregioanlamtrix(string region_name) { PEIEntities7 Ganesh = new PEIEntities7(); List <generic_AMatrix> empList = null; if (region_name.Substring(region_name.Length - 4) != "Rest") { var empQuery = from emp in Ganesh.spAlabama_AMatrix(region_name + "_AMatrix ").ToList()//Ganesh.Alabama_AMatrix select new generic_AMatrix { ID = emp.ID, VALUE = emp.VALUE }; empList = empQuery.ToList(); } if (region_name.Substring(region_name.Length - 4) == "Rest")//instead of name check last 4 letters rest { if (region_name == "AlabamaRest") { region_name = "Z_" + region_name; //special cas for labama } //region abalama rest table a bitterent name given var empQuery = from emp in Ganesh.spz_AlabamaRest_AMatrix(region_name + "_AMatrix ").ToList() //Ganesh.z_AlabamaRest_AMatrix //z_AlabamaRest_AMatrix select new generic_AMatrix { ID = emp.ID, VALUE = emp.VALUE }; empList = empQuery.ToList(); } return(empList); }