LOWER and REPLACE doesn't work on dynamic linq where statement

Question

Here is my code ,

db.myDBContext.my_tables.Where("REPLACE(LOWER(name),\" \",\"\") == \"{0}\"", value);

it show the error

No applicable method 'LOWER' exists in type 'my_table'

can't I use REPLACE and LOWER in dynamic linq clause ?

Is `name` supposed to be a variable representing a column name, or is it literally a column named "name"? — Crowcoder, Jul 05 '16 at 12:18

score 1 · Accepted Answer · answered Jul 05 '16 at 12:59

Dynamic Linq doesn't understand T-SQL. You will want to craft it this way:

.Where(string.Format("(name).ToLower().Replace(\" \", \"\") == \"{0}\" ", value))

There is an analog for ToLower and Replace in T-SQL and Linq knows how to translate them from c#. But if name is a static column name then @Jonny is on to something. You don't need Dynamic Linq here (unless this is just a contrived example of a bigger problem you are solving).

score 0 · Answer 2 · answered Jul 05 '16 at 12:05

0

How about building it this way?

Where(t=>t.name.toLower() == value)

answered Jul 05 '16 at 12:05

Jonny

1,037
7
15

LOWER and REPLACE doesn't work on dynamic linq where statement

2 Answers2