public IEnumerable <Menu> SearchNotAddedInRole(IConnectionHandler connectionHandler, Guid roleId, string value) { var predicateBuilder = new PredicateBuilder <Menu>(); var guids = new RoleMenuBO().Select(connectionHandler, x => x.MenuId, x => x.RoleId == roleId, true); if (guids.Any()) { predicateBuilder.And(x => x.Id.NotIn(guids)); } predicateBuilder.And(x => x.Enabled); if (!string.IsNullOrEmpty(value)) { predicateBuilder.And(x => x.Url.Contains(value) || x.Title.Contains(value)); } return(this.OrderBy(connectionHandler, x => x.Title, predicateBuilder.GetExpression())); }