No property or field 'DynamicFunctions' exists in type 'Log'

[JamesRoche]

I keep getting this error thrown when trying to use DynamicFunctions.Like() in my queries. I can also see in the examples on the website that they are suffering from the same issues. Has this API been changed?

JS Fiddle from your site which also failed https://dotnetfiddle.net/dy4vkE

[StefH]

Correct, I could not get this Fiddle working. (@JonathanMagnan : can you remove this one please)

@JamesRoche : See this example c# where it does work:
https://github.com/zzzprojects/System.Linq.Dynamic.Core/blob/master/src-console/ConsoleAppEF2.1.1/Program.cs#L130

[JamesRoche]

You are a legend thank you :)

[JamesRoche]

I have implemented as per the example you sent over, should this be translating into a LIKE SQL for entity core?

[StefH]

I've the feeling that for EF Core, it's still evaluated client-side. Not 100% sure....

[JonathanMagnan]

See the section about "LINQ queries are no longer evaluated on the client"

https://docs.microsoft.com/en-us/ef/core/what-is-new/ef-core-3.0/breaking-changes

New behavior
Starting with 3.0, EF Core only allows expressions in the top-level projection (the last Select() call in the query) to be evaluated on the client. When expressions in any other part of the query can't be converted to either SQL or a parameter, an exception is thrown.

So anything in the "WHERE" part should not.

[artnova-david]

Hi,
I'm also having the same issue this simple query gives the error "No property or field 'DynamicFunctions' exists in type 'Customer'". I installed the necessary dll's but still not working. Am I missing something?
var config = ParsingConfig.DefaultEFCore21;
config.ResolveTypesBySimpleName = true;
return await _db.Customers.Where(config, "DynamicFunctions.Like(Name, \"%a%\")").ToListAsync();

Thanks for your response
Kind regards