dinesh sns dinesh sns - 1 month ago 18
C# Question

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.

Answer

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

Also rewrite the query like this:

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