What methods are allowed when using Linq?

[weirdyang]

I noticed I can not using ToLower() and .Contains, what else should I avoid?

[hishamco]

YesSQL has some of LINQ like methods, but not all you can check the source code to know which are supported

https://github.com/sebastienros/yessql/blob/main/src/YesSql.Abstractions/IQuery.cs

[weirdyang]

YesSQL has some of LINQ like methods, but not all you can check the source code to know which are supported

https://github.com/sebastienros/yessql/blob/main/src/YesSql.Abstractions/IQuery.cs

Sorry I meant the operators and methods I can use within the Linq methods, like those I've shared in my OP, eg. String.ToLower(), using String.ToLower() throws an exception.

[hishamco]

ToLower() and Contains()` are string methods how they are related? Where did you call them?

[weirdyang]

Please see the op, I said within the linq extensions, eg Where(x => x.Name.ToLower() == "test").

Doing this will cause yessql to throw an exception.

For exampl in ef core using unsupported or untranslatable methods results in client side evaluation

For to linq to sql here are the unsupported string methods
https://learn.microsoft.com/en-us/dotnet/framework/data/adonet/sql/linq/system-string-methods

[MikeAlhayek]

Here is a list

yessql/src/YesSql.Core/Services/DefaultQuery.cs

Line 137 in 1ff3fd3

{

• .StartsWith("") and .StartsWith('')
• .EndsWith("") and .EndsWith('')
• .Contains("") and .Contains('')
• .Concat([""]) .Concat(""), .Concat("", ""), .Concat("", "", ""), and .Concat("","","","")
• .Min(), .Max(), .Count(), .Average(), .Sum()
• IsLike("")
• IsNotLike("")
• .NotContains("")
• IsIn([])
• IsNotIn([])

[weirdyang]

Here is a list

yessql/src/YesSql.Core/Services/DefaultQuery.cs

Line 137 in 1ff3fd3

{

• .StartsWith("") and .StartsWith('')
• .EndsWith("") and .EndsWith('')
• .Contains("") and .Contains('')
• .Concat([""]) .Concat(""), .Concat("", ""), .Concat("", "", ""), and .Concat("","","","")
• .Min(), .Max(), .Count(), .Average(), .Sum()
• IsLike("")
• IsNotLike("")
• .NotContains("")
• IsIn([])
• IsNotIn([])

thanks!!

[hishamco]

DefaultQuery implements IQuery which I refer to last week :)