asp.net mvc - Dynamic query with LINQ won't work

Question

I've tried a couple of ways to execute a simple query but without success.

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

The above will give the error: No property or field 'bob' exists in type 'Person'

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

The above will give the error: Character literal must contain exactly one character

Has anyone else had these problems and what did you do?
Isn't Dynamic LINQ suppose to work like this or are there older versions or something?

I've added the Dynamic.cs to my project and I'm using System.Linq.Dynamic.

Answer 1

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.