VB Dynamic Linq

[Mike]

I am attempting to build a dynamic LINQ query to filter users. Here is my code so far:

'Initialise the contexts
Dim portal As New Domain.vPortal.DbContext

'Get the basic user search
Dim search = (From u In portal.Users Select u)

'Apply the filter criteria
If Not filter.Name Is Nothing Then
    search.Where(Function(e) e.Username = filter.Name)
End If

'Get the results
Dim results = search.ToList

The problem I am having is that the where clause is not being applied to the LINQ query. If I set a username of 'blah' the linq query still returns all users regardless. What am I doing wrong?

Thanks

[Viktor Zhivkov]

Hi Mike,

You almost got it.
You have to change the following line to have the behaviour you desire:

'Apply the filter criteria
If Not filter.Name Is Nothing Then
    search = search.Where(Function(e) e.Username = filter.Name)
End If

See the change in the bold.

All the best,
Viktor Zhivkov
the Telerik team

[Mike]

Doh! I should have seen that. Thanks.

[Viktor Zhivkov]

Hello Mike,

You are welcome.
If you happen to need any assistance do not hesitate to contact us again.

Kind regards,
Viktor Zhivkov
the Telerik team