showing incorrect syntax near the keyword With

Question

following query showing incorrect syntax near the keyword 'with'. if this statement is a common table expression. when using contains in linq after update .net 6.0 to 8.0  

 

var query = from entity in dbContext.YourEntity 
            where entity.SomeProperty.Contains(someValue) 
            select entity;