Like operator in Linq to DataTable?

c# linq linq-to-dataset
haansi picture haansi · Dec 16, 2010 · Viewed 8.5k times · Source

I am using Linq to DataTable. How I can apply like operator in where clause. I want to do a search on data just as we have like operator in SQL.

I searched and tried the following code but got an error: Method 'Boolean Like(System.String, System.String)' cannot be used on the client; it is only for translation to SQL.

var details = from addresses in dt.AsEnumerable() 
    where SqlMethods.Like(prefixText, prefixText + "%") || SqlMethods.Like(prefixText, "%" + prefixText + "%")
    select (string) addresses["Details"];                      

return details.ToArray();

Answer

Marc Gravell picture Marc Gravell · Dec 16, 2010

Your best bet may be to re-write it as a regex an use

where yourRegex.IsMatch(row.SomeValue)

Or if it is just starts-with queries:

where row.SomeValue.StartsWith(prefix)

Related questions

Select distinct rows from datatable in Linq

I am trying to get distinct rows based on multiple columns (attribute1_name, attribute2_name) and get datarows from datatable using Linq-to-Dataset. I want results like this attribute1_name attribute2_name -------------- --------------- Age State Age weekend_percent Age statebreaklaw …

Read More
How I can filter a dataTable with Linq to datatable?

hi how i can filter a datatable with linq to datatable? I have a DropDownList and there I can select the value of the Modul Column. Now I want to filter the DataTable with this Modul Column. here is my …

Read More
Fill Datatable from linq query

i am using the below code IEnumerable<DataRow> query = from c in at.appointmentcalendars.AsEnumerable() select c; DataTable dt = query.CopyToDataTable(); But i am getting the below error Cannot implicitly convert type 'System.Collections.Generic.IEnumerable<appointmentcalendar&…

Read More