Can some help me out in this please:

i can search with firstname and surname seperately but how to merge two fields and then do the search. at the moment iam doing like this: static public EntityCollection SearchName(string name) { DataAccessAdapter adapter = new DataAccessAdapter(dbConnectionString()); EntityCollection namesearch = new EntityCollection(new MemberEntityFactory()); String Name1 = "%" + name + "%"; IRelationPredicateBucket bucket = new RelationPredicateBucket(MemberFields.Surname % Name1 | MemberFields.Firstname % Name1 ); ISortExpression sort = new SortExpression(); sort.Add(MemberFields.ClubId | SortOperator.Ascending); adapter.FetchEntityCollection(namesearch, bucket, 0, sort); adapter.Dispose(); return namesearch; }

My question is that i want to search by full name. I want to add firstname and surname then do the search. Can anyone help me in this please....... hope iam posting in the right section.

Maybe you will need something like the following:

            Expression someExp = new Expression(" ", ExOp.Add, MemberFields.Surname);
            Expression fullExp = new Expression(MemberFields.Firstname, ExOp.Add, someExp);
            IRelationPredicateBucket bucket = new RelationPredicateBucket(MemberFields.Surname.SetExpression(fullExp) % Name1 );

thanks..i managed to get it.