C # SqlMethods how not working

Question

I am new to using Linq and cannot get the SqlMethods.Like function.

Here is my simplified example:

List<string> mylist = new List<string>(); mylist.Add("100"); mylist.Add("101"); mylist.Add("102"); mylist.Add("103"); mylist.Add("104"); mylist.Add("105"); mylist.Add("106"); mylist.Add("107"); var filtered = mylist.Where(x => SqlMethods.Like(x, "10%")); foreach (var record in filtered) { textBox1.Text += record + "\n"; } 

My variable called filter is returned empty. What am I missing?

If I use x.Equals ("100"), I return the results.

Answer 1

SqlMethods.Like

Determines whether a particular character string matches the specified pattern. This method is supported only in LINQ to SQL queries.

Your query is not a LINQ to SQL query.

Answer 2

In your case, use:

 var filtered = mylist.Where(x => x.Contains("10")); 

Answer 3

You can use Contains operator instead of Like

Answer 4

Could you use Contains

 var filtered = mylist.Where(x => x.Contains("10")); 

If you really want SQL LIKE , you can use System.Data.Linq.SqlClient.SqlMethods.Like(...) , which LINQ-to-SQL maps to LIKE in SQL Server.