Azure-cosmos-dotnet-v3: LINQ - new ignore case flags do not work

[wahyuen]

We are continuously addressing and improving the SDK, if possible, make sure the problem persist in the latest SDK version.

Describe the bug
From https://github.com/Azure/azure-cosmos-dotnet-v3/issues/1615#issuecomment-646398795

Linq to SQL not implemented for this yet?
Just upgraded to latest, and it misinterprets the parameters

3.9.1
Expression
(x => x.FromName.ToLower().Contains(nameLower))

SQL
CONTAINS(LOWER(root["fromName"]), "searchString")

3.10.1
Expression
(x => x.FromName.Contains(name, StringComparison.OrdinalIgnoreCase))

SQL
AND CONTAINS("searchString", 3)

To Reproduce
Execute a LINQ query to Cosmos passing in an IgnoreCase parameter`

Expected behavior
SDK to generate SQL to ignore case when performing the query

Actual behavior
Does not generate SQL that ignores case

Environment summary
SDK Version: 3.10.1
OS Version (e.g. Windows, Linux, MacOSX) Windows

Additional context
Add any other context about the problem here (for example, complete stack traces or logs).

[bchong95]

@khdang any estimates on the LINQ updates?

[wahyuen]

any news if this is something that is planned for development any time soon? or is this something further down the track?

[kweebtronic]

Really need this feature parity! I'm duplicating lower-cased data just to work around this right now

[j82w]

@wahyuen and @kweebtronic 3.12.0 is released with the support.