public object GetLocationByMaterialIID(long id) { try { OiiOHaatDCDataContext dbContext = DatabaseHelper.GetDataModelDataContext(); var listdata = dbContext.SP_GetLocationByMaterialIID(id).SingleOrDefault(); return(listdata.CurrentLocation); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }