I haven't used Linqpad in a long time but one of the most useful features it had was the ability to add connections to your SQL Server databases and then write quick throwaway LINQ/Lambda style syntax queries against it, e.g. radios.GroupBy(x=> x.Channel).Select(x=>x.OrderBy(y=>y.Price)).Select(x=>x.First()); If I remember correctly, it also let you compare the LINQ query against the transpiled SQL so you could try t…
I haven't used the .NET Core version but the old one 100% had a view to see the generated sql.
I often write/compile .NET Core code in watch mode and then use LinqPad to explore existing libraries.