Querying using Linq

[=?Utf-8?B?TWlrZSBDb2xsaW5z?=]

I want to allow users to search last names, using wildcards.

When I try to following in my web app:

//employees data was previously retrieved and stored in ViewState.
var filteredData = from p in employees.ToArr ay() select p;
filteredData = from c in employees
where SqlMethods.Like (c.Username, "%" + txtSearchCriter ia.Text +
"%")
select c;

I get the following error:
Method Boolean Like cannot be used on the client it is only for translation
to SQL

Is there a way I can use Linq to get what I want and stay client side?

[=?Utf-8?B?YnJ1Y2UgYmFya2Vy?=]

use standard c# string functions:

filteredData = from c in employees
where c.Username.ToUp per().IndexOf(t xtSearchCriteri a.Text.ToUpper) >= 0

you could easily implement a Like string extension that did this and have:

filteredData = from c in employees
where c.Username.Like (txtSearchCrite ria.Text)
-- bruce (sqlwork.com)
"Mike Collins" wrote:

I want to allow users to search last names, using wildcards.

When I try to following in my web app:

//employees data was previously retrieved and stored in ViewState.
var filteredData = from p in employees.ToArr ay() select p;
filteredData = from c in employees
where SqlMethods.Like (c.Username, "%" + txtSearchCriter ia.Text +
"%")
select c;

I get the following error:
Method Boolean Like cannot be used on the client it is only for translation
to SQL

Is there a way I can use Linq to get what I want and stay client side?

[=?Utf-8?B?TWlrZSBDb2xsaW5z?=]

Doh! Leave to me to forget about IndexOf :) Thanks.

"bruce barker" wrote:

use standard c# string functions:

filteredData = from c in employees
where c.Username.ToUp per().IndexOf(t xtSearchCriteri a.Text.ToUpper) >= 0

you could easily implement a Like string extension that did this and have:

filteredData = from c in employees
where c.Username.Like (txtSearchCrite ria.Text)
-- bruce (sqlwork.com)
"Mike Collins" wrote:

I want to allow users to search last names, using wildcards.

When I try to following in my web app:

//employees data was previously retrieved and stored in ViewState.
var filteredData = from p in employees.ToArr ay() select p;
filteredData = from c in employees
where SqlMethods.Like (c.Username, "%" + txtSearchCriter ia.Text +
"%")
select c;

I get the following error:
Method Boolean Like cannot be used on the client it is only for translation
to SQL

Is there a way I can use Linq to get what I want and stay client side?

[Lloyd Sheen]

"Mike Collins" <Mi*********@di scussions.micro soft.comwrote in message
news:1E******** *************** ***********@mic rosoft.com...

>I want to allow users to search last names, using wildcards.

When I try to following in my web app:

//employees data was previously retrieved and stored in ViewState.
var filteredData = from p in employees.ToArr ay() select p;
filteredData = from c in employees
where SqlMethods.Like (c.Username, "%" + txtSearchCriter ia.Text +
"%")
select c;

I get the following error:
Method Boolean Like cannot be used on the client it is only for
translation
to SQL

Is there a way I can use Linq to get what I want and stay client side?

Use .contains/startswith/endswith on the field to get a 'LIKE' equivalent

LS