LIKE with Linq to Entities
This should do the trick.
from u in context.users
where System.Data.Linq.SqlClient.SqlMethods.Like(
u.Name,
"rodrigo%otavio%diniz%waltenberg")
select u
Edit:
It turns out this only works with LINQ2SQL, not LINQ2Entities.
Linq SqlMethods.Like fails suggests that you can use Where
directly on the table.
Yes, you can do this with ESQL/Query Builder syntax:
var matching = Context.Users.Where("it.Name LIKE 'rodrigo%otavio%diniz%waltenberg'");