Like

Results can be filtered by using the Like method of a string expression.

This example selects records where a person's first name is David and the last name starts with W:

IEnumerable<Person> persons = db.SelectMany<Person>()
	.From(dbo.Person)
	.Where((dbo.Person.FirstName + " " + dbo.Person.LastName).Like("David W%"))
    .Execute();