Contains extension method on arrays is resolved from MemoryExtensions instead of Linq breaking EF queries

[ilGianfri]

Description

When using the .Contains extension method on an array inside an EF query, it uses the method .Contains from System MemoryExtensions instead of the System.Linq one breaking the query.
It throws "An exception was thrown while attempting to evaluate the LINQ query parameter expression"

Disabling LangVersion preview "fixes" the issue.

Reproduction Steps

• Create a console project with EF In Memory database
• Set langversion preview
• Add data to the db table
• Create a string[] with some values in it
• Write a query that searches inside the db table the values in the string[] with a contains
• Run the app

I've attached a simple repro app ConsoleApp2.zip

Expected behavior

The .Contains method should be resolved to System.Linq or it should be accepted by EF so that the query can be translated to sql.

Actual behavior

The .Contains method is resolved from System MemoryExtensions that works on Spans making it not supported as a query

Regression?

I think this is a regression because if I use LangVersion Latest it starts working

Known Workarounds

Use a List instead of an array or simply use LangVersion Latest instead of Preview.

Configuration

• Which version of .NET is the code running on? .NET 8.0 and 9.0 both have this issue with langversion Preview
• What OS and version, and what distro if applicable? Windows 11 26100.2314
• What is the architecture (x64, x86, ARM, ARM64)? x64
• Do you know whether it is specific to that configuration? I don't think its specific to this config

Other information

I think the issue is cause by the OverloadResolutionPriority set to -1 in the MemoryExtensions .Contains method

[stephentoub]

Duplicate of #109757 ?

[ilGianfri]

Duplicate of #109757 ?

Sorry I missed that one, I've posted a comment with the repro app on that issue now.