Hello All,

i am using LLBLgen 2.6 & self servicing with MS SQL 2005

i have one table called: Coach

please see this image

www.freeimagehosting.net/uploads/3a788a2206.png

I have second table called: User

www.freeimagehosting.net/uploads/f816739982.png

now i have one drop down list and binding with following code

UserCollection claUser = new UserCollection();
            IPredicate PreuserRole = (UserFields.RoleTypeId == 3 & UserFields.IsActive ==1);
            claUser.GetMulti(PreuserRole);

            ddCoach.DataSource = claUser ;
            ddCoach.DataTextField = "Username";
            ddCoach.DataValueField = "UserID";
            ddCoach.DataBind();

now here i want to bind firstname & lastname in DataTextField & in DataValueField i want UserID

how can i do in LLBL?

Do this:

1. Use prefetchPath to avoid lazy loading on your combo. Fetch all at once (the root entity and the related entity).

2. Use a Custom Property that return the contatenation of the two fields. An example: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=14782&StartAtMessage=0&#82346

3. Map that custom property on your combo

daelmo wrote:

Do this:

1. Use prefetchPath to avoid lazy loading on your combo. Fetch all at once (the root entity and the related entity).

2. Use a Custom Property that return the contatenation of the two fields. An example: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=14782&StartAtMessage=0&#82346

3. Map that custom property on your combo

hi daelmo,

thanks for reply

but i cant get that previous thread link. can your specify more reading that, or any sample code...

thanks again

daelmo wrote:

Do this:

1. Use prefetchPath to avoid lazy loading on your combo. Fetch all at once (the root entity and the related entity).

2. Use a Custom Property that return the contatenation of the two fields. An example: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=14782&StartAtMessage=0&#82346

3. Map that custom property on your combo

hi daelmo,

its done,

thanks, i have modify UserEntity.cs class