Linq is equivalent to SQL LIKE [af]

Question

SELECT * FROM Customer WHERE Name 'LIKE [af]%'

How can I achieve this in Linq?

In other words, in linq, how can I select all the names between a and f?

Thanks,

Answer 1

The class System.Data.Linq.SqlClienthas a helper class called SqlMethods , which provides a method Likethat emulates the SQL LIKE statement.

Your request:

var query = from c in Customers
            where SqlMethods.Like(c.Name, "[a-f]%")
            select c;

Answer 2

You can use the C # Regex class to map entries:

var selectedCustomers = from customer in customers
               where Regex.Match(customer.Name, "^[a-f].*$").Success
               select customer;