has no supported translation to SQL error

[jonathan]

I am using Linq to Sql and a LinqDatasource.  I have added a property to one of the class linq classes that were created as below.
public string FullName
        {
            get { return string.Format("{0}, {1}", this.LastName, this.FirstName); }
        }

When trying to sort or filter on this column I receive The member FullName has no supported translation to SQL error. 

Does anyone know how to get around this.  I realize there is no column in the database called Fullname.  I can set the sort expression of the coulmn to "User.LastName + User.FirstName" and this works, but it still errors when filtering.

Thanks for any help.

[Nikolay Rusev]

Hello Jonathan,

I am afraid that LinqDataSource will attempt to translate the expression in SQL and will fail as at table level there is no such column. You can use custom sorting as shown on the demo bellow:
http://demos.telerik.com/aspnet-ajax/grid/examples/programming/sort/defaultcs.aspx

Greetings,
Nikolay
the Telerik team