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%'

David Morton · Accepted Answer · 2010-03-04T01:50:49.273

9

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

edited Mar 04 '10 at 01:50

answered Mar 04 '10 at 01:04

David Morton

@David you're missing the needed `select user` at the end for query expressions. – Ahmad Mageed Mar 04 '10 at 01:41

score 3 · Answer 2 · answered Mar 04 '10 at 01:04

3

Use:

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

answered Mar 04 '10 at 01:04

Ahmad Mageed

score 0 · Answer 3 · edited May 23 '17 at 12:14

0

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

edited May 23 '17 at 12:14

Community

answered Mar 04 '10 at 01:04

csjohnst

3 Answers3