Query Sorts Differently Depending on Selected .Net Version
Hi all. I have a C# query in LinqPad that sorts differently depending on whether I choose .Net Core 3.x versus .Net 5.0. The .Net 5.0 sort is "correct". Any idea why the sort is different depending on the version of .Net I'm using? I'm trying to get a query to sort the same way it does in SQL Server. The .Net 5.0 result is more like what I'm expecting to see.
Comments
You didn't provided any details on what kind of sort you use, so I can only suspect that it is caused by .net 5 migration to ICU: https://docs.microsoft.com/en-us/dotnet/standard/base-types/string-comparison-net-5-plus