How do I do a "like" wildcard comparison in Entity Framework in .NET 4.0?

Question

I'm using the Visual Studio 2010 RC for .NET 4.0 and I'm trying to figure out how to do a wildcard comparison with Entity Framework.

I'd like to have the following query for EF where I find all the names that start with 'J'

select * from Users where FirstName like 'J%'

Answer 1

Use:

var query = Users.Where(user => user.FirstName.StartsWith("J"));

Answer 2

from user in Users where user.FirstName.StartsWith("J") select user;

Answer 3

I would refer you to this question, I assume it hasn't changed in .net 4.0