Using two or more Where in a query in EF

[Majid Shahabfar]

How can I use OR between two or more Where in a query in EF like this?

var docs = Documents.Where(c=>c.Title.Contains("string").Where(c=>c.Subject.Contains("string"));

[Ian McCaul]

Try this

var docs = Documents.Where(c=>c.Title.Contains("string") || c.Subject.Contains("string"));

[r3m1x]

In Linq2Sql I would have done this: var docs = Documents.Where(c => c.Title.Contains("string") && c.Subject.Contains("string")); Most likely it will work for ef too. Hope it helps!

[r3m1x]

Wouldn't the statement be OR? Does he want and? Unless that is what he wants I apologize :)