public ActionResult Create() { int userId = Convert.ToInt32(Session["UserID"]); RoomController roomControl = new RoomController(); int[] roomIds = roomControl.GetRoomsForUser(userId); IEnumerable <FactoryRoom> roomList = from item in db.FactoryRoom where roomIds.Contains(item.RoomID) select item; List <SelectListItem> roomInfos = new List <SelectListItem>(); foreach (FactoryRoom item in roomList) { roomInfos.Add(new SelectListItem { Text = string.Format("{0}({1})", item.RoomName, item.RoomNumber), Value = item.RoomID.ToString() }); } ViewData["roomList"] = roomInfos; return(View()); }