asp.net mvc - Limit Value of a text field -

i new mvc

i have employee poco this

[petapoco.tablename("tblemployee")] [petapoco.primarykey("employeeid")] public class employee {     public int employeeid { get; set; }     public string name { get; set; }     public string gender { get; set; }     public string city { get; set; }     public int departmentid { get; set; } } 

department id foreign key coming table tbldepartment. want limit value of departmentid in creating new employee values existing in table tbldepartment(column : id ).how this?

existing code in create view @html.editorfor(model => model.departmentid)

usually reference integrity managed @ database level.

make relationship on database between employees , departments enforce reference integrity, if try save employee department id don't exist on department table should return integrity error.

capture error on saving controller , return user.

also, if allow users load data limited list loaded existing data on database, suggested in comments.

however not enough, valid value deleted database between moment posted list in form , moment form sent controller save data.