11,571 questions
Yes using the following tool. Works with ADO and Entity Framework Core. Also note that with newer versions of EF Core there is .TagWith that shows up in SQL-Server profiler.
Database Profiling in Visuals Studio 2019 IDE
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(185.6, 24%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKK%3C/text%3E%3C/svg%3E)
Kiran Kumar
1
Reputation point
I have application in Framework 4.6 and build in Visual studio 2019 Professional , Can we get the profile option for database transactions
Developer technologies | C#
2 answers
Sort by: Most helpful
-
Karen Payne MVP 35,586 Reputation points Volunteer Moderator2021-06-24T19:27:03.247+00:00 -
Kiran Kumar 1 Reputation point
2021-06-25T04:58:49.023+00:00 Hi Karen
I know this tool works for only core framework , but I want to know whether works for .NET Framework 4.6,7 or 8 c# web/windows/webapi applications
And you mentioned one thing apart from core that is component usage to connect database I have oracle database with nuget packages Oracle.ManagedDataAccess with useual commands dataadapter , dataset , datatable using my application , can we trace db transactions for this scenario of execution
-
Karen Payne MVP 35,586 Reputation points Volunteer Moderator
2021-06-25T13:53:46.797+00:00 I assume you tried already which is why you are asking. I don't have any projects left prior to .NET Core to test this out. What I use is Jet Brains doTrace which will do any framework.
There are several pricing options but the only free license is for students.
A peek at dotTrace working with Oracle
-
Kiran Kumar 1 Reputation point
2021-06-25T14:47:48.807+00:00 Hi Karen
What we need is different from the tool you are providing I can see built in Data profile works only for Framework core applications where as I need that same feature in Framework 4-8 versions
As you mentioned it will work only for core projects not for MVC.NET 4.8 projects please confirm thaat
Yes I tried core project with oracle database in win form app even that did not provide any results after the function execution In that as I said EF is not implemented just Oracle nuget package with normal execute commands , so just want to know which type of code needs to be implemented even for core to access database transaction in profiler.
However for now core is not my project requirement and we cannot migrate our entire application.
As you suggested I will try to analyze the Jet Brains tool for my requirement
Please provide some more details about this tool how to use or any test project that can help in detail
Regards,
Kiran Kumar -
Karen Payne MVP 35,586 Reputation points Volunteer Moderator
2021-06-25T15:01:32.417+00:00 As you mentioned it will work only for core projects not for MVC.NET 4.8 projects please confirm thaat
I can't, all my projects are .NET Core as mentioned in my last reply as I converted all from 4.8. I would need to create new projects to confirm this.
Please provide some more details about this tool how to use or any test project that can help in detail
There is plenty of information for dotTrace on their site.
-
Kiran Kumar 1 Reputation point
2021-06-25T17:14:33.773+00:00 yes I tried in .Net framework apart from core I cannot get the Database profiling option If you find solution for Framework 4.5 to 8 please share to me
Jet Brains seems plenty of option but that I couldnt to install due to need some permission to install and analyse it
Thanks for you help in providing the suggestions
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(115.19999999999999, 4%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETY%3C/text%3E%3C/svg%3E)
Timon Yang-MSFT 9,606 Reputation points2021-06-29T09:14:10.713+00:00 @Kiran Kumar
If you want this feature to work for .Net Framework, you can choose to suggest a feature in the upper right corner of Visual Studio, and the Visual Studio team will consider your suggestion. This feature may be added in a future version.
Sign in to comment -