C# lambda Expression In where clause

Question

I’m having issues creating an Where clause using C# and lambdas.

I have the following method GetRecommendedstudents(Guid studId)

The variable string filtersByRoles can hold a comma-delimited value such as: "xp,windows,windows8 or "xp,windows,windows8,windo " etc..

I then have the following C# lambda query:

I need get data from database by comparing 2 fields.

enter code here  
 var student= DataContext.students.Find(studId);
 ex: var x = DataContext.students.Where(L => (L.job == student.studentJobLocation)).AsQueryable();

Next i want comapare student know os("xp,windows,windows8 )

 ex: var y = x.students.Where(L => (s => (s.jobOperaitngsys.Split(',') == student.studentknowOS)), StringSplitOptions.RemoveEmptyEntries);

How to compare this to fields? jobOperaitngsys and studentknowOS

Please describe the problems you found when you tried to use the sample code. — phoog
– phoog, Commented Jan 25, 2014 at 6:25

Mostafa Soghandi · Accepted Answer · 2014-01-25 06:24:00Z

1

you should use contain. because split returns string array.

 s.jobOperaitngsys.Split(',').Contains(student.studentknowOS)

answered Jan 25, 2014 at 6:24

Mostafa Soghandi

1,6141 gold badge14 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

user123 Over a year ago

StringSplitOptions.RemoveEmptyEntries ,here it's showing error that cant used as statement.

Mostafa Soghandi Over a year ago

y = x.students.Where(s => s.jobOperaitngsys.Split(',').Contains(student.studentknowOS));

user123 Over a year ago

hi,it geting exception LINQ to Entities does not recognize the method 'System.String[] Split(Char[], System.StringSplitOptions)' method, and this method cannot be translated into a store expression.

Collectives™ on Stack Overflow

C# lambda Expression In where clause

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related