Me and my team works a lot with ASP.NET MVC with Entity framework, and we have a lot of LINQ query written in the C# controller or in the DAL. We use sql server query profiler of SSMS to check the EF or LONQ generated query in the database and tune the LINQ query as needed. I would love to have the feature of query profiler, may be a light weight one with only Tracing t-sql will help a lot.
This is on our roadmap. It's not targeted for the December release but should make one of the early-2018 releases based on current progress.
In the meantime, you can use the command-line profiler:
https://github.com/ststeiger/sql_profiler
Note:
.NET Core supports only SQL-Server 2008R2+, so no SQL-Server-2005 profiling with this.
Finally this feature is in with June release. Thanks team for hearing and bringing this feature in my favorite SQL Operations Studio.

Feature added in June release.
Most helpful comment
Finally this feature is in with June release. Thanks team for hearing and bringing this feature in my favorite SQL Operations Studio.
