public IHttpActionResult GetAllLs() { IList <StudentViewModel> lss = null; //allStudents[] allStudents; using (var ctx = new EMSEntities()) { lss = ctx.spAllCurrentStudents().Select(s => new StudentViewModel() { TRNNO = s.TRNNO, EMP_ID = s.EMP_ID, EMP_NAME = s.EMP_NAME, // CST_TRNNO = s.CST_TRNNO, EMP_F_NAME = s.EMP_F_NAME, // DOB = s.DOB, //BP_TRNNO = s.BP_TRNNO, //ETYPE = s.ETYPE, //CL_TRNNO = s.CST_TRNNO, //CL_TRNNO1 = s.CL_TRNNO1, //CERTIFICATE = s.CERTIFICATE, //PSCHDT = s.PSCHDT, //EMAIL = s.EMAIL, //ADT = s.ADT, //FTYPE = s.FTYPE, //FEE = s.FEE, //EMAILST = s.EMAILST, //GRPMST_TRNNO = s.GRPMST_TRNNO, //CNIC = s.CNIC, //SECMST_TRNNO = s.SECMST_TRNNO, //SECDTL_SR = s.SECDTL_SR, //SEX = s.SEX, //BSAL = s.BSAL, //FCNIC = s.FCNIC, //ADIMNO = s.ADIMNO, //STYPE = s.STYPE }).ToList(); } if (lss.Count == 0) { return(NotFound()); } return(Ok(lss)); }