score:11

Accepted answer

When doing comparisons you need two == and also in order to avoid injection use the following overload:

var result = db.Persons.Where("surname == @0", "bob");

Also I would recommend you downloading and looking at the examples provided with the product you are using. Scott Gu has also blogged about it.

score:5

var result = db.Persons.Where("surname == \"bob\"");

would work, though you should make sure whatever bob really is is properly escaped too.

That said, you would do better to have something like this:

String bob = "bob"; // or whatever
var result = from p in db.Persons p
             where p.surname = bob
             select p 

Related Articles