How do you write this in LLBLGen code:

SQL = "Select FirstName + ' ' + Lastname as FullInfo from Users

I need to do this so that on my dropdown list control I can use "FullInfo" as my DataTextField.

The way I've done this is by making a custom property, in the entity class itself, that would return FirstName + Lastname. If you want binding to work, you would have to raise the PropertyChanged event whenever FirstName or LastName changed.

mikeg22 wrote:

The way I've done this is by making a custom property, in the entity class itself, that would return FirstName + Lastname. If you want binding to work, you would have to raise the PropertyChanged event whenever FirstName or LastName changed.

Exactly.

When binding to a dropdownlist, you probably do not want to use an entitycollection (because of the overhead), but a dynamiclist. In that case, you should have a look at Expressions (explained in the docs).