LINQ Question

SouthSpawn posted on Saturday, May 17, 2008

1. Using DataLinq = ContextManager(Of SystemDataLinqDataContext).GetManager("ConnectionString")
2.             Dim DataResult = From CompanyItem In DataLinq.DataContext.spGetCompanies( _
3.                                      CompanyPageIndex, _
4.                                      CompanyPageSize, _
5.                                      CompanyActive, _
6.                                      _totalRecordCount) Order By SortBy.ToString _
7.         Select New CompanyRO( _
8.             CompanyItem.CompanyID, _
9.             CompanyItem.CompanyTypeID, _
10.             CompanyItem.CompanyTypeDescription, _
11.             CompanyItem.CompanyTypeActive, _
12.             CompanyItem.Name, _
13.             CompanyItem.Description, _
14.             CompanyItem.RoleID, _
15.             CompanyItem.Website, _
16.             CompanyItem.Username, _
17.             CompanyItem.Password, _
18.             CompanyItem.CompanyLookUpCode, _
19.             CompanyItem.Active)
20.  
21.             AddRange( _
22.                 DataResult)
23.         End Using

RedmondScorpio replied on Tuesday, May 20, 2008

Hello,

The order by clause should be something like:

Order By CompanyItem.FieldNameInResultSet

Are you trying to dynamically set the order by field name?

If so, here is an article abou that.  http://blogs.vertigo.com/personal/jeffv/Blog/Lists/Posts/Post.aspx?ID=10