public void AddUserToRole(int roleId, string userName) { BLL.CTSContext entities = new CTSContext(); UserProfile user = entities.UserProfiles.Where(p => p.UserName == userName).FirstOrDefault(); if (user != null) { UserRole role = new UserRole(); role.RoleID = roleId; role.UserProfileID = user.UserProfileID; entities.UserRoles.Add(role); entities.SaveChanges(); } }