Comparing FirstOrDefault and SingleOrDefault
This is an EF Core experiment measured with the popular BenchmarkDotNet library. You will find the benchmark results and the source code to reproduce everything on your machine and answer the question on the performance impact of the System.Linq methods SingleOrDefault() vs FirstOrDefault(), especially in the case of an indexed column.