CODEWITHSUNDEEP
c#.netdynamic-linq
Dinesh
Dinesh

Reputation: 423

Dynamic string in linq c#

I have installed System.Linq.Dynamic dll and then tried to add string as the parameter of WHERE clause in Linq. But I am still getting error that the string parameter is supported by WHERE clause.

Code:

_dbContext.TmRecords.Where("city=london");

Error:

Severity Code Description Project File Line Error CS1503 Argument 2: cannot convert from 'string' to 'System.Linq.Expressions.Expression>' Extranet.Domain

Here the city parameter dynamically changes to some other parameter. So, I need to use dynamic queries in linq.

Upvotes: 2

Views: 3264

Answers (1)

Hamid Pourjam
Hamid Pourjam

Reputation: 20754

You should add using System.Linq.Dynamic; to your file.

Also rewrite the query like this:

_dbContext.TmRecords.Where("city = @0", "london");

Upvotes: 7

Related Questions